Just bear in mind that by setting a fill factor to 75%, your table is now taking a fair bit more pages. This means more space on disk, more space...

tfifield (3/11/2009)

---

P.S. Be wary of the NOLOCK. I actually had a report that would periodically return 2 rows instead of 1 for an item in a high transaction...

SQL 2000 or SQL 2005?

This is the 2005 forum, but you mentioned SQL 2000. Which is it?

There's also the row header, the null bitmap and the variable column offset to take into account. If the clustered index is not unique, you also have a hidden 4...

Dp you perhaps have two or more backups in one file? If you backup to a file with an existing backup and don't use the WITH INIT option, the new...

Nolock allows for what's called an allocation order scan, where the storage engine reads the index leaf pages in the order they are in the file, not the logical order...

Lynn Pettis (3/11/2009)

---

GilaMonster (3/11/2009)

---

Bet you a coffee that either he...

Provided you don't...

Bet you a coffee that either he comes back with...

Personally, I don't use the ITW...

My gut feel is that the function is, if not the root of the problem, obscuring the root of the problem.

Can we see the code for the function? We...

Profiler or a server-side trace.

barcode (3/11/2009)

---

My Question: Will it help if I spent time on the database, clear all existing indexes, then start and create the correct primary key for each column. ...

CrazyDBA (3/11/2009)

---

I have investigated through dbcc log info, all log files have most VLF's(about 400) with status 0, only couple has value 2. Its size should come down to about...

Giovanni (3/11/2009)

---

I confirm the design is related to OO structure that we have to write in c#: mapping a class to the view instead of having a business logic to...