How SQL Server stores indexes on variable length columns
In the last months I had done a lot of performance tuning workshops, and there is
almost the same question: How...
2011-01-10
2,370 reads
In the last months I had done a lot of performance tuning workshops, and there is
almost the same question: How...
2011-01-10
2,370 reads
Microsoft released the first CTP version of SQL Server Denali during the SQLPASS Community
Summit in Seattle last year. Since this...
2010-12-10
1,445 reads
Today I’m very proud to announce a FREE SQL Server consulting service from me called
the “SQLDoctor”.
The concept of the SQLDoctor...
2010-11-17
566 reads
As announced in both of my session you can find my slides & samples here for download:
Building FILESTREAM
solutions with SQL Server...
2010-11-15
660 reads
On January 4, I’m speaking about index internals for the Performance Virtual Chapter
of PASS (http://performance.sqlpass.org).
Here’s my session abstract:
SQL Server provides...
2010-11-02
598 reads
Beginning with tomorrow I’m no longer working for HP Austria, because I’m starting
my own SQL Server Consulting business. I’ve been...
2010-10-31
1,535 reads
I’m one of the 3 lucky guys whose submitted precon workshop for the developer category
for PASS SQLRally is in the...
2010-10-25
615 reads
As announced in my workshop and in my sessions at the SQLdays 2010 last week in Rosenheim/Germany,
you can download my...
2010-10-25
469 reads
As announced in my SQLBits workshop & session last week in York/UK, you can find the
session/workshop material here.
Have fun!
-Klaus
2010-10-04
406 reads
As announced in my StreamInsight session at 24HOP you can download the session material
from here.
Within the next weeks I will...
2010-09-17
536 reads
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers