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...

Wonderful news. Best of luck to her and the...

The problem isn't the wild card at the end of the criteria. It's the wild card at the start. That requires a scan of the column, which can lead to...

If you're interested in knowing when the plan was placed into cache, which would be the compile point of the procedure, you can get that from Dynamic Management Objects (DMO)...

ashkan siroos (5/8/2012)

---

Well, I know it is better in general, but what I want to say is that I cant find any major difference between them when the maximum rows...

capn.hector (5/8/2012)

---

thanks to the suggestion of Grant it got me thinking about the where clause. i was helping out the operator about an hour after the "Error" occured...