For those of you in the Denver area, SQL Saturday is this weekend! I’m speaking and hope to see you there.
If you haven’t registered yet, no problem. The details are here:
http://www.sqlsaturday.com/774/eventhome.aspx
There’s a ton of great speakers and you don’t want to miss this one.
I’ve read a lot of things lately pointing to scalar functions as if they were the devil. In this blog I’m going to explore if that’s the case. Let’s have a look.
Missing indexes are an important part of the indexing strategy. I usually start with sys.dm_db_index_usage_stats to find both inefficient and unused indexes and then supplement with missing indexes.
The missing index DMVs are great but they’ve always been missing something.
It’s Friday and I’m ready for the weekend as I’m sure everyone else is. This weekend I’m looking forward to getting yard work done and browsing through the whoisactive SQL Ops Studio extension code.
If you’re in Chicago on March 17 and have some free time, why not check out all the cool kids?
One of the things I enjoy most is diagnosing storage latency. I honestly couldn’t tell you why I enjoy it so much; but, I just do. When it comes to storage in Windows one of the best things you can do is capture an ETL trace for the STORPORT driver.
I’ve never been a fan of a GUI for DBA work. Give me a hand crafted script or a list of DMVs and I’m a happy camper.
Perfmon is probably my best friend. It’s always there and happy to tell me the truth. It seldom falters and has helped me get to root cause on even the toughest of performance issue. But what about PaaS?
Databases are platforms that are designed to securely store and retrieve your data. Perhaps that’s why they’re called a data “base”? So if your data is in a base, you’d want to lay it out in some logic way.
In case you missed the first post on this topic, you can read it here: SQL Server: SARGability. This post continues the series and today we’re going to discuss the dangers of functions.
SARG is short for Search Argument. This is an important tuning term and something every developer and DBA should know. I plan to do a few blogs on this topic and today marks the first.
