February 26, 2015 at 10:10 pm
Comments posted to this topic are about the item Maximum number of databases per instance
February 27, 2015 at 12:59 am
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 27, 2015 at 3:10 am
Now, I want to try!
😀
February 27, 2015 at 5:32 am
I had to research this one. The real question is would anyone want that many on a single instance.
February 27, 2015 at 6:38 am
Easy one.
What's interesting is that 32767 is the upper limit for SMALLINT (2-byte/16-bit integers). Yet, the database identifier has a data-type of INT, not SMALLINT. I guess that's it came from the days before SQL 2000?
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
February 27, 2015 at 6:50 am
Wow, that all. Well, I guess I will inform my team that thing might get a little tight. Maybe the next version will give us a little more breathing room...
February 27, 2015 at 7:01 am
Ugh, why would they limit you like that! :-D:laugh:
February 27, 2015 at 7:03 am
I knew the answer since this has been asked before. Much like the last time the "unlimited" response is sort of correct because nobody in their right mind would have anywhere near that many. One of these times I am hoping for a "more than you should ever put on a single instance". 😀
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 27, 2015 at 7:10 am
Simple question, thanks
February 27, 2015 at 7:13 am
Carlo Romagnano (2/27/2015)
Now, I want to try!😀
+1
February 27, 2015 at 7:47 am
Thanks for the question!
February 27, 2015 at 9:57 am
Thanks for the question.
---------------
Mel. 😎
February 27, 2015 at 10:07 am
Carlo Romagnano (2/27/2015)
Now, I want to try!😀
I did the last time this question was asked.
I can;t remember the error that was thrown when it hit 32768.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
February 27, 2015 at 10:31 am
Hi Nakul ,
Maybe a database is surely the object which "owns" the most important count of child objects ( 1 datafile , 1 logfile , a table with at least a column , that's to say 4 objects but it is difficult to use such a database).
This limit maybe exists only for one reason : how to retrieve easily a specific database in a list with 32768 names even if this list is sorted.
February 28, 2015 at 5:08 am
Carlo Romagnano (2/27/2015)
Now, I want to try!😀
How is it going? Done yet?:-D
😎
Viewing 15 posts - 1 through 15 (of 21 total)
You must be logged in to reply to this topic. Login to reply