TechEd: 80 minute video of Corruption Survival Techniques presentation
A great presentation from Paul Randal of SQL Skills from TechEd 2008. Definitely worth the time to watch.
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?
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I