To restore the database, you'll have to move everything. No options there. You can shrink it after the restore is complete. Or, you can modify the structure prior to the...

Lynn Pettis (5/17/2013)

---

I have had to turn of SQL Prompt here at work as it sometimes fails due...

I've seen issues with filtering on database name in Trace. My suggestion, switch to database id if you can. If not, the better solution, switch to extended events. They are...

Or just turn off intelisense and get a tool that works.

You could simply do the BETWEEN operation in your JOIN criteria within T-SQL, but you're going to have to be careful about your indexing. And, it's not an enforceable join...

And look to the Cost Threshold for Parallelism. Compare that with the costs of the plans themselves. It could be that with different parameters compiled a different times, you're getting...

The one difference there that's pretty likely to be the culprit are the Compute Scalar operators in that last query. That's going to have an effect. It seems a little...

And we have a really good reason to not run backups, to have the database in simple...

Lynn Pettis (5/16/2013)

---

The Dixie Flatline (5/16/2013)

---

Brandie Tarvin (5/16/2013)

---

The Dixie Flatline (5/16/2013)

---

But I only...

I'm wearing a Friday shirt.

dbursey (5/16/2013)

---

Hello, all - thank you for your replies! What a lot of great information and resources! Just to get my feet wet, I tried to copy the database backup...

There are a lot of different metrics that will tell you about memory. Many of them are available in Performance Monitor. Just go to the memory section, both on the...

The statement completed events, sp_statement_completed or sql_statement_completed. You'll just need to ensure you put a filter in place to ensure you're looking at the right data. Otherwise you'll collect way...

PearlJammer1 (5/14/2013)

---

Grant,

The query with the largest numbers against it is the second one in the list:

INSERT INTO @MemStat

EXEC ('DBCC memorystatus() WITH tableresults');

From query plan: 0x06000100e090292b40e18282000000000000000000000000

*****************************************************************

Thje metrics are:

execution...

PearlJammer1 (5/14/2013)

---

Hello again Grant

Heres what i am finding.

The alert for hash warnings is showing up against server 15 and in the Master database.

I click on 'overview', then my server (server15),...