Reputation
4,577
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 17 40
Newest
 Yearling
Impact
~391k people reached

Apr
5
comment SQL Server 2008 R2 - Set tempDB size on full disk
Hey, you learn something new everyday here. Please add this as an answer, Robert. I have to wonder though why anyone needs 100GB in a temp file. In all my years as a DBA I have found that in those cases there were some horribly bad queries being executed. Fixed those, no need to waste all that disk space.
Apr
5
answered SQL Server 2008 R2 - Set tempDB size on full disk
Apr
4
comment How to scale my SQL Server 2008?
Before undertaking the upgrade process, have tackled performance tuning the most expensive queries?
Apr
4
comment Using SSIS to get record counts for tables that may not exist
Cool. Learn something new every day.
Apr
4
accepted Using SSIS to get record counts for tables that may not exist
Apr
4
comment Using SSIS to get record counts for tables that may not exist
I thought of that, but then the problem of how to pass the value of the count back to a variable, which in turn is being passed back into SSIS so I can further manipulate it.
Apr
3
asked Using SSIS to get record counts for tables that may not exist
Mar
31
revised Upper or Lower Case Optimisation on MS SQL Server
fixed a typo
Mar
30
answered Upper or Lower Case Optimisation on MS SQL Server
Mar
29
awarded  Popular Question
Mar
22
awarded  Self-Learner
Mar
21
comment Are Views optimized when I add a WHERE clause to them?
Be warned: views that make your life simpler, will make somebody else's life simpler. Somebody is eventually going to discover your view and say "Wow, this is great! I can't wait to join this view to 5 other views". Pretty soon you a very slow processes, and you won't be able to change your view because so many other queries out there rely on it.
Mar
21
answered What is an appropriate datatype for an RFID, and is there a standard definition for the format?
Mar
21
comment What is an appropriate datatype for an RFID, and is there a standard definition for the format?
After posing this question, I found my answer on Stackoverflow: stackoverflow.com/questions/925002/…
Mar
21
asked What is an appropriate datatype for an RFID, and is there a standard definition for the format?
Mar
20
comment Can you recover to a point in time using the LDF?
Step 0: put the database into administrative use only. You don't want other updates to be happening while you research the issue.
Mar
16
answered Why does my SQL Server database triple in size after deleting millions of records?
Mar
16
comment Can I be automatically notified of prolonged blocking in SQL server?
I was just trying to show how start investigating...it is an old proc though...likely won't work on 2012
Mar
15
answered Can I be automatically notified of prolonged blocking in SQL server?
Mar
14
comment Microsoft SQL server 2008 and linked servers
Linked servers are fine for simple queries, but dont' expect great performance when dealing with cross server joins and whatnot. I recommend using linked servers mainly for administrative tasks / batch imports, etc.