If you want to reclaim or rather not double your allocation for the rebuild then drop and then create your indexes. Or, Disable the nonclustered index and then rebuild.

http://msdn.microsoft.com/en-us/library/ms179542(v=sql.105).aspx

or google...

DugyC (3/30/2011)

---

Technically the question and answer are correct.

The OP was not asking what indexes can be created on the view, but instead "which of the following SQL statements can you...

Indianrock (8/5/2010)

---

Adding domain groups as sql logins is risky unless the data admin people control who goes in and out of such groups.

...she sent a ticket to our Systems group...

ZeeAtl (2/22/2010)

---

Kathi,

A question I have is this about removing BUILTIN\Administrators from Security->Logins on SQL Server [2005] instance.

If I remove this account from Logins, but the domain users remain as Local\Administrator...

Love the analogies Bob.

So very true regarding your second analogy. Not that I could find it in my heart to tear down a Wright building--that is another option...

blandry (12/16/2009)

---

I hate to throw a whine at you, but your post presumes that all over the world a DBA can be measured to have the same basic skills from...

As ALZDBA points out--It is better to create a windows account for the service to run under than NT Authority\SYSTEM. Granting permission to NT Authority\SYSTEM gives "any" service or...

Hi Grasshopper,

There is no "Disable" but "Deny" will certainly work for testing purposes.  I would eventually delete though or someone may come along a grant access.  In our Corp environment...