Index Fragmentation
So you’ve setup a bunch of indexes in your database to tune the queries coming in. They’re all running much...
2014-03-13
2,485 reads
Blog Posts
Quick tip: Querying AD with xp_logininfo
We all have blind spots in our knowledge. We don’t know they are there and when we are thinking through...
2014-03-13
741 reads
Real-time query access with PDW
The Parallel Data Warehouse (PDW) officially supports Analysis Services as a data source, both the Multidimensional model (ROLAP and MOLAP modes) and...
2014-03-13
1,554 reads
Some Notes On Writing A Question Of The Day
I wrote Write The Perfect Question (Of The Day) last week and yesterday dropped a note here about my latest...
2014-03-13
473 reads
Speaking at Midlands PASS Chapter tonight
The Midlands PASS Chapter is an official PASS (Professional Association for SQL Server) chapter located in Columbia, SC. It’s free...
2014-03-13
463 reads
SSRS Top N and Bottom N reporting with Duplicates
Previously I wrote a blog on Top N and Bottom N reporting. There were a couple of gotcha I did...
2014-03-13 (first published: 2014-03-03)
2,983 reads
Tables without Clustered Indexes?
Today, we experienced performance issues with some of the SSRS reports that were deployed as part of the latest application/database...
2014-03-13
3,253 reads
Upcoming Webinar – Bringing Power BI Q&A to your Organization
Come join me for this webinar on 4/15/2014 at 11:00 AM EST
Bringing Power BI Q&A to your Organization
Q&A is an...
2014-03-13
761 reads
Upcoming Webinar – Creating Power Map Reporting Solutions
Come join me for this webinar on 4/17/2014 at 11:00 AM EST
Creating Power Map Reporting Solutions
Excel 2013 with Office 365...
2014-03-13
759 reads
Virtual Lab – The Domain
This is part of my series on building a virtual lab for use with SQL Server and Windows. You can...
2014-03-13
1,077 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