Using SQL Server DMVs to Identify Missing Indexes
I can run the Database Tuning Advisor or examine the query plans, but is there any easier way to determine which indexes may be needed?
Getting Close to Physical - Database Weekly (Nov 8, 2008)
The performance of virtual machines is getting closer and closer to that of physical machines with better software like Hyper-V.
Getting Close to Physical - Database Weekly (Nov 8, 2008)
The performance of virtual machines is getting closer and closer to that of physical machines with better software like Hyper-V.
Getting Close to Physical - Database Weekly (Nov 8, 2008)
The performance of virtual machines is getting closer and closer to that of physical machines with better software like Hyper-V.
Combine BottomCount() with Other MDX Functions to Add Sophistication
Discover, through a hands-on practice exercise, a more sophisticated business use for the MDX BottomCount() function, in combination with the Generate(), Descendants(), Ancestor() and other functions we have explored within our series. Join BI Architect Bill Pearson in this, the second part, of an extended examination of the MDX BottomCount() function.
Simple way to export SQL Server data to Text Files
With the combination of a few T-SQL commands this tip shows you a simple way to export data to text files.
Just Keep Going and Going and Going
The upgrade treadmill might hit you in ways that you didn't expect.
Using the Aggregate Transform - SQL School Video
MVP Brian Knight brings us some details on the Aggregate transformation in Integration Services.
Are Your SQL Server Application Queries Wasting Memory
I am running an application that issues queries directly to the database from within its source code. I've noticed that the database server will get low on available memory and that CPU activity is higher than I'd like. What could be the problem?
Data Vices
Steve Jones asks about what you might change about yourself at work for this Friday's poll.
Blogs
Enterprise AI Operating Rhythm – Top 5 practices for 2026
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Stop Being Surprised by Your Azure Bill: Use Budgets
By John
When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and...
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
Forums
The Max PK Length
Comments posted to this topic are about the item The Max PK Length
My experience using the GitHub Copilot in SSMS 22
Comments posted to this topic are about the item My experience using the GitHub...
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
Question of the Day
The Max PK Length
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers