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
594 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,530 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
609 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
463 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
404 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
532 reads
2010-09-10
444 reads
In the last weblog post I have talked about the differences in unique and non-unique
non-clustered indexes on a unique clustered...
2010-09-07
4,095 reads
In the last weblog
post I have talked about the difference of unique and non-unique clustered indexes.
As you have seen SQL...
2010-08-31
9,789 reads
In the last blog post I have talked about unique/non-unique clustered indexes on a heap
table. A table without a clustered...
2010-08-19
8,191 reads
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
By Kevin3NF
Useful tips to make your jobs more stable Too many IT teams treat SQL...
After spending decades working in SQL Server, getting familiar with PostgreSQL felt like traveling...
We're currently on SQL 2019 and will likely be looking to migrate to a...
Hello, I have a SQL Server with an AlwaysOn configuration consisting of three replicas...
Anyone got any good advice for performance tuning CDC on a Managed Instance? We...
In a trigger, I can use UPDATE() or UPDATED_COLUMNS() to determine which columns were changed. For these functions, which one accepts a column name as a parameter?
See possible answers