SQL Server Education (by the geeks, for the geeks)
I love giving interviews, one of the question asked in one of my interview question was “on which particular edition automatic page repair is possible (in context of database mirroring)”. That …
SQL Server – Its -MS + SQLServer Read MoreHere goes my 2nd part of Tune your SQL Server subquery Well,if my query is having UNION operator,we normally replace it by UNION ALL to improve performance According to itzik-ben gan …
SQL Server Subquery – Tune your Subquery-2 Read MoreHello friends One of the Fav question asked in most of the interviews is to explain diff SQL Server recovery model . All they want to listen from you is word …
SQL Server Recovery Model Deep Dives Read MoreHi Guys Sorry for discontinuation from tune your queries.I was preparing for a interview and got to know very intresting thing. As a DBA we all know about SQL Server IAM …
SQL Server IAM Pages – So you know your IAM Page number Read MoreHello, As a DBAs we get lot of request to tune queries and we normally suggest to create Index or Update Statistics but tuning also needs rewriting of actual query and …
SQL Server Subquery – Tune your Subquery part 1 Read MoreLocking behaviour of Indexes while updating rows Hello all, The theory I am presenting you is from Reading in database systems and I find it valuable Today I will discuss about …
SQL Server – When it comes to lock index while update-2 Read MoreIts my first blog so want to dedicate someone and make it special in some ways. You cann’t use it practically but it will clear some of your concepts. I have …
SQL Server – When it comes to lock index while update Read More