Yeah, you nailed it. The extra bites are in the balanced tree of the index. But your napkin calculation should be fine for most purposes.

You might want to look at SQL Compare by Red Gate Software. It can compare objects between two databases, between scripts and a database, backup and a database or source...

It's actually a new thread from a divergence on another thread.

I'd say you need to define "down." Can SQL Server sit there chugging away with CPU hovering near 100% for...

Bing worked, but only returned a single hit.

If you're experiencing pain from Profiler, trace is one option, but since you're in 2008, you can use extended events. These are even more lightweight than trace and filter much...

Databases don't time out. Does the Profiler gui put a substantial load on a system that can cause memory issues, leading to blocking causing timeouts?...

But if there is a SQL Server 2012 instance, you can download and install SQL Server Management Studio for no cost. Actually, I don't even think you need to have...

I'd suggest a combination of capturing query performance metrics using extended events, and monitoring what is using tempdb by looking at sys.dm_db_session_space_usage dynamic management view. You need to know what...

And lanyrd is up to date now.

Yep, what Gail says. It's also in my signature below my posts.

All thanks to those photos with the...

Best of luck on the project. There are a lot of third party tools already filling this niche in various ways, just so you know.

Hard to make suggestions based on simply suggesting the number of jobs that a system can support. I've seen systems support outrageously high numbers of jobs, but the jobs were...

Also remember that changes in the optimizer from one version of SQL Server to the next can result in different query behavior. Most of the time you only see issues...

It really depends on what you're trying to do. If you need all records from table and only those that match from the other, LEFT JOIN is the way to...