Nice easy question to end the week ....

You might want to look at the undocumented DBCC command

DBCC log ({dbid|dbname}, [, type={-1|0|1|2|3|4}])

where dbid is either the dbid or the name of the database

and type is the...

If you will post table definitions, sample data in a readily consumable format (To do so click on the first link in my signature block), some one will answer your...

Nice question

Ninja's_RGR'us (1/4/2012)

---

Revenant (1/4/2012)

---

Koen Verbeeck (1/4/2012)

---

Allright, I missed a few weeks of the thread because my wife gave birth to a wonderful son. (and thus killing my regular sleeping pattern)

Did I...

Is it just me, or has anyone else noticed what happened to the entry in the left most frame linking to that series of SPACKLE[/B] articles, it seems to have...

Thank goodness for Jeff Moden's writing in the series of articles called "SPACKLE"

Speakiing of thos short but SO INFORMATIVE ARTICLES, what happend to the entry in the left most...

Nice, even if a rather simple question (but it does take one back to the basics and because of...

Get it in your head .. hmm I had to take off my shoes and socks so I could continue counting on both my fingers and toes ......

Sapen (1/2/2012)

---

Hi Ron,

Thanks for the script. That really helps a lot. The sum(rowmodctr) column is returning records more than 45000 for some tables. But is there a way to know...

Why not build your own table. For example:

CREATE TABLE #Address(Id INT IDENTITY(1,1),Address VARCHAR(50));

DECLARE @N INT

SET @N = 1

WHILE @N < 100

BEGIN

...

Taking into account okbangas post above:

You might wish to minimize those tables whose statistics you are going to update by running the following. Then examining the results, and...

In your job are you using "UPDATE STATISTICS " or sp_updatestats ?

Are you defragmenting your indexes in that job as well ?

+1

HAPPY NEW YEAR