SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Views


Views

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)

Group: Administrators
Points: 225100 Visits: 19638
Comments posted to this topic are about the item Views

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
henrik staun poulsen
henrik staun poulsen
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3137 Visits: 1238
except if you use a Table Value UDF (User Defined Function), as this example shows:
http://www.sqlservercentral.com/articles/Dynamic+SQL/65154/

Best regards,
Henrik Staun Poulsen
www.stovi.com



Shaun McGuile
Shaun McGuile
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1549 Visits: 1060
9% chose 30,000 - these people should not be anywhere near a keyboard never mind a database. BigGrin

31% picked 1024 - These people have no google skills. BigGrin

54% - got it right which implies, as I was one of them, that I know more than some people.Wink

6% - went for 32 these I would forgive for trying to be sensible. Like who adds more than 32 tables to a query - typing the SQL for the joins would be so fraught with risk.Tongue

Well we should all realise that putting 256 tables into a Select is a bad idea to start with anyway....

Does putting 20 tables into a view and then using 20 such views count as 400 tables or just 20?

--Shaun

Hiding under a desk from SSIS Implemenation Work Crazy
Arshad Ali-556241
Arshad Ali-556241
SSC Veteran
SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)

Group: General Forum Members
Points: 240 Visits: 194
More details on "Maximum Capacity Specifications for SQL Server" can be found on the below given link:

http://msdn.microsoft.com/en-us/library/ms143432.aspx

With Thanks and Regards
Arshad Ali
Microsoft India

My Blog - http://arshadali.blogspot.com/
Scott Arendt
Scott Arendt
SSCertifiable
SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)

Group: General Forum Members
Points: 5008 Visits: 1731
Shaun McGuile (12/12/2008)
Does putting 20 tables into a view and then using 20 such views count as 400 tables or just 20?


In SQL Server 2000 (not sure about 2005 or 2008), it would count as 400. We used to have tables for each month and then views that covered an entire year and I would run into the limit often when trying to pull some data from them.

Scott
Steve Jones
Steve Jones
SSC Guru
SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)

Group: Administrators
Points: 225100 Visits: 19638
Actually that's a distribution I would expect. this is a trivia question/answer, and unless you'd read Henrik's article the other day, it would be easy to have 1024, a logical number, or 30,000 stick in your head.

30,000 has been thrown around a lot as its' the limit for sparse columns, someone might remember reading that.

1024, lots of 1024 limits in computing.

32 nesting levels in a trigger, might get confused, but that seems like a low, albeit more practical to read, number of tables in a trigger.

You can google if you want for answers, but it somewhat defeats the idea. You know it or you don't. If you google, then you are semi-cheating yourself on the score.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Jerry Hung
Jerry Hung
SSCertifiable
SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)

Group: General Forum Members
Points: 5382 Visits: 1208
I guessed wrong (1024), such a natural number.... Tongue

It's really a trivia. no Google beforehand

I still remember the discussion about max # of nonclustered indexes (which is 249), and how Microsoft came to that number is just... unknown. It's not 256, or 255.

http://msdn.microsoft.com/en-us/library/ms189280(SQL.90).aspx

The maximum number of nonclustered indexes that can be created per table is 249.


SQLServerNewbie

MCITP: Database Administrator SQL Server 2005
Shaun McGuile
Shaun McGuile
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1549 Visits: 1060
My Total guess =

1 Clustered + 249 Non Clustered + 6 spare slots (for internal use) = 256 indexes BigGrin

How's that sound Jerry?

--Shaun

Hiding under a desk from SSIS Implemenation Work Crazy
Anipaul
Anipaul
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11899 Visits: 1407
Actually you can guess with the options. There should have been options with 128 and 512 which would make this question more interesting.



Jon Summers
Jon Summers
Mr or Mrs. 500
Mr or Mrs. 500 (528 reputation)Mr or Mrs. 500 (528 reputation)Mr or Mrs. 500 (528 reputation)Mr or Mrs. 500 (528 reputation)Mr or Mrs. 500 (528 reputation)Mr or Mrs. 500 (528 reputation)Mr or Mrs. 500 (528 reputation)Mr or Mrs. 500 (528 reputation)

Group: General Forum Members
Points: 528 Visits: 45
Books OnLine for 2008:
Tables per SELECT statement : Limited only by available resources

Regards, Jon Summers
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search