Monthly Archives: January 2015

Which is better Count (*) or Count (id)?

By | January 30, 2015

While conducting a training recently I was asked which is better Count(*) or Count(id) , while we wanted to discuss the topic further we didn’t have time so I promised to write a blog about it. Coming right down to it, in almost all cases Count(*) is better. Typically you won’t be able to tell… Read More »

SQL Server DEV and SSDT – MINDTREE – CHN – DEC

By | January 27, 2015

Some feedback from the training What did you like most about the training? Knowledge on SQL Trainers end to end knowledge about the tool. Explained concepts with hands on. Came to know topic didnt know earlier. Trainer was able to explain the topics covered in training. Performance improvement only by basic stuff(e.g. index) Trainer is… Read More »

SQL 2012 Administration Societe Generale – JAN

By | January 27, 2015

Some feedback from the training   What did you like most about the training ?   Trainer’s skill and experience in technology Skilled knowledge pool of the Trainer

SQL 2014 ADMIN, DEV – Wells Fargo – JAN

By | January 27, 2015

Some feedback from the training What did you like most about the training?   -Quite impressed by the way Jayant taught Performance tuning -In depth explanation of all the key concepts. -Given real time examples wherever needed which helps understanding complete picture

Part 2 Buffer pool extension SQL 2014

By | January 16, 2015

In this second part (read the first part here) of the series we continue testing the limits of our RAM and try to understand SQLs behaviour when it encounters memory pressure. To this end we have created a table that is little more than 2 GB in size and have set out SQL server buffer… Read More »

Part 1 Buffer pool extension SQL 2014

By | January 16, 2015

In this series I am going to cover the feature Buffer pool extension in MS SQL Server. Now before we can discuss this feature it might be a good idea to define what a buffer pool is and why it needs extensions in the first place. The buffer pool is that part of the RAM… Read More »