SQL is Structured Query Language. It's a language designed for querying sets of data (http://en.wikipedia.org/wiki/SQL)

SQL Server is a RDBMS, database product, from Microsoft. It is built to run on Windows,...

I work for Red Gate, but their tool or any other compare will do this very inexpensively. It sounds like a decent sized purchase for your boss, but consider your...

Those white papers cost money. The payback is salesman contacting people and making some sales. It's the same thing for contests. They pay for the prices when making a few...

You can use the DAC if you are a local administrator to connect and reset things

http://blogs.msdn.com/sqlexpress/archive/2005/09/08/462609.aspx

So, in addition to doing a restore, you need to check your hardware. This could happen again.

Did you upgrade SQL 2000, or add a 2008 instance or do something else? If you have two instances, you might be eating up memory as well.

Have you run this from just SSMS or SQLCMD?

I doubt this is corrupting tempdb, but it would be good to run this without a VB client to see more details.

As a hint, a cross tab or PIVOT might be what you need.

What do you mean, concatenate rows? Specific counts, or a however many meet some criteria?

Showing some sample data and DDL would help.

I could live with the 24 clock, but I like DST, and I like my pounds, inches, and miles!

These forums, I think, do require pointing out of mistakes for the reasons Jay mentioned. However if it's something like a typo, I have pinged people to privately edit their...

To see history, I think you need a Google account that you are signed into when you search. I typically remain signed in with Google on my machines

There is a lot of money to be made selling information about people. Years ago I worked in a startup and we would regularly get lists of people to email/call...

This is something to keep in mind as you work on old code as well. If you have a 2005/008 system with these types, refactor the code to use the...

Very nice editorial, Tim, and I'll respond before I head out for a much needed break today.

Whether it's business communication, or posting here on the forum, I think small errors...