1. Databases in AG must be in full recovery model. Newly created databases are in pseudo-simple until a full backup is taken. So, yes you need to take a full...

Thanks for your reply. I just came to also realize, if I have a 5 node cluster with only replicas in 2 of the nodes (e.g. node1 and node2),if node3,4,5...

This is a contrived example, but it is a common one that I have seen.

What happen in the query is that the ordering of the index initially was ModifiedDate,...

Congrats Mr Kesegic. You're just in time to board the last MCM train. Welcome aboard! 😉

Good luck Vedran.

Hope you pass the lab exam.

Paul White (8/15/2013)

---

Good stuff, Simon.

If people want to see the impact more clearly, pushed non-SARGable predicates can be separated out into a separate Filter operator by enabling undocumented trace flag...

romanilic (8/13/2013)

---

Interesting article.

I have index with 3 columns.

I get Index Seek with 2 columns in Seek Predicates.

And one column in Predicates: [T_Encounter].[sysDeleted] as [e].[sysDeleted]='N'

There are no hidden implicit conversions. ...

You are welcome 🙂

shankar.k (8/12/2013)

---

Hi Simon,

Thanks for the article. I have a basic question. My understanding of the indexes was to

> Create index on columns appearing in the WHERE...

hi curious_sqldba,

Its hard to describe your situation because query optimizer chooses a good enough plan depending on circumstance. For example, the number of records returned will have influence whether the...

gfey (8/12/2013)

---

Hi,

... On the other hand the resultset of first solution depends on the option ANSI_NULLS. If the option is set to ON the query returns only rows where carriertrackingnumber...

If you are remoting from outside the US, the latency can make things quite a bit harder.

Last year at PASS they had booths where people could take the lab exam....

Re your question 1.

You mention you wanted to do a side-by-side upgrade. So you don't need SQL 2000 to be on SP4 as a pre-requisite. You can perform a direct...

That depends. There is a lock escalation hierarchy, usually after page it is an extent (group of 8 pages). For more on escalation hierarchy, refer the link below:

http://msdn.microsoft.com/en-us/library/ms189849(v=sql.105).aspx

Furthermore, this hierarchy...

Congrats Uwe. Welcome to the MCM community 🙂