1,226 reputation
414
bio website
location
age
visits member for 2 years, 2 months
seen 16 hours ago

May
19
revised How to SELECT multiple COUNT(*) columns with each GROUP BY having a different WHERE clause?
added 288 characters in body
May
14
revised How to find duration in a dataset
`WHERE Value IS NULL` in the CTE breaks the "gaps and islands" construct. Filter out the unwanted groups in the outer query.
Feb
12
revised Timeout while using table valued parameter
added 1931 characters in body
Sep
30
revised how to downgrade a statement for SSIS
deleted 1 characters in body
Jul
16
revised Will Ola's default IndexOptimizer job update my stats?
added 486 characters in body
Jun
28
revised Error using an Execute SQL script to load a date variable in SSIS
deleted 4 characters in body
Jun
27
revised Is there any way to tell the number of matches found in a database value matched with LIKE?
added 1 characters in body
Jun
24
revised How can I write windowing query which sums a column to create discrete buckets?
wasn't handling "bucket" concept
Jun
20
revised Running functions in parallel
added 225 characters in body
Jun
20
revised Error 3154 while restoring a backup using WITH REPLACE
added 2 characters in body
Jun
4
revised Create a sub query for sum data as a new column in SQL Server
deleted 2 characters in body
Jun
4
revised Create a sub query for sum data as a new column in SQL Server
added 252 characters in body
May
9
revised How can I reliably track stored procedure ( and functions ) use over time?
Primarily addition of code block; minor code formatting for readability
May
3
revised Can I use Try_Cast to give me a query result column with different datatypes?
added 170 characters in body
Oct
4
revised Can We Perform an “Up-To-The-Minute Restore” After Taking Transaction Log Backups?
added 258 characters in body
Oct
4
revised Can We Perform an “Up-To-The-Minute Restore” After Taking Transaction Log Backups?
added 228 characters in body