Reputation
1,307
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
7 17
Newest
 Caucus
Impact
~35k people reached

15h
awarded  Caucus
Jul
20
comment Most efficient way to insert rows into a temp table in a stored procedure
The right indexes will make all the difference. You can index trashy data--you don't have to have keys & constraints. If you really need the indexes to not stay there, it's possible that creating an index, running your 5 queries, and deleting the index will still be faster than your current process.
Jun
2
awarded  Enlightened
Jun
2
awarded  Nice Answer
May
17
awarded  Yearling
May
6
comment Issuing Inserts/Updates to Progress OpenEdge via ODBC
I've been trying in both SSMS and SSIS. Edited to include full set of errors from SSIS (I'm not using the catalog yet--we skipped 2012, and not yet up to speed on 2014).
May
6
revised Issuing Inserts/Updates to Progress OpenEdge via ODBC
added 472 characters in body
May
6
asked Issuing Inserts/Updates to Progress OpenEdge via ODBC
Nov
15
awarded  Enlightened
Nov
15
awarded  Nice Answer
May
23
comment QUERY - pivot multiple columns, variable number of rows
If your version IDs are different for every recipe, then you're either going to end up with two columns for every row in your table, or your version in the column name would not match the version ID.
May
19
revised How to SELECT multiple COUNT(*) columns with each GROUP BY having a different WHERE clause?
added 288 characters in body
May
19
answered How to SELECT multiple COUNT(*) columns with each GROUP BY having a different WHERE clause?
May
17
comment Performance hit of CONVERT from nvarchar to money (SQL Server)
Mostly I was thinking of Aaron's arguments against it, but sqlblog.com/blogs/aaron_bertrand/archive/2009/10/12/… doesn't have a lot of detail, and the SO question he links to suffers the same problem of the accepted answer not having the interesting info
May
17
awarded  Yearling
May
16
comment List of fallback values in SQL
Something like SELECT TOP (1) FolderName FROM dbo.FallbackFolders WHERE FolderExists = 1 ORDER BY Precedence?
May
16
comment Performance hit of CONVERT from nvarchar to money (SQL Server)
You probably don't want to use MONEY--go DECIMAL. See stackoverflow.com/questions/582797/…
May
16
answered Query plan cache bloated by ad-hoc queries, even with “Optimize for Ad-hoc Workloads”
May
16
awarded  Enlightened
May
16
awarded  Nice Answer