Viewing 15 posts - 646 through 660 (of 1,790 total)
Partitioning is not always a quick performance gain unfortunately. You need to make sure that the partition function you are using is really representative of how you are retrieving your...
May 1, 2009 at 12:05 pm
There is an extended stored procedure called xp_readmail which I looked at a long time ago but never tried to implement. It looks like they are trying to remove it...
May 1, 2009 at 11:56 am
Alternate thought too, Standby Server could also be referring to Database Mirroring. Again read up in BOL on that as well.
May 1, 2009 at 11:49 am
Standby Server would be relating to Log Shipping. You should be able to read through BOL for any information you need on that. Basically though it ships the transaction log...
May 1, 2009 at 11:49 am
If they need insert / update on all tables and only delete on the one then you could certainly leave the db_datewriter on and do the deny delete on all...
May 1, 2009 at 10:08 am
If the user does not already have delete on all the other tables then the only command you should have to execute is the grant delete on the one table....
May 1, 2009 at 9:34 am
No, the RS install worked fine but didn't work. I could never browse the "site". There are some interesting blogs / white papers to correct the issue (it is with...
May 1, 2009 at 9:27 am
I have tried that and it works through the WOW (Windows on Windows) functionality. I really didn't notice any problems but the question still has to be asked, why not...
May 1, 2009 at 8:27 am
...and an interesting post on this can be found HERE
April 30, 2009 at 3:36 pm
Marios Philippopoulos (4/30/2009)
David Benoit (4/30/2009)
Yup. There are other issues with this being virtual and this is just one of several warning signs which concerns me.
Slightly off topic, but what...
April 30, 2009 at 3:24 pm
What are you seeing when you look at the SQLServer:BufferManager Checkpoint pages / sec counter? On the server that I am looking at it is almost continuously writing pages (very...
April 30, 2009 at 3:23 pm
Yup. There are other issues with this being virtual and this is just one of several warning signs which concerns me.
April 30, 2009 at 3:05 pm
I have seen this too but only on a virtual server. I moved the database to a similarly configured physical and didn't have the issue.
I have a case with...
April 30, 2009 at 3:00 pm
Is this a virtual server?
April 30, 2009 at 2:51 pm
The experience I had was quite some time ago in technology time (4 years) so, this may be outdated. The solution we were using I only used to pump backups...
April 30, 2009 at 2:45 pm
Viewing 15 posts - 646 through 660 (of 1,790 total)