Simon Liew

How efficient is your covered index?

Observing an index seek utilizing a composite index within SQL execution plan might be more than meets the eye – you should look again.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.83 (111)

2015-10-09 (first published: 2013-08-12)

14,249 reads

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Every one and again you will see people asking What skill do you think...

Another post for me that is simple and hopefully serves as an example for...

I work on sql server 2012 i see constrain but i don't know what...

My SQL tools tell me this invokes an inefficient step with an index scan. ...

I have a table with three fields, FirstName, LastName and EmailAddress. The EmailAddress field...