Reputation
28,415
Next tag badge:
94/100 score
25/20 answers
Badges
5 54 95
Newest
 Nice Answer
Impact
~1.5m people reached

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.
Feb
23
comment Transaction log backup file larger than expected?
What is your definition of "nominal" activity? How frequently are your transaction log backups? The size would be due to that amount of logged operations that need to be backed up.
Feb
23
revised Unable to restore (error 3456)
edited title
Feb
23
revised Unable to restore (error 3456)
added 237 characters in body
Feb
23
answered Unable to restore (error 3456)
Feb
23
revised Unable to restore (error 3456)
edited tags
Feb
23
awarded  Taxonomist
Feb
20
awarded  Enlightened
Feb
20
awarded  Nice Answer
Feb
19
revised Can SQL Server's Page Life Expectancy be too high?
added 6 characters in body
Feb
18
revised Can SQL Server's Page Life Expectancy be too high?
edited tags