Execution Plans – Table, Clustered Index and Non-Clustered Index Scan
An important operator to understand in execution plans is a scan. A Scan can be good and bad, so understanding...
2012-04-02
4,321 reads
Blog Posts
Goals – 9 month checkup
Nine months down, three to go*. It’s time once again to see where I’m at with the goals I set...
2012-04-02
977 reads
Mirroring Support for SharePoint 2010 Databases
Like all systems built on top of SQL Server SharePoint 2010 needs to have a plan for availability. There are...
2012-04-02
1,232 reads
Move the T-log file of the Mirror Database
On more than one occasion, I have run into a case where a large database with a large transaction log was being mirrored. Then a hiccup comes along –...
2012-04-02
15 reads
Move the T-log file of the Mirror Database
On more than one occasion, I have run into a case where a large database with a large transaction log...
2012-04-02
860 reads
Parallel Data Warehouse – Slowly Changing Dimension
Most of my day-to-day work is currently centered around Microsoft’s Massively Parallel Processing Appliance call PDW (Parallel Data Warehouse). Many...
2012-04-02
1,855 reads
Rebuilding System Databases
Today’s post is something I thought I would share as there is an awful lot of incorrect commands I have...
2012-04-02
819 reads
SQL Saturday #131 – Phoenix Schedule Posted
I got an email today from the SQL Saturday #131 crew with the schedule posted, showing me listed for two...
2012-04-02
941 reads
SQL Server 2012: SSAS enhancements
My previous blog, SQL Server 2012 (“Denali”): Details on the next version of SSAS, talked about the major new feature in...
2012-04-02
2,698 reads
SQL Server Log Backups
While presenting a session on Common Backup Problems both at SQL Saturday in Orange County and at SQL Connections in...
2012-04-02
1,061 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers