Sometimes it helps to go back to the basics and indexing is always a great topic. SQL Server has a wide variety of indexes; but, today we’re going classic and talking about Non-clustered indexes.
Category: DBA
Query tuning 101: What’s a probe residual?
Query tuning is an important process that will probably never go away and sharpening your tuning skills is always a good idea.
I’ve spoken on this topic many times and talked about probe residuals before. Mostly at SQL Saturday events and for some online webinars.
DBA 101: Comparing two SQL plans
Simple post today: How to compare two plans in SSMS.
This task is a task that is often done by a DBA or developer who is wanting to compare changes of an index or perhaps even comparing queries between DEV and PROD.
T-SQL Tuesday: Finding issues with your query plan
This is my first time blogging with a T-SQL Tuesday topic. If you follow my blog you’ve probably noticed that one of the topics I enjoy the most is performance and query tuning.
While at Microsoft, I learned a lot from a lot of great people, such as Joe Sack, David Pless, and Tunji O. I try to pay forward the knowledge that these great people have bestowed on me.
Wait Stats, Here and gone again?
Microsoft recently introduced a handy new feature to query plans: waitstats. That’s right, you can get actual runtime waitstats for a query you run.
DBA 101: File growth
Maintaining a database is an important job of the DBA role. One of the many maintenance tasks is ensuring that the disk does not fill up and your files are able to grow over time.
DBA 101: Unique Constraint vs Unique Index
Designing a rock solid application and database can be difficult. New features and overlapping features mean that you’re able to accomplish a single task in many ways. For instance the numeric and decimal data types. Which should you use?Read More »
DBA 101: What you may be missing with “Missing indexes”
If you’ve read my blog, I’m sure by now you know that I have no love for GUI tools. I will say they are improving every day and maybe, just maybe, we will see the day when you can click happily away and do everything you want. Sadly, this is not the day.
A while back, SSMS added the “Missing Index” data to the graphical query plan. They even made it really easy to add.
SQL TECH BLOG 