The differences in our database are pretty drastic. From 70-> 20 gigs using a good amount of page level compression. I'm thinking that is due to us having...

Nicholas Cain (3/25/2010)

---

Take a look at this best practices article from the SQLCat team out on MSDN http://msdn.microsoft.com/en-us/library/dd894051.aspx. It's got some really in depth information and a graph that shows...

Nope, I'm not, that's the problem. We're currently running on SQL 2000 for all our production system, and there are pretty significant infrastructure changes between that database and the...

Paul White NZ (3/25/2010)

---

Grant Fritchey (3/25/2010)

---

The uniquifier (or uniqueifier) is a 4byte integer value. So from that you can estimate the cost to the size of the index. So that...

I've run both scenarios now (Creating the clustered index on an Identity column, which I had to roll back and creating the clustered index on the existing createdate column). ...

And what opportune timing, with April...

So... apparently the identity column poses issues with the Application and I need something that can be directly inserted into. Going to try to do this a different way.

All...

Heh, no, you mistook me. I wasn't cranky at all. I was joking around with them all being buzzkills with the 'already knowing it' and letting you know...

Fine, I'll bite. I didn't!

Thanks for the feedback and the suggestions Grant. I'm still pretty useless at powershell, but I thinK I've figured out a pretty decent way to do it. I'll...

Not as much as I'd hoped. Here are some KB articles on the debugger in SQL 2000. Sorry I can't give you a more specific answer.

http://support.microsoft.com/kb/280101

You might also...

There are many different options for this in SQL 2005. See the link in my signature referencing string concatenation and post back with any questions.

I believe normal hotkey usage is that F1 just opens BOL, SHIFT+F1 opens it and goes to the section you have a word highlighted from.

[Edit] OOps, didn't realize how old...

If you don't need 100% accurate results (This should be at least 99.5% accurate), you can just do something like this:

SELECT OBJECT_NAME(id) AS [TableName], rowcnt AS [RowCount]

FROM sysindexes I

WHERE indid...

Can you do a SELECT @@Version on both production and test?