When row estimation goes wrong
Whilst working at a client site, I hit upon one of those issues that you are not sure if that...
2012-11-29 (first published: 2012-11-26)
2,272 reads
Cyber Monday: Performance Indexing Book is $15
Ever thought you could learn a little bit more about indexing? Now here’s the perfect opportunity. Today only you can...
2012-11-26
819 reads
Tip: OVER and PARTITION BY
I like to repost this blog about once a year, because you really really need to know about windowing functions....
2012-11-28 (first published: 2012-11-26)
4,619 reads
SQLIO Analyzer Latency Divide by Zero Issue Corrected
A special thanks goes to Daniel Angerer (t) for suggesting an improvement that corrected the divide by zero error that one...
2012-11-26
1,233 reads
Last Weeks Top 10 “Reading” Links #8
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-11-26
637 reads
Choose specific folders to sync with SkyDrive
Every time you run the SkyDrive Client on your device, a laptop in my case, all your files from the cloud are downloaded to...
2012-11-26
969 reads
Ybor City Farmers Market, Dogs, Kids, and Observations
Last weekend I was in Tampa for SQLSaturday #168 and made sure to make some time for family. The most...
2012-11-26
910 reads
Can’t access Operations or Applications tabs from Central Admin WSS 3.0 SP 2
Hey Friends,
Sometime when we try to access central administration and certain tabs like operation and Application management we face issues....
2012-11-26
498 reads
Reducing the size of the distribution database & improving transactional replication performance: Part 2
The impact of having data sitting in the distribution database that doesn’t need to be there can be significant. The...
2012-11-26
4,088 reads
Time Pass With Transaction Log - Part 4 DDL
In this article, We are going to CREATE/ ALTER/ DROP a table and observe transaction log records created for those DDL statements.
Our...
2012-11-26
3,545 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