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,430 reads
Blog Posts
Re-blog – April 29-May 5
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-05-06
567 reads
SQL University: Precedence Constraints
Welcome back, class! In our last class, we setup a parent-child package configuration and showed how you can pass variables...
2011-05-06
2,109 reads
SQLRally OverDrive Events!
So you’re going to SQLRally in Orlando next week? Want to take advantage of ALL of the awesome opportunities presented?...
2011-05-06
397 reads
The best IT job boards
There are three job boards that I use: Dice, Monster, and LinkedIn. I prefer Dice by far, since it has...
2011-05-06
1,277 reads
Why you should ask your CTO to attend the User group meetings.
When we (Bill Wunder and me) started our user group, the first person we invited to sign up to our...
2011-05-06
1,855 reads
A row has no row number
It seems that every month I have someone asking the question about ordering or row numbers for a query. Let’s...
2011-05-05
3,968 reads
Certifications – and a survey.
G’day,
There’s a lot of mixed opinions around about certifications.
Are they worth while, do they mean anything, do employers value them...
2011-05-05
721 reads
Correcting Image Distortion in PDF Reports
I’ve seen a few cases where reports exported or rendered to PDF have distorted charts and images. We’ve played with...
2011-05-05
1,689 reads
I Won't Be at SQL Rally
I am excited about the SQL Rally event that's coming up next week. However, I won't be there. I've been...
2011-05-05
863 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers