The query might be experiencing the bad type of parameter sniffing. Not sure if the table has a Clustered Index on it or not, but you are likely experiencing...

In SSRS, you can pass the parameter value to an expression in your tablix (table / matrix) to sort the data. If you pass it to an expression, you...

That is an eerily similar thread

MonkeyPaw2u (5/22/2014)

---

I have an issue with the logging. The output is trying to write to K:\\Backup_ProdI1\\Result_Files\\MaintenancePlan.txt, even though I have selected K:\Backup_ProdI1\Result_Files\MaintenancePlan.txt as the output path through the Reporting and...

Not really a huge surprise in that they are moving nor that companies such as this exist. There are exam guide companies that pay people to take the exam...

How about an article that shows a recursive CTE in use. It should help you understand it better than just getting a query to do the task.

http://jasonbrimhall.info/2010/02/13/payperiod-ii/

Docile

Pain, agony

I have voted as well and I agree that a final SP should be released.

Audit

You're welcome.

It's really up to you guys. I'd recommend enabling compression on the backups due to the space savings. But in 2012 if you have a TDE enabled database, then...

I agree with Jeff and Gail. You either need to have a chat with your prof or you need to request to audit this course or drop it and...

Igor Micev (5/21/2014)

---

Sean Pearce (5/21/2014)

---

Igor Micev (5/21/2014)

---

Sean Pearce (5/21/2014)

---

Igor Micev (5/21/2014)

---

Sean Pearce (5/21/2014)

---

The question is not quite right. Fragmentation can be removed by running this because the table is rebuilt.

Your...

Interesting, the definition in BOL...