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...

why the id column? if you are only querying that one column just use it alone in the clustered index. i have tables where i have a int column for...

doublecheck with the SQL 2005 system view for fragmentation since dbcc showcontig is horribly inaccurate

and check for maintenance on the subscriber blocking replication. if you have enterprise edition make sure...