i agree with shian. i've actually had instances where indexing on a bit field was extremely useful - though common wisdom suggests they may be more overhead than they...

I inferred that it was Processor related, but no, didn't state it outright. Interestingly enough, though SQL will install with this previously mentioned hack, I cannot patch it to...

this is what I had to do and it worked for me ...

I found it on this url - http://forums.amd.com/forum/messageview.cfm?catid=319&threadid=102894

Here is the solution for your problem

1....

Gail,

Sorry I wasn't more thorough in my question, I only initially wanted to know that my methodology for building the CHECKSUMS on the pages was valid. I'm used to...

Gail ... thanks again ...

I know that I need to run them weekly, and I am doing this currently. I don't feel like this is often enough especially since...

i will still absolutely be doing checkdbs, just not weekly

thanks. i know that checksums/backups with checksums are not replacement. however, ongoing weekly checkdbs are no longer feasible on my largest databases. i realize...

Thanks ... but I think I have my answer ... BOL ... http://technet.microsoft.com/en-us/library/ms189858.aspx

ALTER INDEX ... REORGANIZE will only organize the leaf level pages of the clustered index...

Thanks ... but I think I have my answer ... BOL ... http://technet.microsoft.com/en-us/library/ms189858.aspx

ALTER INDEX ... REORGANIZE will only organize the leaf level pages of the clustered index...

oh, and i've also used alerts to kick off that second query on the sysprocesses ...

IN SMS

1. SQL SERVER AGENT

2. RIGHT CLICK ALERTS

3. SELECT NEW ALERT

4. SELECT SQL SERVER...

Not easy unless you are running a continuous trace, and then you have to store the results, parse the results, ick.

I came up with a way to pull stats from...

in your registry make sure you have (under SOFTWARE\MICROSOFT\MICROSOFT SQL SERVER\MSSQL10.MSSQLSERVER\SQLServerAgent)

DatabaseMailProfile set to the one you just created

and

UseDatabaseMail set to =1

I had a bug, where even though I set...

I have i/o subsystem traumas on a fairly regular basis. I have migrated all databases from 2000 to 2005 and then to 2008. Some of the databases...

i love sql server central ... John you nailed it for me ... checked my system log ... a CRAP load of iscsi port errors. i ALWAYS forget to...

i think i may just burn that ticket. since i will be using manual snaps on all my production servers going forward, i'd like to know what the MS...