Well, I for one feel old. I'm about to go lie in bed with the laptop and a heating pad on my back. Between that and the snow, it's not...

Really? AFAIK an integer hold a few billion:

http://msdn.microsoft.com/en-us/library/aa933198(SQL.80).aspx

I'm with George, I think multiple instances are a pain. The only load issue I see is that you can separate out tempdb issues with separate instances.

Memory isn't optimized. The...

Actually we added some tags yesterday 🙂

http://www.sqlservercentral.com/Forums/Topic698708-83-1.aspx

I'll add that to my list. It is a good idea.

Personally I don't answer questions in email at all. They need to post it somewhere.

I'm sure it will get dog fooded at some point. Microsoft does a good job pushing their apps internally to staff to test early. If they get a cloud version...

I'm second'ing, or thirding the advice above. DO NOT delete backup files before the next backup is written. If you're out of space, get more. Any manager that wants...

There are a few log tools, such as ApexSQL's, that can read the transaction log and potentially get the data back. They won't have security information, but they'll tell you...

Do you mean your questions or someone elses? For you, you can flip through the questions, filtering by tags.

And with that.....

we'll continue on, I guess.

Thanks for the update and glad it's working.

Perhaps, really this is a row by row operation, checking for a change in the first column, and if there isn't one, rewriting it with a blank.

I'll put out a...

You can't do this in T-SQL, or not in any way that would make sense for a report. Typically the front end for your reporting would ignore the repetitions. How...

SSMS is SQL Server Management Studio. That's correct.

I think the confusion is that SSMS should be the source for verifying how things are set. Not necessarily the registry as you...

SSMS is not a free tool. It's the tool built by MS and designed to connect to and manage SQL Server. It's installed as part of the client tools, and...