2e4 was the easy part. But what are those two sets of 9 undersocre characters all about?...

A colleague of mine is doing some work for transferring data from SQL Server to MS Project and back using XML. He found a Java based open source package called MPXJ which is quite amazing. You mentioned Excel. I'm quite sure there is stuff out there fo...

I use single user mode also for restoring databases. In some testing/development environments you have to restore a database many times during a day. So you can't waste time finding out who/what is connected. You just disconnect everything... and restor...

"Out of the box" or "inside the box", maybe this is the best solution: http://www.sqlservercentral.com/articles/Tally+Table/72993/...

What you are trying to do is called 'unpivot'. You should seriously consider using XML for this: with cte as ( select student,cast('<m>'+replace(subjectcode,',','</m><m>')+'</m>' as xml) subjectcode,averagemark from myta...

It would be very difficult for human beings to read books without that wonderful point at the end of a sentence. In fact, it would be difficult even without commas. And sometimes I would not mind at all seing that semi-colon in the sql code I read. I...

Now would it not be nice to have a DMV that lists all DMVs? :-)...

Nice list. They could all be done with identity. But several of them can be done with sequence a lot easier....

I don't understand why Microsoft decided to add this feature. It exists in Oracle ever since I can rememer (Oracle 7?). And every since SQL Server 2000 (or prior?) we have been doing just fine with the identity column. So what is a real life scenario wh...

I think you mean sp_spacedused not spspaceused....