Viewing 15 posts - 6,046 through 6,060 (of 7,636 total)
Thanks for the feedback JJ. I think that (appropiate) humor is an important part of work and life too. Glad you liked the joke!
😀
August 5, 2008 at 5:04 pm
You said that the vendor will support 2005 if the database is in mode 80, but you didn't say if they would support 2008 in mode 80?
Also, 2008 is not...
August 5, 2008 at 4:50 pm
Could you please attach the XML Execution Plans for both of these queries. I am very interested if trying to figure out what cases cause this to happen (despite...
August 5, 2008 at 4:35 pm
Wayne West (8/5/2008)
Very cool article, my hat is off to you.
Thanks, Wayne.
Oh, and you might find the Four Yorkshiremen, if memory serves, is actually (technically) NOT Monty Python: it was...
August 5, 2008 at 4:11 pm
Lynn Pettis (8/5/2008)I think, in this particular case, it has to do with the INFORMATION_SCHEMA views. I played with them in SQL Server 2000, and for those to work...
August 5, 2008 at 3:17 pm
Jeffrey Williams (8/5/2008)
You would do this:Execute sp_MS_marksystemobject sp_mytest;
And that should setup the procedure so it runs in the context of the database where it is executed.
Very nice, Jeffrey! I...
August 5, 2008 at 2:46 pm
Christian Buettner (8/5/2008)
And awesome technique.
...
And while we are at it, does anyone know how to add color IF codes? When I add them, they display as text like here:...
August 5, 2008 at 2:39 pm
Andras Belokosztolszki (8/5/2008)
One solution is to add the stored procedures to the master database, and add sp_ prefix to their names(bad practise)
Well, this works in the sense that SP_FOO...
August 5, 2008 at 2:08 pm
OK, try this:
Select TOP 99999999 PC.PC
, PC.PC_DomainName
, Drives.Drive
, Drives.Drive_Size
, Drive_FreeSpace
, Identity(int) as ID
, Cast(0 as int) as N
Into...
August 5, 2008 at 1:43 pm
timothyawiseman (8/5/2008)
Awesome article. It is good to know and makes me very glad that memory was much less constrained than that by the time I started programming.
Thanks for the...
August 5, 2008 at 11:58 am
Jonathan Rynd (8/5/2008)
Likewise, the F's are stored as "01000110" in upper-case and "01000110" in lower
I've looked very closely, and I can't see any difference between those two. Or maybe you...
August 5, 2008 at 11:55 am
Paul.Allen (8/5/2008)
August 5, 2008 at 10:11 am
I think that the first statement should always take the TRUE branch, so maybe you just didn't have any NULLS before you added your new columns?
August 5, 2008 at 9:59 am
The editor ate your XML Andrew. Attach them as files instead of inserting their contents.
August 5, 2008 at 9:49 am
Viewing 15 posts - 6,046 through 6,060 (of 7,636 total)