T.Ashish (6/17/2013)

---

Provided test data is from my local, so it will not give any issue. Getting data from prod server is not possible for me.

I...

Glad I could help. Sometimes (often actually) it is the simplest of things that trip us up! 😎

bslchennai (6/16/2013)

---

Hi,

I am facing few problems with deadlocks. we have few tables and each table is having more than 6 million rows and we have done proper indexing on those...

1) do the schedules actually exist?

2) are the schedules enabled/associated with each job?

3) do you get any errors in the sql agent error log?

4) have you tried creating your own...

We need more info like Gail said to be able to help with performance.

But I would like to point out a common TSQL programming flaw I see:

IF ISNULL(@AFonly, 0) =...

pjbaratelli (6/12/2013)

---

Starting doing tuning today. Got a good chunk of data during heavy load.

How would I go about tracking the metrics for File IO? My idea...

Wasn't SQL 2012 SP1 CU4 supposed to be the build that had the fix?

In my experience you usually have to be able to tell Microsoft that all BIOS/FIRMWARE/DRIVER/VMWARE/WIN/SQL/ETC patches have...

1) virtual environment could be misconfigured. I have NEVER been to a client that already had such an environment set up with SQL Server running on it where they...

vishalsurya50 (6/11/2013)

---

Hi ,

Last week we increased RAM and processors. now ,In our environment we have 2 processors,6 cores and hyper threading present ,so a total of 24 processors (6*2*2) available...

I had one client that actually had to ROLL BACK to the old, slow hardware because their system was essentially unusable!! No one ever thinks you need to test...

Tim Walker. (6/10/2013)

---

Can anyone share their experiences with accelerator products such as Fusion IO?

I'm interested to know how easy they are to implement and what benefits / issues people have...

chuck.hamilton (6/7/2013)

---

Thats one of the things I always liked about MySQL. The logs contained essentially just plain old SQL. If you needed to undo something that someone did you...

Nice article Wayne. But more importantly, CONGRATS ON THE MCM CERTIFICATION!! :w00t:

The dreaded IS NULL OR construct is the root issue here. Fix it per Sean's link. Those simply MUST NOT BE ALLOWED ON YOUR SYSTEM - EVER! 🙂

I didn't even reads your post honestly. All I saw was the title. Never, EVER use maintenance plans in SQL Server for ANYTHING that is covered by the...