Steve Jones - SSC Editor (2/9/2011)

---

Grant is correct, but a clarification. The backup runs from the server, so

BACKUP DATABASE MYDatabase to disk = 'c:\mybackup.bak'

runs to the C: drive on...

Brandie Tarvin (2/9/2011)

---

Ninja's_RGR'us (2/9/2011)

---

One more option maybe the op didn't consider.

Do you have by any chance a copy of the script you use the create or load the table? ...

You can't. Not really. There's just so much that can be done with UDF's, like I said.

I agree with you. I don't think it's a good way to...

It has to do with how the GUI collects data. Here's a good article on it.

Excellent. I'm glad you were able to recover it.

If this is a...

SKYBVI (2/9/2011)

---

profiler trace will trace from now, i mean i can start it wen i come to work,

but wat about the backups being done in night...

how to know who,when and...

Gianluca Sartori (2/9/2011)

---

Grant Fritchey (2/9/2011)

---

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

I suppose on pretty slow systems or off hours that makes sense to try. But on a reasonably heavily used system... you better be very quick with the keyboard.

Thank you! It's good to know it's been helpful.

It really depends on the business. There are places where nosql is going to, rightly, kick out OLTP systems. There are places where nosql does not belong. Just as an...

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