I wrote an article [/url]a while back here on SQL Server Central that covers a lot of the questions here.

You do need to monitor the amount of space taken up by the log. You should also monitor disk space in the space where the index is stored and in...

I'd double check the security for the account that's running SQL Server. The error you're getting is a security error. It doesn't sound like that account has the correct privileges.

It does depend on what we're talking about when we say functions. If you're talking in-line table functions or multi-statement table valued functions that are created within SQL Server, then...

To investigate why you're getting recompiles, I'd put extended events on the server. You can capture the recompile event and it tells you specifically why it was recompiling. You can...

Hard to completely understand what you're going for, but it actually sounds like a many to many relationship, not one to many. In this case, I'd have TableA which is...

As much as you can, I'd try to keep any queries against the SQL database up in the Azure cloud. Any, regardless of if you write them or you use...

tcronin 95651 (6/24/2014)

---

actually she is right about the indexes however it does not look the the engine uses them correctly. I had a table variable with 200 rows an...

WHOOP!

I wouldn't want to simultaneously build a cluster while upgrading a server with databases in place. Way too many things can go wrong there. I'd prefer to build a cluster...

If the database is going to grow to 10gb once every 10 months, why not just leave it at 10gb. The shrinking, or not shrinking, has nothing to do with...

By archived, do you mean backed up? If so, then you can query the msdb database to see the backup history[/url]. If you mean some other process where data is...

On a database that small... I wouldn't sweat it, but if you are worried, take more frequent log backups. That will reclaim space faster.

Don't do that.

If your log it growing over and over again, you need to determine why it's growing. Deal with that cause. Set the log to an appropriate size. Make...

Rebuilding the indexes removes wasted space by moving rows that are distributed across a lot of empty space and compacting them into individual pages. This allows for more compression. Regular...