BLOB_EATER (9/16/2016)

---

Grant Fritchey (9/16/2016)

---

I'd shy away...

MiguelSQL (9/16/2016)

---

Thank you for all your help.

I said it was a bad idea because developers should generate their own test data, rater than use a copy of Prod that needs...

I'd shy away from PLE. By...

SQL Clone will certainly help, but you'd still want to get the allocated space of the database down prior to using SQL Clone.

If shrink isn't going to work, and...

If you don't have monitoring in place, then I would start with capturing the wait statistics over time. You need to be able to compare them, today to yesterday, this...

Are you experiencing any other issues related to memory or disk? What are your top wait statistics? Are you experiencing performance issues. PLE, all by itself, doesn't really indicate much...

Nope.

A temporary table is isolated by the connection that created it.

Bharat21 (9/14/2016)

---

Kindly give the queries for below,

1.Query for List of tables of top and bottom accessed in last 30 days

2. Query for List of stored procedures 10% of top...

If you are going to do dynamic SQL, then please, use sp_executesql and use parameter values. Don't let unchecked string parameters determine behaviors. That leads to SQL Injection. When you...

Jacob Wilkins (9/13/2016)

---

Just another quick note to make sure we don't spend a lot of time barking up the wrong tree: Unless I've gone completely crazy (always a possibility), the...

That's only one query plan. You'd need to post the plan from the application and the plan from the code that you're running both in order to see if there...

BLOB_EATER (9/13/2016)

---

Grant Fritchey (9/13/2016)

---

I'm around 10,000 a month, give or take. I think that's about 300+ a day on week days. I know the big SQL Server bloggers like Brent...

I'm around 10,000 a month, give or take. I think that's about 300+ a day on week days. I know the big SQL Server bloggers like Brent or Paul &...

Another approach to get as near to simultaneous as possible would be to use Powershell where you can spawn multiple threads on the machine. The degree to which these things...

I'd test it using a parameter, not a local variable. Most of the time, but clearly not always, parameter sniffing is a good thing and helps performance. It really depends...