You're unlikely to get someone to do your work for you for free. Instead, you shoul focus your efforts on the things that people have already suggested. Learn about entity...

I'm fairly certain this was added to the deprecation list in 2005. That means that the very next release of SQL Server will remove it (assuming 2005, 2008, 2008 R2...

Nope.

It's gone.

You really should reexamine your backup strategies. Once every four months, even in a development environment, is way too long. If it's a production environment, it means that the...

How are you monitoring the process? If you use sys.dm_exec_requests you can see what the process is waiting on (as well as if other processes are waiting on it). If...

mohammed moinudheen (2/9/2011)

---

You won't be able to take the backup directly on to your local machine.

First let the backup command run to take the backup on server location

and...

If you know which procedure is causing problems, get that query's plan handle and use DBCC FREEPROCCACHE(plan_handle). That way you're not nuking the cache, but going for surgical strikes.

There isn't a way to write a single query that will gather all the information needed. Like the link to Brent's site shows, you're going to, at a minimum, hit...

Yep. My book covers a pretty hefty chunk of what you're asking about.

Tom.Thomson (2/8/2011)

---

I've joined...

sqldba_icon (2/8/2011)

---

Grant Fritchey (2/8/2011)

---

sqldba_icon (2/8/2011)

---

Two updates on the same question,

i) In my proc i have the following options set up

Set ANSI_NULLS ON

go

SET QUOTED_IDENTIFIERS ON

go

Set Transaction isolation level read uncommitted

SET NOCOUNT...

sqldba_icon (2/8/2011)

---

Two updates on the same question,

i) In my proc i have the following options set up

Set ANSI_NULLS ON

go

SET QUOTED_IDENTIFIERS ON

go

Set Transaction isolation level read uncommitted

SET NOCOUNT ON

ii) This article...

Gianluca Sartori (2/8/2011)

---

Grant Fritchey (2/8/2011)

Hey, while I've got you guys here, when I was off the network, the Virtual Box and the laptop stopped communicating. I'm sure I've got a...

Assuming you're getting an actual execution plan from the trace or through management studio, they're the same because they're coming from identical sources. Neither does anything that the other does...

If it comes out on schedule, it will be SQL 2011, yes.

parissa_bakhshi (2/8/2011)

---

1-Sure,I've used perfmon and every things seemed ok, except context switches.

and also memory , but SQL always takes the memory till a process need it. goof buffer cache hit...