It's going to be nearly impossible to diagnose without the query, as it's probably something related to the query and/or table structure.

You can obfuscate the table and column names,...

Can you post the query? Execution plan might also be helpful.

Good, then it's decided. Thank you

Got my blog working again, finally. Hosting provider can't figure out how the files got wiped, restored a 3 month old backup, got my name incorrect in their last reply...

szejiekoh (11/7/2016)

---

q2) As part of the release process, Do we also have to add the following line in the script ->

"EXEC msdb.dbo.sp_update_job @job_name='Your job name',@enabled = 0 " ...

It is indeed the quotes causing the problem. As written, the query is looking for an ID equal to the string literal '@COLLEAGUE_ID' because it's in quotes.

exec sp_executesql N'SELECT COUNT...

Brandie Tarvin (11/7/2016)

---

GilaMonster (11/7/2016)

---

No, a compressed backup is compressed from the start.

If it worked according to your theory, then a compressed backup would take longer than a normal backup...

By 'data warehouse', do you mean Azure SQL Data Warehouse, or just a generic, on-my-own-servers 'data warehouse'

No, a compressed backup is compressed from the start.

If it worked according to your theory, then a compressed backup would take longer than a normal backup (write out the...

The fact that it has...

Please don't post multiple threads for the same question.

No replies here. Direct replies to http://www.sqlservercentral.com/Forums/Topic1832272-2893-1.aspx

Please don't post multiple threads for the same question.

No replies here. Direct replies to http://www.sqlservercentral.com/Forums/Topic1832272-2893-1.aspx

What's the full and complete output of

DBCC CheckDB('<database name>') WITH NO_INFOMSGS, ALL_ERRORMSGS

?

Often in SQL, 'reusable code' = 'slow code'

Have you considered...

Jeff Moden (11/4/2016)

---

With the understanding that it clears out on a restart of the SQL Service, you could also look at sys.dm_db_index_usage_stats. It won't differentiate between INSERTs and UPDATEs...