Index fragmentation is naturally happens as an action of insert, deletes and updates. It is important to manage this fragmentation, if not you can have
Author: Mohit
Microsoft Data, Analytics & AI - Sr Cloud Solution Architect - Engineering
Adventures in Installing the SQL Server AdventureWorks Sample Database
I was thinking of writing an article about Microsoft SQL Server T-SQL Basics; however, in order to do the examples and demos I wanted to
Whats the plan?
I don’t have one to be exact. But I am at Microsoft GeekREADY! conference, learning lots of interesting stuff. Some stuff about social networking and over
Finding All Plans/SQL Statements that executed in Parallel
References: #21 Statement copied from The Rambling DBA: Jonathan Kehayias Blog
Get Top 50 SQL Statements/Query Plans
Finding out what statements causing grief on SQL Server has become significantly easier with SQL Server 2005+. I am using some of the DMV/DMF to
1st Month at Microsoft…
FAST! I promise to not turn this into a personal blog and will start posting SQL related stuff again *soon*; just need to get my
SQL Canada (SQLCAN) 