Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Script Library
 size of user tables in a database
 Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 3

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 11/08/2003 :  04:54:45  Show Profile  Visit nr's Homepage  Reply with Quote
>> When no index in books: Singleton >> 22 sec Cursor >> 2 sec.

If there is no index on the table you would create a table variable with a suitable index and loop through that - this is presumably what the cursor does.
See my previous post starting "What do you think a cursor is?"
And my signature.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

Stoad
Freaky Yak Linguist

*
1983 Posts

Posted - 11/08/2003 :  08:24:04  Show Profile  Visit Stoad's Homepage  Reply with Quote
OK, OK, Nigel,

I see what you mean. And your signature is great...

Only one thing. The 3rd line in it:

Beer is not cold and it isn't fizzy.

The hardest part to understand. What's wrong with beer in UK?
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 11/10/2003 :  10:13:03  Show Profile  Reply with Quote
quote:
Originally posted by Stoad

The hardest part to understand. What's wrong with beer in UK?



Short Answer: Nothing

Why do people drink Budwieser? The Budwieser girls...



Brett

8-)
Go to Top of Page

Arnold Fribble
Yak-finder General

United Kingdom
1961 Posts

Posted - 11/10/2003 :  10:27:26  Show Profile  Reply with Quote
quote:
Why do people drink Budwieser? The Budwieser girls...

Those are Girls? I thought they were frogs!
Go to Top of Page

Stoad
Freaky Yak Linguist

*
1983 Posts

Posted - 11/10/2003 :  13:17:53  Show Profile  Visit Stoad's Homepage  Reply with Quote
You are so funny, guys :) (c) Tara

BTW I think it is spelled as Budweiser.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 11/12/2003 :  12:40:36  Show Profile  Reply with Quote
Better yet...why do people drink Corona?

Just so they can put a lime in their beer?



Brett

8-)
Go to Top of Page

Stoad
Freaky Yak Linguist

*
1983 Posts

Posted - 11/12/2003 :  12:55:37  Show Profile  Visit Stoad's Homepage  Reply with Quote
Ever drunk Danny DeFoe #345?
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 11/12/2003 :  13:17:58  Show Profile  Reply with Quote
Never heard of it...is it wine, beer, or liquor?


Brett

8-)
Go to Top of Page

Stoad
Freaky Yak Linguist

*
1983 Posts

Posted - 11/12/2003 :  13:45:39  Show Profile  Visit Stoad's Homepage  Reply with Quote
It is a kind of local samogons. Very rich in its taste and aroma.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 11/13/2003 :  14:51:18  Show Profile  Reply with Quote
quote:
Originally posted by Stoad

It is a kind of local samogons. Very rich in its taste and aroma.



0

as in I have no idea what that is...

Brett

8-)
Go to Top of Page

Stoad
Freaky Yak Linguist

*
1983 Posts

Posted - 11/13/2003 :  16:08:58  Show Profile  Visit Stoad's Homepage  Reply with Quote
home-brew
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 11/14/2003 :  13:57:30  Show Profile  Reply with Quote
I love home brew

Used to make a bunch in the time BC *

Luckily I got a pub close to me

http://www.pubcrawler.com/Template/ReviewWC.cfm/flat/BREWERID=101834

* Before Childern



Brett

8-)
Go to Top of Page

Stoad
Freaky Yak Linguist

*
1983 Posts

Posted - 11/14/2003 :  14:49:47  Show Profile  Visit Stoad's Homepage  Reply with Quote
LOL.. Brett..

Be honest I am (just like Jim L) a teetotaller (spell correct?)..

Really.. drinking is so bore and just wasting of time..
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
38200 Posts

Posted - 11/14/2003 :  14:54:19  Show Profile  Visit tkizer's Homepage  Reply with Quote
quote:
Originally posted by Stoad


Really.. drinking is so bore and just wasting of time..



You must not be doing it right then.

Tara
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 11/14/2003 :  15:17:37  Show Profile  Reply with Quote
quote:
Originally posted by tduggan

quote:
Originally posted by Stoad


Really.. drinking is so bore and just wasting of time..



You must not be doing it right then.

Tara



LOL Tara...

I thought that was punch line to a joke about sex



Brett

8-)
Go to Top of Page
Page: of 3 Previous Topic Topic Next Topic  
Previous Page
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000