i get full logs when running alter index sometimes

only solution i found is to increase the threshhold so less indexes are rebuilt

check the NTFS permissions on the drive and the files. should be full control for the sql service account. i think you also have to change a few things inside...

i use sessions and connections dmv's to store this including queries. with queries it takes up a lot of space. a lot.

write a join depending on the columns you want....

you might want to look at full text indexes

i have a database with a lot of varcha(255) columns i have to search through and full text indexing is a lot...

last 5 years Oracle has gone on a shopping spree buying up all kinds of server application companies. BEA, Peoplesoft, etc etc. if you want to run one of these...

we used the above procedure last year when we first upgraded. worked for us. we found a few queries using an in statement that caused it.

MS changed the optimizer from...

TRACEY (4/26/2008)

---

We just implementing this in our SQL....that we have AD Groups and people are assigned into this group. This is great saves having tom, dick and jerry in...

use the new sql 2005 commands, they are a lot better than the old sql 2000 ones

set up a clustered index to start

sql mail won't work on 64bit so you may have to change everything to db mail. check the page file settings since the default ones are wrong. drivers are still...

i had this on 64bit servers in a few cases

solution was to enable lock pages in memory, not sure if you need to enable AWE and the rest on 32...

as a former exchange admin, tight AD integration is the last thing you want

with sql you can detach and attach databases on any server and restore to any server under...

i doubt it

that's why you always test in QA. for our billing apps the rule is to test with a hotfix on one server and on a regression server with...

will try it today

tried a test with one table. first i ran just a select on the data to be inserted and it came back in a few seconds. when...

suku (4/14/2008)

---

Hi,

I had to go with the composite clustered index(cSpecialty, id) columns becuase, the cSpecialty column is not unique by itself, so had to join that with the auto increment...