Viewing 15 posts - 1 through 15 (of 106 total)
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...
September 24, 2011 at 7:33 am
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...
May 4, 2009 at 9:32 pm
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,...
April 27, 2009 at 9:35 pm
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...
January 9, 2009 at 10:34 am
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...
January 8, 2009 at 10:18 pm
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...
December 15, 2008 at 10:32 pm
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...
August 29, 2008 at 12:47 pm
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. ...
March 12, 2008 at 8:31 pm
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...
March 12, 2008 at 8:53 am
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...
November 26, 2007 at 9:22 pm
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...
November 8, 2007 at 10:34 pm
Also what about security implications...since this invokes most of the .Net framework, are those bugs and security holes also introduced to SQL?
August 27, 2007 at 10:24 pm
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...
August 19, 2007 at 11:49 pm
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...
August 19, 2007 at 11:24 pm
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...
August 16, 2007 at 8:08 am