Fill Factor and wasted space: Quick Tip
This is a little excessive, but here's a quick script to show you your fill factors per table that are...
2013-11-21
915 reads
Blog Posts
JFK
“There is little value in ensuring the survival of our nation if our traditions do not survive with it. And...
2013-11-21
634 reads
Learn About PCI Today
I’ll be presenting PCI for the SQL DBA today at 1 pm EST for the PASS Security Virtual Chapter. Depending...
2013-11-21
628 reads
Notes from SQLSaturday in Oregon Nov 16, 2013
I wanted to take time to thank our sponsors, speakers and volunteers for making #sqlsat265 a big success. Over 400...
2013-11-21
576 reads
Powershell in a Month – Day 3 – Commands
This is part of my Powershell Challenge, to learn more about Powerhsell (PoSh) using the Learn Windows Powershell 3 in a Month...
2013-11-21
1,338 reads
What Happens In Vegas…
…stays in Vegas, except when it comes to chocolate. After walking more than 1500 miles over the past 9 months,...
2013-11-21
518 reads
A pattern to do beginning of period calculations.
Beginning of period calculations are common things. Rolling month reports, queries to pull everything from last month etc require beginning...
2013-11-20
777 reads
Automated Permissions Auditing With Powershell and T-SQL: Part 6
Everybody still with me? Have you tried the script from Part 5? Did you notice how SLOW the Active Directory...
2013-11-20
783 reads
Backups and Consistency
I wrote about transactional consistency recently. Why do we need this?
Imagine that I have an orders table and an ordersdetail...
2013-11-20
1,045 reads
Indexing Fundamentals
First, lets understand what the types of indexes are. If you take a reference book, you have the two types...
2013-11-20
1,692 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