Viewing 15 posts - 1,741 through 1,755 (of 3,011 total)
Was it really necessary to post this question 6 times?
July 8, 2009 at 2:12 pm
drodriguez (7/7/2009)
I rather not try in that it my affect our production environment.
I'm not sure why you would have reservations about using sp_updatestats.
sp_updatestats is just another method of updating statistics,...
July 7, 2009 at 3:07 pm
How long does it take if you just run sp_updatestats?
July 7, 2009 at 12:56 pm
We are using it. I haven't noticed any negative impact on performance.
It does seem to have eliminated some problems we had with deadlocks.
July 6, 2009 at 9:32 pm
You might want to consider setting your database to READ_COMMITTED_SNAPSHOT. Select queries will not be blocked by INSERT\UPDATE\DELETE operations because it will use row versions to maintain transactional integrity...
July 6, 2009 at 2:49 pm
Always good to introduce yourself to people by telling them how much you hate them. Leaves a lasting impression.
July 6, 2009 at 1:46 pm
I think everyone is being a bit hard on Brian. I'm sure he knows what Independence Day is all about, but he was just writing about the joyful childhood...
July 4, 2009 at 10:07 pm
Becoming worthless? No, they were always worthless.
July 1, 2009 at 7:11 pm
I think you can hide data from the profiler by including certain key words in a script. I believe that "PASSWORD" is one. Drove me crazy that I...
July 1, 2009 at 7:06 pm
Did you run the script to see how much space is actually used in each datafile? What were the results?
July 1, 2009 at 12:20 pm
Make sure you are doing the shrink the correct way, and that you really have free space in the files. The script on the link below will tell you...
July 1, 2009 at 10:34 am
We reboot servers when it is needed for patches, hardware or software installation, or other specific need.
When people suggest that we do it on some regular basis “because SQL Server...
July 1, 2009 at 10:26 am
Paul White (6/30/2009)
...And hey look I fixed the SQRT expression - it was the wrong way around before.
I was pretty sure I tested it... :unsure: Still, it was rather...
July 1, 2009 at 7:48 am
WayneS (6/30/2009)
SimonH (6/30/2009)
IF EXISTS( SELECT [name] from tempdb..sysObjects WHERE [name] ='#Store' and xtype ='U')BEGIN
DROP TABLE #Store
END
Simon,
Just as an FYI, this is not the correct way to check for a temp...
June 30, 2009 at 10:32 pm
This script will give the row counts and space used for each table in a database.
Script to analyze table space usage
June 30, 2009 at 10:24 pm
Viewing 15 posts - 1,741 through 1,755 (of 3,011 total)