SQL Master

Today I’ll show you some different methods to run a DML operation like UPDATE in small batches for a large table.  Though I’m going to show ...

Today I am going to talk about one new feature that is been introduced in the SQL Server Denali.   And that is:  one interesting enhancement...

Everybody has different views about VIEWS, that’s what make them interesting topic to discuss.  Other thing is if you make some assumptions ...

Today 2 of my colleagues from reporting team had this requirement. They had one table where Seconds were stored as INT and in report they wa...

After remaining quiet for almost a year I’m back with what I enjoy the most, talking about SQL and sharing whatever little knowledge I have....