In addition to what the ninja says, you need to check all the fundamentals, server settings, is the memory identically configured, are the cpu's identically configured, do you have the...

What it does is it gets down into the guts of the backup file and captures the calls between the two, for data & nothing else.The rest of the SQL...

Yeah, if it's grinding along, you should be looking as sys.dm_exec_requests for blocked & blocking processes or for processes that are using lots of resources or are waiting on resources....

It's always hard to know if the estimated values are going to be the same as the actual, but taking it as it exists, 87% of the cost of that...

Network backups are notorious for poor performance, although this precise behavior is not one I've seen. Generally, you're better off backing up to attached storage and then copying to a...

Brandie Tarvin (9/16/2011)

---

Gianluca Sartori (9/16/2011)

---

WayneS (9/16/2011)

---

Question for those that blog (preferably with WordPress) and post code on their blog - what code syntax tool do you use? I'm using WP-SynHighlight,...

Do a search on the web site here. This question comes up all the time, There are a lot of discussions about it.

I'll suggest two books. First, Itzik Ben-Gan's Introduction...

I would assume performance for querying is going to start degrading, but honestly, I've never seen a system with 150,000 tables before, so I couldn't tell you when.

I suspect, really...

Erik Hansson (9/15/2011)

---

I have a server with 4 processors. Two instanses of SQL Server 2008 R2 is installed on the server. Now I want to dedicate two processors too one...

I'm at a bit of a loss here. Common and best practices are to split up tables, apply unique constraints, primary key constraints, foreign key constraints and build clustered indexes....

That's just a set of processes. There is lots of information there, but little data.

Personally, I don't like using that because it's so messy. Instead I run queries against the...

That's one of the tougher ones to set up. You need to capture statement level events. When capturing statement level events, you're going to get lots and lots of data....

Excellent stuff everyone, thanks. I especially liked the DTA & the Profiler GUI. Excellent stuff.

mtillman-921105 (9/14/2011)

---

Grant Fritchey (9/14/2011)

---

You combined Jeff & FLOAT. You're going to get the lecture now about the evils of the DECIMAL data type. I'm sorry, but you've brought this on...

mtillman-921105 (9/14/2011)

---

Grant Fritchey (9/14/2011)

---

Changing the topic for a moment, I'd like to beg some ideas from the group, again.

I'm tasked with writing another article. This one is all about the...