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

Aug
18
comment How does SQL Server Import and Export Wizard fetch metadata?
Oh, what I wouldn't give for a profiler... Unfortunately, the offending system is a remotely hosted vendor app, and I only have ODBC access. There is a system view analogous to sys.columns, but it shows what should be the limit, not what's actually stored in the column.
Aug
18
comment How does SQL Server Import and Export Wizard fetch metadata?
It has a LENGTH(), but it's only valid for char and varchar. I can probably cobble together what I need from that, but it seems like the wizard is doing something quicker and more sophisticated that I was hoping to emulate. I'm trying to make my homemade replication more robust, but Progress doesn't make that easy.
Aug
18
asked How does SQL Server Import and Export Wizard fetch metadata?
Aug
3
awarded  Constituent
Jul
28
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?