Identifying Columns to Create Index via T-SQL
To identify columns on which you need to create indexes for fine tuning query performances you can run the T-SQL...
2013-11-27
1,469 reads
Blog Posts
Master Data Services stops working after an upgrade
Recently some SQL Server instances at a client were upgraded to the latest cumulative update of SQL Server 2012 service...
2013-11-27
1,111 reads
Master Data Services stops working after an upgrade
Recently some SQL Server instances at a client were upgraded to the latest cumulative update of SQL Server 2012 service...
2013-11-27
2,687 reads
Review: The Abilene Paradox
The Abilene Paradox by Jerry Harvey is not a new book, written in 1988. It’s part of some reading I’m...
2013-11-27
1,332 reads
Wasted Space Per Database For Fill Factor: Quick Tip
As I keep looking for answers on Fill Factor... I keep finding interesting Metrics to look into. Looking my own...
2013-11-27
2,579 reads
What should a candidate know about your company?
I had a great comment (Ryan McCauley’s) on yesterday’s post that led to a great conversation on Twitter. The comment mentioned...
2013-11-27 (first published: 2013-11-19)
2,067 reads
Automated Permissions Auditing With Powershell and T-SQL: Part 5
If you’ve followed along to this point, and have assembled the pieces as I’ve given them to you, you’re now...
2013-11-26 (first published: 2013-11-19)
3,865 reads
Disaster Recovery Planning
As a SQL Server DBA it is absolutely vital you regularly take backups of the databases you look after. If...
2013-11-26
453 reads
HammerDB SQL Server Benchmarking Utility
Mike Fal
Everyone here knows how much I enjoy using the DVDstore database benchmarking utility to benchmark a SQL Server instance....
2013-11-26
1,792 reads
Review: The Year Without Pants
The Year Without Pants by Scott Berkun is about a former manager/now speaker and writer going to work for WordPress...
2013-11-26
497 reads
Blogs
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...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers