Glad to hear it's fixed.

Just curious though, why not use a PowerShell type of step in SQL Agent for a PowerShell script?

It does depend on how your security is set up, but you can set a database to restricted_user. This will make it so that only logins with privileges as SA...

Lynn Pettis (3/31/2013)

---

Yes, I am sure about doing this, but I am both anxious and excited about going. It may not be the safest place but having talked to...

I so wish we had voting here. i just want to vote up Gail's answer & move on. Trace flags and and the system_health Extended Event session would be my...

If you want monitoring on both SQL Server and Oracle, your choices are limited. Quest software (Dell?) has a tool that can do both. Confio has two tools that each...

Not to mention that adding all those checks into a single transaction increases the time that transaction will run which increases the likelihood of blocking and deadlocks.

Without seeing the queries or the execution plan, everything that follows is just a vague guess.

If you're seeing scans, it means either that you don't have the right indexes in...

Steve Jones - SSC Editor (3/28/2013)

---

Good answer: http://meta.stackoverflow.com/questions/167452/what-are-the-most-effective-ways-to-guide-new-users/167510#167510

I know we don't keep people away, but treating them with respect, somewhat without regards to how snippy they may appear, is something...

ScottPletcher (3/28/2013)

---

Grant Fritchey (3/28/2013)

---

ScottPletcher (3/28/2013)

---

There must be more fragmentation in a history table than a current-data-only table.

For single row lookups, this is not really a performance hit.

But for table scans,...

ScottPletcher (3/28/2013)

---

There must be more fragmentation in a history table than a current-data-only table.

For single row lookups, this is not really a performance hit.

But for table scans, even partial ones,...

Your choices are very limited at present. Until SSAS is included in the Azure stack and until they get the Azure VMs out of beta, your only choice is as...

A few other resources that might prove helpful. You can download the free e-book, Troubleshooting for the Accidental DBA[/url]. It covers a lot of what you're asking about. Also, take...

I worked with a design for several years that allowed for versioned data and queries that ran extremely fast. You just have to make sure that you index the tables...

Define help. This will remove all data from the buffer and force a recompile of all queries. If the data load was...

If restarting the server clears up what's going on, I'm not sure that you're seeing memory problems. I'd suggest hitting the sys.dm_os_ring_buffers[/url] to determine if you're getting out of memory...