Yes, nesting does make things a bit more complicated, as you have to be sure to use that logging technique at each level if each level has something you need...

You could write whatever you want to write to the logging table to a table variable within the transaction, and then write from the table variable to the logging table...

mpdillon (12/23/2015)

---

SS,

Thank you for your efforts. So that other who read this will have a better understanding without having to recreate the tables and queries, I have added a Identity...

You can use the backup_size column in the backupset table in msdb to look at size for backups you don't still have in the file system.

Cheers!

Some DDL for the tables and some sample data would help us more certainly answer that.

Having said that, unless something got lost in copy/paste translation, it looks like there are...

Heh, got wrapped up in trying to explain all the results and left out that fairly important part. :hehe: Yes,...

Eric M Russell (12/23/2015)

---

I actually can't reproduce this. I'm using SQL Server 2014, and Session 2 WILL wait for Session 1 to commit on the 2nd run, which is what...

If I understand the requirements correctly, something like this should work:

CREATE TABLE #test (filemonth int, startmonth int, frequency int);

INSERT INTO #test

VALUES (5,10,6),

...

You need to figure out why the log is growing first. If the log is actively growing then you likely won't be able to shrink it anyway.

Check the log_reuse_wait_desc in...

MadAdmin (12/22/2015)

---

Jacob Wilkins (12/22/2015)

CREATE TABLE #test (some_string varchar(max));

INSERT INTO #test

SELECT TOP 1000000 ac1.name

FROM ...

In addition to what Eric said, it's not altogether uncommon for some queries to exhibit decreased performance after adding processors or cores.

Sometimes SQL Server thinks a parallel plan is a...

Eirikur Eiriksson (12/22/2015)

---

ScottPletcher (12/21/2015)

---

But if you put the N' when the column is not unicode, you'll force SQL to implicitly convert the column itself and that could be a real...

Caspian Canuck (12/21/2015)

---

Curiously, when I tried to simplify the above solution using nested queries as shown below, the results were somewhere in-between in terms of speed (about 25 secs). Theoretically,...

If you literally mean just sending to multiple email addresses, those recipient parameters all accept semicolon-delimited lists, like so:

@recipients='email1@someprovider;email2@someprovider;email3@someprovider;email4@someprovider',

Cheers!

The fact that a column-level statistics object gets created for the RowNum column means nothing more nor less than that you have auto_create_statistics on for database in question.

When that is...