Reputation
Next tag badge:
364/400 score
84/80 answers
Badges
5 48 91
Newest
 Nice Answer
Impact
~1.2m people reached

Mar
19
answered Update strings for all cmdexec Jobs
Mar
19
comment In what data type should I store an email address in database?
Agreed, if it could be that then size it accordingly. That was the point I was trying to make in my answer.
Mar
19
revised In what data type should I store an email address in database?
edited tags
Mar
19
answered In what data type should I store an email address in database?
Mar
19
revised What are the differences between leaf and non-leaf pages?
added 7 characters in body
Mar
16
revised What are the differences between leaf and non-leaf pages?
edited tags
Mar
16
comment What are the differences between leaf and non-leaf pages?
@MarkStoreySmith Thanks!!!!
Mar
16
comment What are the differences between leaf and non-leaf pages?
@MitchWheat Thank you! I love PowerShell :-)
Mar
16
answered What are the differences between leaf and non-leaf pages?
Mar
15
comment PRIMARY KEY CONSTRAINT fundamentals
Which RDBMS are you using?
Mar
14
revised View Disc Usage
edited title
Mar
14
reviewed Reject Dutch characters in DB2 problem
Mar
14
revised View Disc Usage
added 6 characters in body; edited title
Mar
14
answered View Disc Usage
Mar
14
awarded  Notable Question
Mar
13
reviewed Reject SQL Server cluster questions please
Mar
13
comment SQL Server cluster questions please
Also check to see if the passive nodes are possible owners of the instance. What it boils down to is that there are a lot of things that could be causing this and either 1) you need to dig deeper into the problem and/or 2) provide us with more information and details.
Mar
13
comment SQL Server cluster questions please
Can you connect to the instance after failover? If so, look in the SQL Server error log and see what is happening. Could be a few things taking a long time (i.e. database recovery). If you can't connect to the instance, take a look at the cluster log and look for errors/issues.
Mar
13
revised SQL Server cluster questions please
edited tags
Mar
13
comment What is a good, repeatable way to calculate MAXDOP on SQL Server?
I believe the hyperthread_ratio is the amount of logical cores per processor. I ran into that a little while back and if I'm remember correctly that is the conclusion I came to. Maybe @AaronBertrand has more info on that. Don't take that as a hard and fast fact yet before verification.