Viewing 15 posts - 2,941 through 2,955 (of 3,348 total)
Lynn Pettis (1/21/2010)
david.wright-948385 (1/21/2010)
Luck then!Nope.
Yes. Luck, because your server apparently has a model database the same size as that of the question author.
January 21, 2010 at 11:26 am
WayneS (1/21/2010)
stewartc-708166 (1/20/2010)
Beg to differwhen creating a new SQL2008 db, the mdf defaults to 3MB and the ldf to 1MB.
On my SQL2008 (Developer Edition, x64), the modeldev.mdf is 2MB and...
January 21, 2010 at 5:39 am
vk-kirov (1/21/2010)
Hugo Kornelis (1/21/2010)
The documentation on CREATE DATABASE is here: http://technet.microsoft.com/en-us/library/ms176061.aspx.The default log file size is only given in one of the examples (unless I overlooked something)
It is given in...
January 21, 2010 at 3:29 am
Since the author of the question didn't even bother to supply a reference for his (or her?) claims, I did his homework for him. The documentation on CREATE DATABASE is...
January 21, 2010 at 2:16 am
Tony Davis (1/19/2010)
Apologies to all -- I've now made a correction to the answers so that it applies correctly to SQL Server 2005.Best,
Tony.
No, Tony. You haven't. 🙂
SQL Server 2005 allows...
January 19, 2010 at 7:57 am
vk-kirov (1/19/2010)
Hugo Kornelis (1/19/2010)
Up to 1 clustered index, up to 999 nonclustered indexes, and up to 999 XML indexes (http://msdn.microsoft.com/en-us/library/ms143432.aspx), plus a number of full-text indexes and...
January 19, 2010 at 1:48 am
I chose an incorrect answer so I could get the llink to this discussion. And then, I was even rewarded with a point.
To add to the others, the correct answer...
January 19, 2010 at 12:35 am
Wow, I never knew I had that kind of influence on you, Steve.
Too bad I'm not allowed to run for president, as I'd be sure of at least one vote...
January 2, 2010 at 1:09 pm
tilew-948340 (1/2/2010)
January 2, 2010 at 9:57 am
setiv (1/2/2010)
Where I can search documents about undocumented ability ???
If a feature is undocumented, then you generally will not find any documents about it easily - that's exactly what makes...
January 2, 2010 at 3:50 am
An interesting QOD, educating people about some little-known features. But:
1) Why 3 points? It's not a hard question at all; everyone who knows about global temp objects (which SHOULD be...
January 1, 2010 at 5:05 am
Carleton (12/23/2009)
If you are unsure if the field contains a wildcard character when joining using the LIKE operator, you can avoid false positive results by observing this tip:
But what is...
December 24, 2009 at 5:10 am
What compatibility level are you using?
SELECT compatibility_level
FROM sys.databases
WHERE name = DB_NAME();
December 14, 2009 at 2:48 am
vk-kirov (12/12/2009)
Hugo KornelisThank you for explanation. Could you also explain why "under SQL Server 2000, the result is '1234' regardless of the number of NULLs appended"?
Thanks!
First, please be aware that...
December 12, 2009 at 12:09 pm
Arto ahlstedt (12/10/2009)
the NULL that is appended somehow contributes to the total length of the expression with an effective length of 1.
Got to love the "somehow"...
Since NULL can be of...
December 11, 2009 at 11:26 am
Viewing 15 posts - 2,941 through 2,955 (of 3,348 total)