Viewing 15 posts - 526 through 540 (of 5,103 total)
ichbinraj (2/10/2009)
February 10, 2009 at 2:18 pm
eduardo.pin (2/10/2009)
noeld (2/9/2009)
Looks like someone ran the script to move tempdb from drives and never rebooted the service, which is required!
I did the first SYSALTFILES select posted after...
February 10, 2009 at 2:07 pm
TRACEY (2/10/2009)
Usually they set an isolation mode in their...
February 10, 2009 at 12:33 pm
TRACEY (2/10/2009)
Usually they set an isolation mode in their...
February 10, 2009 at 12:29 pm
TRACEY (2/9/2009)
Thanks i will set that up on a test system and see what the ramifications are when transactional replication is updating the reporting database.Thanks for you time.
There are occasions...
February 9, 2009 at 2:56 pm
That is a task for Client-Side "IF" you want to engage on such venture.
There are *many* cases where developers use select * from just to read a couple...
February 9, 2009 at 2:52 pm
SORT_IN_TEMPDB reduces the size needed on the destination because the "sort runs" and "mapping indexes" (and version store if online) are not allocated on the destination.
Now, IF you rebuild ALL...
February 9, 2009 at 2:31 pm
IF you are running this from stored procedure you can use "WITH RECOMPILE"
February 9, 2009 at 2:13 pm
Sorry:
RCSI = READ-COMMITED-SNAPSHOT ISOLATION.
You can enable it as:
ALTER DATABASE < dbname > SET READ_COMMITTED_SNAPSHOT ON;
Note: You need exclusive access to do that!
Hope it helps.
February 9, 2009 at 1:56 pm
Looks like someone ran the script to move tempdb from drives and never rebooted the service, which is required!
February 9, 2009 at 1:51 pm
shri_sastry (2/9/2009)
This may be simple, but how do I find out when was the last time the index was rebuilt. I am trying to make...
February 9, 2009 at 1:48 pm
SA (2/9/2009)
The database size is 46GB,...
February 9, 2009 at 1:44 pm
gharris_35 (2/9/2009)
noeld (2/9/2009)
You must change those that you can to VARCHAR it will reduce the width by 2
Unable to do so as the system needs to support multibyte character...
February 9, 2009 at 1:39 pm
Viewing 15 posts - 526 through 540 (of 5,103 total)