SQL Server – Its -MS + SQLServer
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 …
Read MoreSQL 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 …
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 …
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 …
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 …
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 …
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 …
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 …
Read More