Hi.

This seems to be a relatively simple single SELECT statement.

Please...

Microsoft has a general formula. See this link:

http://technet.microsoft.com/en-us/library/ms190620.aspx

Simply put, no. Permissions to an object are deleted with the object.

Thanks

John.

Good or bad to rebuild all indexes daily...

I think that it is overkill to unconditionally rebuild.

I posted this elsewhere, but my recommendation is to get a hold of...

Does...

I'd go further and try to make the covering index the best it can be.

1. Run the missing index DM queries and discover as many index suggestions as fit the...

There is an excellent index defrag tool with tons of power that is free from Michelle Ufford. We use it in production here and I cannot say enough good...

General things to check on SQL 2008 when you are hit with a massive performance whack like that...

1. Is your ARITHABORT for the database set to ON? If not,...

We use DellQuest Spotlight for monitoring. Foglight is more for performance management. We had Idera and dropped it in favor of Spotlight, which has improved by leaps and...

Hi.

1. The posters who said that a blank date is a bad idea are correct. If you are using the script as a demo to show what you are...

I have seen Intellisense blocked by other queries, but it is the Intellisense schema query (to enumerate objects) that is blocked by another process, in tempdb. this is because...

Without knowing what is in the embedded scalar function, my first thought is why don't you simply do a SELECT? if you want to hide SQL from the user,...

aaron.reese (12/11/2013)

---

Are you talking about application performance or reporting performance.

If it is reporting, then I would be tempted to replicate the database and create reporting indexes. In a large...

Is your PK presently clustered? If not then you can create a clustered index...

Simon Facer (12/6/2013)

---

(1) Clustered indexes causes page splits. Yes, you get Page Splits with a Clustered Index, but Clustered Indexes do not cause Page Splits. Page splits are caused by...