So you're assuming that everything will go right, there will be no delays, no missing passwords, non-working connections,...

Replace the EXEC with PRINT, to print the query to the messages tab and post the resulting dynamic SQL output?

jasona.work (9/22/2016)

---

BrainDonor (9/22/2016)

---

jasona.work (9/21/2016)

---

So a book I'm currently reading (highly recommend, I've actually laughed out loud because of what I'm about to tell you) has possibly the BEST explanation for...

Mike Scalise (9/22/2016)

---

Is it true that indexes are always stored in the ndf, or could they be stored in the mdf too, and both the mdf and ndf are equivalent...

sys.master_files is, iirc, as-of the time that SQL last started, so if the DB's grown since then it'll be out of date.

2) Is it surprising that the ndf file is...

The configuration time, for any of those, is small. It's the design and planning that takes time, and that time is going to be completely dependant on what they want,...

There are a small number of DDL-related errors (data definition) that abort transactions, a very small number. They're not documented, it's a trial and error to find them, they're exceptions...

SSMS will not automatically roll back transactions.

If you're explicitly turned the XACT_ABORT session setting on, SQL Server (the DB engine, not the client tool) automatically rolls your transaction back on...

The stuff you posted in the #tamp table, do you have that data at the start, or is it part of what you want to generate?

No. SSMS will not automatically roll back transactions.

If the update had an error, the update as a whole would have failed, but your transaction is still open and still needs...

Recursive CTE can work, but it'll be slow and it's not a good solution.

Better is to use a calendar table/numbers table. If you don't have one in the DB, create...

BrainDonor (9/22/2016)

---

jasona.work (9/21/2016)

---

So a book I'm currently reading (highly recommend, I've actually laughed out loud because of what I'm about to tell you) has possibly the BEST explanation for why...

You need to check the blocked resource, there's no way to tell from what's posted what happened. There could be an explicit transaction and locks taken by earlier statements, it...

When it's run and there is no plan in cache (assuming no recompile hints or options)

That's much...

Yes, it'll also run with that isolation level.

I'll give you the same warning as last time. Be very, very careful about read uncommitted. While it makes the symptoms of poorly...