We use xp_cmdshell in a large number of stored procedures that we call nightly. Every time I enable this setting on a new server build, I get a bit...

As mentioned if you restart the SQL Service the tempdb is dropped and re-created so if you can restart the service this is a good option. If you need...

in SQL 2012 I am able to create a synonym and select from it with no issues.

I believe 6.0 was actually called Starfighter and 6.5 was Hydra

I'm with GilaMonster. I have a backup guy who knows a little so I have made sure that all of my processes are documented, and all the DR processes...

Pretty cool.. that did work.. now the question of the day, how did it get into a state that required reset... regardless... thanks for the head's up.

I tried this several times and even for the question the other day that referred to this, no go.. this does not work. I get the error that this...

There is also the possibility that a different user name is mapped to the login and this account is orphaned. When the script in the question is run an...

DUH forgot about the full backup... however; on another note, yes you can run CHECKDB but the DBCC CHECKALLOC and DBCC CHECKCATALOG cannot be run against the tempdb which are...

I could not agree more with Steve's post. I have been a DBA for a very long time now and the thought of eliminating service packs does not settle...

Good article. Didn't see it mentioned but Non-Clustered indexes are not created on the subscriber automatically. When you view the article properties, you would need to select this...

I would suggest you export the records that you want into another table and then drop the original table. If you need the table named back to the original,...

Interesting article. I'm questioning the comment regarding "wasting memory" when the max memory setting is split between the two instances. Technically you would NOT want to split that memory...

Good question but neither answer was correct. Granted you do NOT get an error but the truncate does not technically run either. If you go back and view...

I am using IDERA SQLSafe and have found it to be a great tool to use for compressed backups. It runs rather quickly. I have not been using...