Duran (5/14/2012)

---

Hello Howard,

The session table has no indexes. Its always functioned ok in the past, this problem appears to have come out of nowhere. I'm not sure how to find...

Duran (5/14/2012)

---

Ah, I was just reading about that in the link that Howard sent through, my server is indeed set to 5, so I shall change it, before I do...

You've got multiple full scans running on millions of rows. Until you make the query filter that data, performance is going to stink and there's almost nothing you can do...

Ah, I didn't spot the Exchange Event the first time through. This is a parallelism deadlock. Best solution in this case is to eliminate the parallelism. As a starting point,...

Dynamic Management Function? Part of the Dynamic Management Objects (DMOs) which include DMFs and DMVs (Dynamic Management Views).

Spend lots of money and buy a 64-bit Enterprise version of SQL Server then you can spend lots more money on tons of CPUs and Memory. Then buy lots of...

To create this through maintenance plans, just follow the wizard. It'll walk you through it. It's easy. Try it out first on your QA system so you feel confident, but...

The easiest way to get rid of the table is to use the command, DROP myschema.mytable. That will immediately remove it, assuming you haven't created foreign key constraints to it...

You'll need to build a query to return that data. Best thing to do is take your requirements and then start putting together the SELECT statement. Once you have the...

You need to aggregate data, and then, once aggregated filter out the results? Is that a good summary? There are two approaches to this. First, use the HAVING clause as...

I'd start with Itzik Ben-Gan's execllent book, Inside SQL Server 2008 T-SQL Querying. It's the best resource. Once you're going through that, you might take a look at my book...

You've got this query:

UPDATE [Session] set [Status] = 2 WHERE [SessionID]=2513479

That seems to be going into a deadlock with a very similar query:

UPDATE [Session] set [Status] = 2...

annastassia1935 (5/11/2012)

---

Thank you Sean. It is a nightmare. I posted to get a replies from reputable professionals to show my client. The client has data modeling training...

I agree, you should bring in an expert.

If you want to try to continue to poke at it though, take that server name in the final picture and apply it...

Is that database in Full Recovery mode? If so, do you have regularly scheduled log backups (regular = at least one per hour, but more is better)? If not, that...