Sorry, my email was offline so I wasn't getting messages. Sounds like Chris largely has it in hand.

Since you're on SQL Server 2012, I would advise avoiding trace events. Instead focus on extended events. They're more light weight and much more programmable. There's no book available on...

anthony.green (1/25/2013)

---

Only upon restart of the service as TempDB is created from model so the objects inside it will also be created in TempDB

Hence why you should use a script...

Table partitioning is primarily a mechanism of data management, not of performance tuning. Partitions allow you to add or remove data by working with large chunks, the partition, rather than...

SQL Server doesn't store the previous executions of queries. You can look at the aggregation of queries currently in cache using sys.dm_exec_query_stats, but it doesn't have execution context (who ran...

I agree. It sounds like parameter sniffing is leading to issues. I would suggest updating the statistics on the tables being referenced. In addition to the solutions for parameter sniffing,...

There are probably lots of other issues in and around this, but the repeated pattern that looks like this:

where coalesce(p.ImageSequenceId,0)

is absolutely killing performance. Every single one of those is...

padhu.mukku (1/24/2013)

---

There will be no diff instead when ever u want to use this CTE to read data from it, u have to define its sturcture again and again....

Try to...

Oh, that's right Kevin. I completely forget that you get four mirrors of the active server. That one is big too. Nice catch.

I'm just a little surprised that this information...

There are several reasons why Availability Groups might be preferred to a Cluster. First, and most importantly, you're not sharing any resources at all. In a cluster if the disk...

Nah, I'd say you're digging a bit of a hole. Instead how about something like

Recurrence ... whatever columns are unique to the recurrence

RecurrenceSchedule ... just a listing of each of...

MasterDB (1/24/2013)

---

Check the fragmentation of all indexes by using sys.dm_index_usage_physical_stats.

If the fragmentation is more than 35% --Rebuild all the indices.

Ask the users about any change of code..? If so, Check...

runal_jagtap (1/24/2013)

---

Update statistics?

Hmm i have never done Update statistics on Database yet..

Please correct my belwo plan..

Sunday no one wotks on the Database

will perfom the below activity..

1) Full Backup - Using...

You're really going to need to evaluate each of the tools to see which will do what you need for the money you're willing to pay. 10 instances is a...

Not a detail I had noticed before. But yes, the shells are there. I recreated Gail's tests.