Please vote for my SQLPASS precon and sessions
A few days ago, SQLPASS opened the voting for the precon’s and sessions for the annual
SQLPASS community summit. I’ve also...
2011-05-12
615 reads
Klaus Aschenbrenner
RCSI/SI doesn't work with rows larger than 8046 bytes
During this week I have prepared a workshop about Locking & Blocking for one of
my customers. One big part of this...
2011-05-06
1,420 reads
Slides & Samples for my SQLbits session
As announced in both of my sessions, you can download the slides & samples for
my SQLbits sessions here:
Message
in a Bottle: Service...
2011-04-11
744 reads
Einladung zum SQL Server Performance Tuning und Troubleshooting Workshop, 24. Mai 2011 in Wien
Sind Sie schon mal in das folgende Problem-Szenario gelaufen, und mussten Ihren wohlverdienten
Feierabend und die Vorfreude auf das Wochenende opfern:...
2011-03-20
804 reads
VSone session material
As I have announced in both of my sessions at the VSone conference in Munich, you
can find the session material...
2011-02-17
553 reads
DWH Workshop material
As announced in my DWH workshop in Munich, you can find here my
whole ETL solution. Thanks for attending my workshop...
2011-02-15
785 reads
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,342 reads
2 of my favorite new T-SQL features in SQL Server Denali (SQL 11)
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,443 reads
Announcing the SQLDoctor
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
561 reads
Slides & Samples for my SQLPASS sessions
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
656 reads
Blogs
The PASS Summit on Tour in the Netherlands
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
Azure SQL Managed Instance: Boost Performance with Read-Scale Out
By Arun Sirpal
The Business Critical tier of Azure SQL Managed Instance offers the read-scale out feature...
Free Cloud Environment Setup: A Beginner’s Guide
By Rohit Garg
Cloud computing is essential for modern development, data storage, and scalable applications. Setting up...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Sometimes, Troubleshooting Is Hard
Comments posted to this topic are about the item Sometimes, Troubleshooting Is Hard
Dimensional Modeling Case Study, Part 4 – Dynamic Time Duration Dimension
Comments posted to this topic are about the item Dimensional Modeling Case Study, Part...
Question of the Day
The Updated Columns List
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers