did you reboot the user's PC or log off and back on after adding them to the group? when you are log on you get a logon token or ticket,...

might be a PITA, but set all dev jobs to run as a special user account you create

create a trigger to drop all connections that aren't from sa or another...

how would you use this to audit changes?

if you have trouble with your subscriber or some other replication issues it may cause the transaction log on the publisher to grow until those commands are marked as replicated.

solution...

perfectly normal, the x64 instruction set was developed by AMD and Intel is using it on their CPU's. Originally Intel was pushing Itanium, but it's too expensive and a monster

not sure, but you can create an SSIS package to execute a DTS package. i have to create new DTS packages on a sql 2005 machine and this is how...

we put it in QA on a server with SP2 and no CU's. In a week or so we are putting it on a QA server with SP2 and CU10....

enable lock pages in memory for whatever account you run SQL under

there is a KB article on the paging file with a calculation, i like to use 2 - 4...

enable lock pages in memory, check the paging file settings because on x64 the default is too small

transcender is good if you don't know anything about the subject or if someone else is paying. otherwise they are way overpriced

you can audit SQL, it's just not set up by default because not everyone needs it and everyone doesn't want to put up with the overhead and it requires a...

i did something like this a few times

now i run the profiler to collect the bare minimum information and things like execution plans i check on my own

we have a table with 300 million rows and had an identity/PK column as the clustered index. lots of index scans on some queries. changed the Clustered index to another...

profiler

i wrote an sp one time with begin tran, go and end tran and it caused blockings after the statement ran. never again. i don't use these anymore