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...

Yes replication settings can be scripted out but either you will have...

Marios Philippopoulos (10/10/2008)

---

I'm looking at the BOL documentation of view sys.sysdatabases (http://msdn.microsoft.com/en-us/library/ms179900(SQL.90).aspx) and the status column is supposed to have the value of 512 for an offline database.

Yet, when I...

CrazyMan (10/10/2008)

---

Hi All

Do i have to update database status using SP_Updatestats after using alter index statement for table defragmentation...

steveb (10/10/2008)

---

Thanks, no we don't have another server available that we can use. We have decided to go ahead with a 2008 license to act as a Distributor.

Do you...

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...

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...

chileu17 (9/25/2008)

---

I didn't have any other processes running on my server when I started my indexes rebuilt.

And hhhmmm :ermm: excuse my question :ermm: but how do I check if I...

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...

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...

chileu17 (9/25/2008)

---

Hi everyone, I found this in a website

"...Another point to note is that an index (clustered or non-clustered) cannot be built online if it contains LOB data (text, ntext,...

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...

b_boy (9/16/2008)

---

Hello

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...

http://support.microsoft.com/kb/937137

NICELY put!