CirquedeSQLeil (8/24/2010)

---

Are you searching for dbname or was that just an example?

When I need a query to run across multiple versions (for instance in SSIS), I setup a query to...

CirquedeSQLeil (8/24/2010)

---

You could look into Central Management Server. That is an option that is available with SQL 2008. You can execute a query against multiple servers at the...

UPDATE:

I have to apolagize for wasting anyone times who read over this post. I just found out the article was specific to ORACLE, a DB platform that I can...

sturner (8/23/2010)

---

For one thing indexes on SQL server do not get 'degenerated'. They can suffer from excessive fragmentation or even just plain worthlessness.

Since indexes in SQl server are implemented...

UPDATE

Well this test of creating a duplicate index by a differnet name has appeared to of worked. The purge tool ran to completion without errors and the Index it...

Stefan_G (8/20/2010)

---

GilaMonster (8/19/2010)

---

It...

GilaMonster (8/19/2010)

---

It quite...

Derrick Smith (8/19/2010)

---

What is your MAXDOP setting on the server?

Index creation time is improved greatly by parallelism. Most of my OLTP servers have maxdop=1, but when I create indexes, I...

GilaMonster (8/19/2010)

---

YSLGuru (8/19/2010)

---

Bhuvnesh (8/19/2010)

---

Also know that this Purge tool we have been sent by the Vendor is not a step by step process so once it starts I have...

BTW - since I haven't gotten but 1 reply so far I just wanted to say that I'd appreciate any suggestions on where else to go and aks this quesion...

Bhuvnesh (8/19/2010)

---

You can do one thing , dont drop/create index instead , DISABLE it before purge process ( it must contain

INSERTION into destination table ) and then REBUILD...

This would require that you have security access on the domain to peruse whats on a server but the again I imagine any method of doing thsi would have something...

Sweet! ...

rudy komacsar - Doctor "X" (7/27/2010)

---

Here are a two suggestions:

Why use individual users, how about using Active Directory groups ?

(This may take a bit of analysis and lunch for the...

Jim McLeod (7/13/2010)

---

A possible option is to make it a rule to never click on the "Logins" node in Object Explorer without right clicking it and selecting "Filter" first. ...