Assuming the WHERE clauses of the delete statements place the processing squarely within the partition, no, I wouldn't expect to see a table lock. But, you never know. If your...

It really depends on what you're trying to do. The basic table valued function's nickname is parameterized view. These functions work pretty well on their own. They can be somewhat...

I have not used the BI edition. Standard or Enterprise is all I've done. Yes, I've done SSIS & SSRS. They're the same, effectively, in terms of licensing, as the...

I'm not 100% certain, but it could be that your backup file is corrupt. Try removing the file before you rerun the backup. Even though you're running INIT, it doesn't...

I've done a number of upgrades to 2012. There's no special things you need to do going from Standard to Standard in 2012. The upgrade process is pretty similar to...

The Availability Group functionality is not set up to move instances around. It's focused exclusively on a database or a group of databases. Now, you can make all the databases...

Take a look at the properties on the other operations. I'll bet you they're ordered operations. This is all good. An ordered seek or scan with a merge can be...

I don't see anything wrong with asking about the salary range. The thing is, the employer wants to get you for as little money as possible, so they're going to...

That's a very large topic and I'm not going to be able to tell you everything now.

First, be sure you know what the anticipated load on the system will be....

Pinal is a great guy. But, I wouldn't rely on those lists of questions and answers. I...

You might want to hire a consultant to do the interview for you. I know several people that are regularly doing interviews for employers that don't have the internal resources...

In order to collect a meaningful set of data, you're going to need access to the server. You can look at the information in dynamic management objects (DMO) such as...

I completely spaced asking, but who from The Thread is going to be here in OKC for #sqlsat125?

I thought we had an agreement. You wear the dress. I...

If you update the statistics for a table, it updates all the statistics associated with that table.

No, I wouldn't create or maintain individual statistics except in rare cases for tuning...