Tempdb growth has to be because of tempdb use. There's nothing in the OS that's going to affect tempdb. It's not just temp tables. It's also any sort operations, index...

SQL is the original defined language and is maintained by ISO. Transact-SQL (T-SQL) is the name that Sybase gave to their version of the language and since SQL Server is...

You can use extended events to watch for the truncate statement. That's how I'd do it.

You want someone to give you their entire hand-built monitoring system?

For the SQL Server related counters you can just look at sys.dm_os_performance_counters. That will let you run queries to bring...

And remember, the missing index information, as is, doesn't relate directly to any query at all. So simply taking that stuff as written, you might be creating an index for...

When you select the time in the past, it changes the screen as you see. Next, you can click on the instance inside the server. If you do that, at...

Not a problem. Happy to help.

You could turn on profiler or, better still, extended events to capture the query executions that are occurring. But, there's a way to look at what was going on at...

Ha!

Well developers have their cross to bear as well as us. I get it. Entirely. However, I'm pretty sure, based on the info provided, that's where the problem lies.

A bunch of things going on with this one. First off, you're joining on views, which presumably have multiple tables joining together within them. That would reflect in the high...

Generally, but not always, instead of IN I would be doing a JOIN. The optimizer might interpret it that way any for you. Since you're going for matching records that...

It could be any number of things. Your best bet is to look at the error log and the execution log of your mirroring operation in SQL Agent. There's no...

I don't think there's a standard answer for either question. Auditing requirements are either a business or legal requirement. If the business you're working with doesn't need auditing, there's no...

I've been using Access as a front-end for Windows Azure SQL Database for a project for the Boy Scouts. It works well enough. You can get going pretty quickly. There...

Because you're using LIKE and the wild cards around a space, it's going to find every single record that matches up on any value that contains a space. You could...