The update statement you have is modifying the row where the ID = 9. If you want to move the value from 27 to 9, try writing an UPDATE FROM...

If you know you have a query that is causing performance problems, I'd start by looking at the code to see any of the common issues and then I'd look...

I have used, as a DBA, Idera, Spotlight, Foglight, Operations Manager and SQL Monitor. Currently, I work for Red Gate, so my view might be a little biased. All these...

Not sure without seeing what is being blocked. One recommendation, get rid of the drop table statement entirely. Let SQL Server clean it up on its own. Not saying that...

On any query while looking at the execution plan, the costs will add up to about 100% (sometimes a little less, occasionally a lot more, it's a bug). So seeing...

Thanks for all the excellent replies about the clustered index/heap thing. You've all more or less reinforced my opinions of things through some great factual discussions. That's why I love...

sqlmunkee (2/4/2014)

---

I've used LiteSpeed for several years now, but since SQL2008, I've always favoured native compression over 3rd Party tools. In some environments, LiteSpeed will slow to a crawl if...

It works fine on 2012. You might also consider other 3rd party products for compression such as Red Gate SQL Backup[/url].

By the way, there is native compression of backups on...

I'm not aware of hitting issues with ms_foreachdb skipping databases. But, you're right, it's technically unsupported by Microsoft, so could go away at any time. It's just a cursor, so...

Not that I'm aware of. Generally, for full backups, I do one of two things, run DBCC before them, or use them to run DBCC (and then run a physical...

lisa.randles (2/4/2014)

---

Hi, all. No ideas on how to view the full error? Bummer. 😉

Grant, I'll see what I could do with the brackets, although I'm pretty green...

Over my head. Could use some help here. I truly hate the hardware aspects of SQL Server, especially when combined with VMs.

Oh, we've got a VM on top of this... yikes. That does complicate things. Now I'm really unsure. Your explanation may be accurate, but... let's see if I can get...

It really depends on what you're attempting to audit. If you want to see data changes, the best bet is to implement change data capture (CDC). If you want to...

After the fact like this... You can try querying sys.dm_exec_query_stats to see if you have any queries that stand out as using a lot of CPU. Otherwise, the best bet...