Reputation
27,759
Next tag badge:
367/400 score
84/80 answers
Badges
5 49 92
Newest
 Nice Answer
Impact
~1.3m people reached

Feb
12
comment Full to Simple recovery mode during massive data update?
The only thing you're gaining out of putting the database in simple recovery mode is minimal logging. You can gain this by switching the database to bulk logged, and therefore not break your log chain.
Feb
11
reviewed Approve Sql Powershell Script not working
Feb
5
comment Indexing nvarchar(128) in SQL Server
Can you show us the CREATE TABLE DDL for the table in question?
Feb
4
awarded  Nice Answer
Feb
4
answered Are deadlocks a serious problem?
Feb
2
revised Index file growing endlessly - how to fix it?
added 542 characters in body
Feb
2
revised Is there an easy way to update connection strings to a database moved to a different instance
added 2 characters in body
Feb
2
revised Job to check the status of another job
edited title
Feb
2
revised Index file growing endlessly - how to fix it?
edited tags
Feb
2
answered Index file growing endlessly - how to fix it?
Feb
2
answered Is there an easy way to update connection strings to a database moved to a different instance
Jan
31
comment Return List of Database Users and Server Logins
This sounds like a job for PowerShell and SMO.
Jan
30
revised Had to force loop join and don't understand why
edited title
Jan
27
revised This Extended Events session works on Dev but not on Pro. Why?
edited tags
Jan
27
revised SQL Server 2012 stored procedure runs very slow sometimes
edited tags
Jan
27
revised Syncing Uncontained Objects with AlwaysOn Availability Groups
edited tags
Jan
27
answered Syncing Uncontained Objects with AlwaysOn Availability Groups
Jan
21
revised When was a Database taken Offline
edited title
Jan
21
answered When was a Database taken Offline
Jan
15
revised Disk Space usage
edited title