Brandie Tarvin (3/1/2016)

---

As part of some classes I've been taking lately, I had to do record some video presentations. I'd love some feedback on my latest, if none of you...

Before you repair with the data loss (which could be severe), identify that object by the object ID. If it's a non-clustered index, you can just drop it and recreate...

The basics will work. Mainly T-SQL is going to be fine. But I'd just get the 2014 SSMS out to people. The backward compatibility works, so it's safe.

There is no right answer. It's a set of trade-offs. Sacrifice some CPU and I/O to update the statistics and rebuild any execution plans versus have execution plans be out...

No. Full backups and log backups can be mixed and matched as long as you have the log backups in order. Taking a full backup, in and of itself, never...

If the process is, record some data and close the connection, open another connection later and read that data, then I'd say you just need a regular table. Don't try...

No. That's not about accessing the server. It's an internal, SQL Server to SQL Server communication mechanism. Read about it here. It's deprecated and Microsoft doesn't recommend its use.

Global temporary tables are removed after the last process that is referencing them closes. Because you're closing the process, and no other process is referencing the table, it gets closed....

Without seeing the code that's calling the backups, it's hard to tell you why it continued after you killed the process. However, in terms of stopping the backups, there's no...

If you showed what your WHERE clause is, it would be easier to answer this question.

There are a bunch of ways to move a database into Azure and you don't have to use Management Studio for all of them. The method within SSMS is to...

In SQL Server 2012 and earlier, if the value falled outside the range of statistics, the optimizer assumed that the number of values returned was 1 row. This changed in...

Sorry, been on the road.

First, you have OPTION RECOMPILE on your query. Whether your update your statistics or not, you're going to get a recompile every time that query runs....

It doesn't matter if there are 50 great presentations. My favorite intro topic is backups. Why? Everyone has a backup book, article, blog post and presentation, so what is one...

And that'll work, sort of. You'll have to resolve the counts on executions between each set of data collection. You'll have to sweat queries that aren't stored in cache so...