fi you did something like this

select * from mytable with (tablockx)

then you have granted an exclusive lock against the entire table and no writer should get access

you can also test...

Great article, and i'm glad you enjoy contributing to the site, it has certainly helped myself as well

one of my previous employers put every new employee through a "consultancy and...

I know this sounds obvious, but have you tried putting it into an SSIS package? (for the love of god please bring back DTS)

you schedule that in SQL agent and...

back in the day of mirroring, if a transaction couldn't be committed to the standby then it would lock the primary (unless you had enterprise edition and hi performance mode)

this...

depends on who you are sharing it with but I use showplan_XML

https://docs.microsoft.com/en-us/sql/t-sql/statements/set-showplan-xml-transact-sql?view=sql-server-2017

you can then copy and paste the XML

I recently posted an article on here about this

we used Redgate sql backup and there are a few controls that let you schedule a restore to a remote server

it generates...

I think what you are describing is done by using "WITH ROLLUP"  in the group by or perhaps a grouping set

have a look at this article

https://www.databasejournal.com/features/mssql/using-the-rollup-cube-and-grouping-sets-operators.html

for each of your dates...

We do a lot of work in marketing for other companies, most have different seasonal requirements.

I'm told that we make every "poppy" for rememberance day in the UK, so october...

Hehe - until you...

ok - the issue is why is ((0)) matching %PGDb007%

have you checked both the file security  for the shared folder AND the share permissions.

i'm not saying this is best practice, but what I tend to do is set "everyone"...

you will get this forever - especially if you use temp tables.

my advice - scrap it and rebuild, you will spend less time doing that than the hours of bug...

you might find that after adding the index that you will get a new index suggestion afterwards

I often have to go through 3 rounds of execution plans to get all...

depending on what mean by "job log" you're going to have to get this from msdb database

dbo.sysjobhistory , maybe a few more tables, but I can't see a way to...

I'd be tempted to say the measurement includes spooling to tempdb and either sorting or joining

if you have to sort/join without decent indexes then that would cause a lot of...