It's probably because the SELECT criteria only converts the information returned, but the WHERE clause, since it's a function on a column which means a complete scan of the table...

Since you're moving to 2012, you can use distributed replay to test the new server. That'll work better than using Profiler. And, it's a great new tool in your 2012...

It really does depend on the indexes and statistics on the table, but most of the time, option 2 is the right way to go. And when it isn't the...

After seeing Lynn's comments about SQL Server Performance, I read through... well, attempted to read through a couple of articles over there. I have to ask, who is running that...

That is not behavior I've run into before. Is there something special about your domain setup? I use domain specific logins for all my installations and haven't seen this type...

I'd go with 2012. I still haven't finished upgrading to it here, but it offers opportunities that don't exist in 2008R2. But, you do have to deal with the crap...

I'm not comfortable with any of those answers. A is somewhat true, but so is B. I'd have to choose E if pushed, but I'd want to have a long...

None of the above.

Use the source control system that has all the database objects in it to run an automated build for the new people. But not to create 10...

You can also create extended events to capture all logins.

Was it always one word? Back in the day? Where's Jeff. He remembers the dawn of time. If it used to be Data Base, then DBA makes sense.

So when the load is complete, you need to send an email? Couldn't you just add that to the end of the load process? A trigger will work, although I...

Since no one is sitting at your desk with a full...

I'm still back to hard to say, but, in general, I would avoid holding open a query, on purpose, for 15 minutes under any circumstances. The fundamental concepts of transactions...

jitendra.padhiyar (1/8/2013)

---

Thanks a lot Arjun !

You explain me what exactly statisc is and what the sql server doing during update statics. Can you pls clear my more doubts?

1. Is it...

Kishore-132325 (1/7/2013)

---

but UPDATE STATISTICS with FULL SCAN will scan for the entire table everytime and unnecessary update stats even if its not needed. i ran a samle update stats with...