I do stuff like what you are talking about all the time. I probably have a better way to write to a txt file other than a cmd_shell echo...

I don't look at the question of the day as a test, but as a research assignment.

I try not to answer it unless I am about 95% sure...

If you don't have internet access, then get a book. In fact get numerous books and e-books.

If you have internet access, then your main source should be http://www.google.com (or...

I'm assuming that the right-click trick is 2005 only cause it didn't work on my 2000 server.

I know everyone will put their 2 cents in on this topic, so here's mine. I don't really consider the index or speed considerations, here's my reasoning.

I use SELECT...

In my opinion, I wouldn't want a developer writing code that can reference mytable and MyTable as the same table. To me that just seems like sloppy coding, just...

The deciding factor for me is that you can make a query on a case-sensitive database act like a case-insensitive database by adding an UPPER clause.

I may be wrong, but...

I don't know if it will work in 2005, but to script everything in all of your databases the following command works great for me:

execmaster..sp_MSforeachdb "exec master..sp_ScriptDatabase ?"

Source code for...

Backup to the boot drive? Isn't that just a little dangerous? I try not to even have my output files on my C: drive for fear that something...

That's a pretty straight forward link that he gave you. Those documents get easier to read once you've read through about a dozen of them.

Being a DBA...

You don't have to register to view the article. I searched for the title on Google and the first hit was the article at the NY times. No...

Just a note, your first two links in the article are dead links.

It's about this time of year I start thinking about SUPPORTING global warming. It makes me want to go outside and just let my car idle though a tank...

In rereading my post I guess I wasn't too clear on my practices. I don't put a contraint on most of my data because I can't guarantee uniqueness when...

My sentiments exactly Steve. Thanks for the summary.

I don't mean to vent, but I'm just sick and tired of those that have found religion pushing it on others and...