Skip to main content

New answers tagged

1 vote

Tsql help - doing a large update from CSV file to a table in ssms

You can use https://sqlgenerator.io to convert an excel/csv/json file into a CREATE TABLE and INSERT INTO TABLE SQL statements with the corresponding data. It's a free tool I created as I have to do ...
Ryan Waldorf's user avatar
1 vote
Accepted

.DTSX package is there a way to wrap a workflow into a transaction

You can read about SSIS transactions here. Configure a package to use a single transaction In this option, the package itself initiates a single transaction. You configure the package to initiate ...
David Browne - Microsoft's user avatar
12 votes
Accepted

Is "ROW_NUMBER() OVER(ORDER BY xml.node)" well defined?

No, it's not documented and therefore not guaranteed. In practice, it probably is guaranteed as I described in a Stack Overflow answer (reproduced below) but that doesn't meet your stated desire for ...
Paul White's user avatar
  • 86.9k
0 votes

Is it parameter sniffing?

Looking at the data you provided, including the execution plan, it is impossible to determine if the attached plan is a parameter sniffing case. I am unsure if any data from your original plan was ...
SqlWorldWide's user avatar
  • 13.5k

Top 50 recent answers are included