New upcoming events across Europe
I'm very happy today to announce 4 new upcoming SQL Server workshops across Europe
within the next months:
SQL Server Configuration...
2012-03-04
917 reads
Klaus Aschenbrenner
Statistics Enhancements in SQL Server 2012
Today I want to talk about Statistics Enhancements in SQL Server 2012. As you already
know SQL Server uses Statistic Objects...
2012-02-29
4,368 reads
My upcoming speaking engagements
In the last weeks it was very silent on my weblog, but life is pretty fast in 2012.
Currently I'm preparing...
2012-02-08
570 reads
The Blocked Process Report
A few days ago, one of my customers asked if there is a possibility to get a notification
from SQL Server...
2011-12-01
5,578 reads
Running a TPC-C workload on SQL Server
I have a lot of customers with some impressive SQL Server workloads, those databases
are several hundred GB large, with several...
2011-11-23
7,931 reads
My new event series across Europe: SQL Server 2012 Deep Dive Days
I'm very proud to announce today that I'm running next year
a new event series across Europe: the SQL Server 2012...
2011-11-17
831 reads
Why SQL Server is using so LESS memory
Today I want to talk about a phenomenon regarding memory management in SQL Server.
A few weeks ago I had a...
2011-11-04
7,198 reads
Correction of my unfair and incorrect words against SQLWorkshops.com
On October 18, 2011 I have made unfair and incorrect words on Twitter, Facebook, LinkedIn,
and Xing against the owners of...
2011-11-02
769 reads
Troubleshooting THREADPOOL Waits
Today I want to talk about a specified wait type that can be sometimes very hard to
troubleshoot: the THREADPOOL wait...
2011-10-25
12,574 reads
Query Memory Spills
When you sometimes look at Execution Plans, you can see that the SELECT operator has
sometimes a so-called Memory Grant assigned....
2011-10-19
5,128 reads
Blogs
Performance tuning KubeVirt for SQL Server
Following on from my last post about Getting Started With KubeVirt & SQL Server,...
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
Keeping MS Docs Up to Date
By Steve Jones
One of the things that I like about the SQL Server docs (MS Learn...
Forums
Change Tracking – Troubleshooting
I have change tracking configured in several databases, in QA and production environments, and...
is there a no code way to limit an ssis extract from excel to the 1st 21 rows?
is there a no code way to limit an ssis extract from excel to...
Pivot but preserve all rows on Aggregate column
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers