It is possible that it would be in a maintenance plan. It is possible that it is being run through a 3rd party app. It is possible that...

Load the rdl file into a solution and then get the sql statement from there.

Otherwise, parse the xml...

I think it would be a good idea to first familiarize yourself with the data and processes before trying to assess which tables, procs and indexes are unused. As...

I think that security is the duty of all involved from end-user to developer. However, one thing to consider in the economics of security is the annoyance and cost...

If you have a backup of the database, then...

Do you have backups of your database?

I read this article expecting Rainbows and Unicorns. Instead I got Homer and Pizza. What a warped sense of humor you have. 😀

Seriously though - Well Done Brandie.

Index Maintenance

Backups

Integrity Checks

Deadlock monitoring

EZ PZ

Thanks

Have you tried to manually shrink?

Also, after shrinking, did you also do an index defrag? Reindexing can cause the database to grow back out.

The X isn't necessary. You asked about delete statements not working with aliases. That is merely a demo showing that aliases do in fact work with delete statements.

As...

I agree...

Here is a script demonstrating a delete using an alias as well as using the alias X

Use Tempdb;

GO

CREATE TABLE demodelete (somenum INT);

INSERT INTO demodelete (somenum)

VALUES (1),(2),(3),(4);

SELECT * FROM demodelete;

DELETE X

FROM...

Here is an article from microsoft on creating SQL Agent jobs

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

Add the query to a SQL Agent Job. Schedule the job to run nightly.