I generally don't worry about how much I'm reading or writing on a database, but whether or not the reads or writes are slowing down. Instead of focusing on the...

If you don't get everything you need from Gail's excellent articles, you might want to pick up a copy of my book on query tuning. It might help.

No difference at all. You run a server side trace output to a file, then you open the output file using Profiler. That's it. You can then open the perfmon...

You should check for open transactions. You might have a process that isn't committing properly. I ran into some rogue code that did that & it filled the drive before...

My first choice in this situation would be SSIS as well.

But, you could look at third party tools. For example, Red Gate Data Compare[/url] could be scheduled to move data...

Connections come from the application, so that's where the code for reconnecting would have to reside.

If you're programmatically determining the key value(s), then no, having identity values isn't going to help that I can see.

Now, how you're determining that value could lead to issues. Are...

I published a series of tests on this subject for retrieving versioned data over here at Simple-Talk[/url]. It might prove useful. The answer, in a nutshell, it depends.

And you would only set it ON for the table you are inserting into, not the one you're reading from. And remember to set it to OFF when you're done.

Never heard of that. It's SQL Server Management Studio and has been for quite some time. That's where you administer your server, including security. Although, you can do most of...

Saga... (8/4/2011)

---

Grant Fritchey (2/22/2011)

---

Fox87 (2/22/2011)

---

Hi There,

The SQL Upgrade Advisor doesn't work if I run it on my SQL 2008 instance.

It give the following error:

SQL Server version: 10.00.4000 is not...

I see someone else mentioned it, Red Gate's SQL Virtual Restore allows you to "restore" a database backup. You can even restore log files to a point in time, but...

If by American beer, you're referring to Miller & Budweiser & Coors, you're right. It's awful. But there's a whole category of American beer that's so good, when I was...

jcrawf02 (7/29/2011)

---

I do wonder though when we'll be able to view a HUD of some sort, whether built into contact lenses or projected via an attachment to my glasses, so...

Not really. Problem is screen size...