Presenting with SSMS

Whilst presenting at a Microsoft Operations Day in Reading last Tuesday, I was giving a demo on some TSQL using SSMS. In order to ensure that the audience could see the text I naturally turned to ZoomIT until a member of the audience (one of our excellent Microsoft Program Managers – Thanks Pedro Lopes!) shouted…

0

SELECT *, Indexes, Data Access, and the Optimizer!

  Another great “Database Byte” by our US PFE guest writer Susan Van Eyck!  This time on the pitfalls of using SELECT * on huge tables and the effects on the optimizer.   A customer of mine recently had a problem – a legitimate need to use a SELECT * query (mind you, they had…

0