Tony,

It is definitely a community effort. I have been through most of those in the past 7 years as a DBA and it was a community effort just within...

Nope, just some curiosity, perfectionist tendencies and persistence are required in my mind to be a good dba. I have a BA in Econ and Finance and a...

In this case, it is survey statistical data and the minimum response size is there to protect anonymity/confidentiality of respondents. Once you fall below a certain number of responses,...

Interesting discussion. I liked the comment about the expectations of different cultures. My wife is Russian and I am American. They way she dressed or was...

I have worked in both environments where we were required to wear a suit and a tie. So, I had fun with it and always wore bow-ties. In...

Another thing to check is the size of the TempDB. If SQL 2005, then you can connect to the server with the DAC and all you need to...

As for me, I pack up the wife and kid and we go and visit her family in Russia. One the way there we pick up her brother in...

DBCC OPENTRAN shows no open transactions. This database is not part of replication.

I'm thinking this may go to MS PSS team and see what they think. ...

Thanks!

That doesn't work either. As I understand DBCC ShrinkDatabase ('mydb') cannot shrink past the size of the VLF's.

From BOL "Because a log file can only be shrunk...

I have a hard time believing that scope_identity() could have problems. It could be deadlocks but you should get an error and the variable would be null and the...

Well welcome to the crazy world of the DBA or as we say at my place Welcome to 7734.

Anyhow, I like Rudy's rule do no harm and make...

Also what about security implications...since this invokes most of the .Net framework, are those bugs and security holes also introduced to SQL?

SJ

This is for 32bit SQL 2005 (as 64 bit SQL 2005 is a bit different):

If you enable the /PAE switch and the AWE option, you will want to set the...

My favorite answer....it depends on your environment and business requirements!

Have you ran the upgrade advisor yet?  This is helpful and does a decent job of letting you know if you...

I agree with Steve.  Most of your current high-end servers are already 64bit but most often get installed with a 32bit OS and subsequent software. 

When we upgraded we looked...