Reputation
Next tag badge:
367/400 score
84/80 answers
Badges
5 50 92
Newest
 Good Answer
Impact
~1.3m people reached

Mar
2
awarded  Announcer
Feb
27
comment Long running DBCC CHECKDB
Have you looked to see if the DBCC CHECKDB request is being blocked during this time?
Feb
27
awarded  Enlightened
Feb
27
awarded  Nice Answer
Feb
27
revised Why adding SQL Server user to “Perform volume maintenance tasks” improves the speed of database resizing so much?
added 4 characters in body
Feb
27
comment Why adding SQL Server user to “Perform volume maintenance tasks” improves the speed of database resizing so much?
Can the downvoters please explain why the downvotes?? This looks like a fine question to me.
Feb
27
revised Why adding SQL Server user to “Perform volume maintenance tasks” improves the speed of database resizing so much?
added 342 characters in body
Feb
27
answered Why adding SQL Server user to “Perform volume maintenance tasks” improves the speed of database resizing so much?
Feb
27
comment Return list of columns in user-provided subquery
@MisterMagoo No problem at all!
Feb
26
comment Return list of columns in user-provided subquery
@MisterMagoo There you go :-) Only the necessary code to eliminate any confusion.
Feb
26
revised Return list of columns in user-provided subquery
deleted 1102 characters in body
Feb
26
comment Return list of columns in user-provided subquery
@MisterMagoo This was just to illustrate how to do this. There are 100s of omitted things that should be in development, but to keep code brief I kept them out.
Feb
26
answered Return list of columns in user-provided subquery
Feb
26
revised Return list of columns in user-provided subquery
edited tags
Feb
26
comment Return list of columns in user-provided subquery
Are you using SQL Server? If so, what version?
Feb
25
comment SQL Cluster, AlwaysOn AG, or Something Else?
A SAN does not need to be used with a Windows Cluster and an availability group. You will need shared storage if you go with a failover cluster instance (SQL).
Feb
24
revised SQL Cluster, AlwaysOn AG, or Something Else?
edited tags
Feb
24
answered SQL Cluster, AlwaysOn AG, or Something Else?
Feb
23
revised Unable to restore (error 3456)
added 95 characters in body
Feb
23
comment Transaction log backup file larger than expected?
1 single data modification command can create way more than 3 MB of transaction log consumption :-) It all depends on how much churn there is. It's not a direct relationship between DML command count and log generation.