Sorry, for jumping right in

SQL Server MVP Erland Sommarskog has two frequently referenced article which might also give some additional help in this...

Try to use a file recovery tool and pray that nothing is overwritten yet. Otherwise I think, you're pretty much out of luck. May I add, that the use of...

See, if this helps:

http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm

Google and you'll find numerous threads on this topic. Each serious book contains a least one chapter and Joe Celko did a whole book on this....

These are all sane and valid arguments, Kenneth!

So, it depends...(err, stealing your phrase )

Now, as a DATETIME is currently implemented, and to add to...

Just a note on creating user-defined objects in master.

I think this makes maintenance and disaster recovery more difficult. Since you didn't make this function a "true" system function, it might...

See, if this helps:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=153641

Just a note on the original query. The SUM aggregate is pretty useless without a GROUP BY. In fact, your query should yield an error

use northwind

select orderid, isnull(sum(unitprice),0) unitprice

from [order...

Is there an advantage to using CAST over CONVERT?

CAST is the ANSI way of doing things. IIRC, even MS recommends this over CONVERT. Though only CONVERT allows for the...

This is by far the most complete discussion on BLOBs and SQL Server I know 

http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx

HTH

To add to Kathi: The date format you see, is not what is stored in a DATETIME column. Internally SQL Server stores such values as BINARY(8) containing 2 INTEGERs for...

Sorry, besides the links I can't help you with this. Here we are not allowed to install XP SP2. Another option might be to search the Google groups. I have...

This is a neat trick, Dave.

However, it has a major disadvantage, which effectively rules this out here as an option. You are not able to explicitely force an ordering of...

Next week will be a busy week for me then

This is better than getting bored at work!

See, if this helps:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546

Congrats to all winners!

Well, actually there is not much more to say. The number speaks for itself. It's impressive, it's amazing, it's ...cool.

Keep...