How SQL Server statistics are generated and updated
One of the easiest ways to increase query performance on your database is making sure your statistics are up-to-date. Statistics...
2014-05-16
457 reads
Blog Posts
Reblog: May 9 to May 15
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-05-16
713 reads
Statistics Parser
A quick plug today for Statistics Parser by Richie Rump, a free web site that takes the output from “set...
2014-05-16
1,075 reads
The Tipping Point – by Malcolm Gladwell
The latest book that I finished reading was The Tipping Point, written by the Malcolm Gladwell. I would recommend this...
2014-05-16
186 reads
T-SQL Tuesday #54 - Interviews and Hiring
This month’s T-SQL Tuesday is hosted by Boris Hristov (blog/@BorisHristov) and his chosen topic is “Interviews and Hiring” – specifically interviewing...
2014-05-16 (first published: 2014-05-13)
2,479 reads
T-SQL Tuesday #54 - Interviews and Hiring
Well, it's that time again! It's TSQL Tuesday #54, and its about Interviews and hiring. I'm writing this free style...
2014-05-16 (first published: 2014-05-13)
3,776 reads
T-SQL Tuesday #54 – Interviews and Hiring
This month’s T-SQL Tuesday is hosted by Boris Hristov (blog|twitter) and his chosen topic is “Interviews and Hiring” – specifically interviewing and hiring...
2014-05-16 (first published: 2014-05-14)
1,762 reads
T-SQL Tuesday #54: Interviews!
It’s T-SQL Tuesday again and this month our host is Boris Hristov (b/t). He has asked us to discuss Interviewing....
2014-05-16 (first published: 2014-05-13)
1,624 reads
ExpressProfiler: The New Kid on the Block
I'm pleased to inform you that yet another of my pet-projects, ExpressProfiler, joined the rapidly growing family of Ecosystem-based tools...
2014-05-15
624 reads
Migrating SQL Server logins
Once upon a migration I would use sp_help_revlogin to migrate logins and remap the SQL server logins using sp_change_users_login. During...
2014-05-15 (first published: 2014-05-07)
9,660 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers