Viewing 15 posts - 916 through 930 (of 5,103 total)
Good Luck..
It is really not that hard to put together srcripts to addpublications/subscriptions based on some metadata. We spent some time ironing out the details and we have so...
October 10, 2008 at 3:36 pm
... is there any way to generate a script for the whole replication shootin' match from the "old" servers?
Yes replication settings can be scripted out but either you will have...
October 10, 2008 at 12:04 pm
Marios Philippopoulos (10/10/2008)
Yet, when I...
October 10, 2008 at 11:52 am
CrazyMan (10/10/2008)
Do i have to update database status using SP_Updatestats after using alter index statement for table defragmentation...
October 10, 2008 at 11:48 am
steveb (10/10/2008)
Do you...
October 10, 2008 at 9:26 am
I would do it this way:
1. Take a full backup of each DB, Compress it and start log shipping it. You can d that "NOW".
2. After you are sure...
October 10, 2008 at 9:18 am
You should know that with ( nolock) can read dirty values and even return duplicates if it hits a hot spot.
If your queries are reading mostly historic data you should...
September 25, 2008 at 2:50 pm
chileu17 (9/25/2008)
And hhhmmm :ermm: excuse my question :ermm: but how do I check if I...
September 25, 2008 at 2:48 pm
This kind of problems comes along usually because of a *bad* workflow design. You should know when to insert,delete,update. That way your opperations are atomic. IF you still can't fix...
September 25, 2008 at 12:27 pm
Answer:
"%" operator is NOT SARGable, therefor you are forcing an scan. Because the space that the clustered index used is bigger than that of the non-clustered it is in fact...
September 25, 2008 at 12:07 pm
chileu17 (9/25/2008)
"...Another point to note is that an index (clustered or non-clustered) cannot be built online if it contains LOB data (text, ntext,...
September 25, 2008 at 11:49 am
I am sure your bottleneck is not SQL Server. I definitely handle a much higher rate.
- You should profile what is really going on.
- Make sure you...
September 16, 2008 at 2:12 pm
b_boy (9/16/2008)
I have a table that consist of a unique field (CC #), and what I want to do is to retrive the number of Orders (OrderID) placed with the...
September 16, 2008 at 12:53 pm
how do i know which accumulative patch i got
September 16, 2008 at 12:51 pm
PaulB (9/15/2008)
Steve Jones - Editor (9/15/2008)
I disagree. Clustering doesn't scale out at all. It provides redundancy, HA solutions, not scale out.I'm in agreement with your disagreement 😀
NICELY put!
September 15, 2008 at 12:28 pm
Viewing 15 posts - 916 through 930 (of 5,103 total)