OK, here are the details. I have an SQL server with a database that is currently in used on a live website. The website is currently running as a cold fusion app. I have spent the past week converting ...

All,<BR><BR>First, apologies for the ugliness of the below.. I'm no expert!<BR><BR>To summarize, I'm trying to build a query I can run that I can run from the SQL Agent to email me daily reports..

One reoccurring SQL Server question that I see: Why is my TempDB database so large and what can I go to reduce the size of TempDB? The answer requires some basic understanding of the internals of how ...