Viewing 15 posts - 7,591 through 7,605 (of 19,564 total)
jcrawf02 (12/8/2011)
SQLRNNR (12/8/2011)
ChrisM@Work (12/8/2011)
SQLRNNR (12/7/2011)
Took the plunge on 70-451Nice one, Jason!
Thanks
Was the braindump useful?:-D
Evil, evil, evil...
I try
December 8, 2011 at 11:59 am
L' Eomot Inversé (12/8/2011)
Cadavre (12/8/2011)
Boo, missed that 😛Here's my fixed version: -
<code snipped>
Drat, I missed out 6 casts ("0" changed to "cast(cast 0 as datetime) as date)" in three places!...
December 8, 2011 at 11:07 am
Cadavre (12/8/2011)
SQLRNNR (12/8/2011)
Yay. Now I know for sure that there are only 17 days until Christmas.
And knowing is half the battle.
time
/@
...
December 8, 2011 at 9:41 am
Koen Verbeeck (12/7/2011)
It should be easy to test.
WITH CTE_Numbers (number)
AS
(SELECT ROW_NUMBER() OVER (ORDER BY sc1.name) AS number
FROM master.sys.columns sc1, master.sys.columns sc2)
SELECT TOP 32767 'CREATE DATABASE...
December 8, 2011 at 8:49 am
GilaMonster (12/8/2011)
December 8, 2011 at 8:45 am
Elliott Whitlow (12/7/2011)
SQLRNNR (12/7/2011)
The local drive is far to small (Server 2008 R2 for instance will chew up most of that 50GB for just the OS).
Not sure I agree with...
December 8, 2011 at 8:45 am
Cadavre (12/8/2011)
L' Eomot Inversé (12/8/2011)
December 8, 2011 at 8:40 am
Dev (12/8/2011)
sp_who is still available in SS2K8 R2. I don't find any note on BOL that indicates its deprecation in Denali or later.sp_who (Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms174313(v=SQL.105).aspx
Correct. Part of the...
December 8, 2011 at 8:37 am
ChrisM@Work (12/8/2011)
SQLRNNR (12/7/2011)
Took the plunge on 70-451Nice one, Jason!
Thanks
Was the braindump useful?:-D
December 8, 2011 at 8:30 am
Viewing 15 posts - 7,591 through 7,605 (of 19,564 total)