If you're not sure what to look for, then consider using the DTA (Database Engine Tuning Advisor) tool to analyze your query.

asterman_3 (4/4/2011)

---

Actually, I want to know whether it is possible to create a procedure from T-SQL on remote server, and than execute. Or, to create a SQL Job remotely (on...

You should create a procedure on the remote database...

One method is to create...

Steve Jones - SSC Editor (4/1/2011)

---

H-122523 (4/1/2011)

---

Hi Steve,

Interesting editorial, this, as it connects failure to probability.

In the end, we all make up the statistics; I just finished 'The Black...

If Joe's Bike Shop looses all their data without a backup, then that's a personal tragedy for their business, but it's not really a community or regional wide disaster. The...

Disaster recovery is actually easier in the modern IT world than it was in times past. One hundred years ago, if the county courthouse burnt to the ground, much of...

CirquedeSQLeil (3/24/2011)

---

I find this editorial interesting in that I had a recent discussion concerning new car models that have wifi enabled in the car. The wifi in these cars...

In most large corporations, everyone has an employee number which they know from memory becuase it's on their payroll stub or they enter it when dialing into a tele-conference call....

GSquared (3/24/2011)

---

Does the MP3 player double as a control for your...

hnhaney2 (3/24/2011)

---

Once you understand that the car run a CAN network system between all major system, it's no different than network hack in the internet, Other than it CAN network,...

An MP3 player and an automobile engine are two unrelated systems that should not be tightly coupled.

Ian Scarlett (3/23/2011)

---

It isn't just the hackers you have to worry about... the car manufacturers are up to no good with their own car software.

Peugeot in Europe were found to...

nelsonj-902869 (3/23/2011)

---

I suggest we all go back to listening to AM radio. No more tapes or CDs or XMSirius radio that no one knows anything about or that requires you...

It's crazy to think that the audio system in some cars can be wired to the ignition system in such a way that that a hacked MP3 file could kill...