Un-concatenating row values
/* Anith Sen's achievement, in his article 'Concatenating Row Values in Transact-SQL' has been to list and illustrate the many ways...
2008-10-06
1,743 reads
Blog Posts
Shkurtesa ne SQL Server 2008
Pershendetje juve qe punoni vazhdimisht me SQL Server 2008!
Une sapo e instalove SQL Server 2008 RTM versionin e fundit edhe...
2008-10-05
524 reads
SQL Server 2008 shortcut
Hi there, I just installed the SQL Server 2008 RTM and I try to open with shortcut CTRL+R writing sqlwb...
2008-10-05
468 reads
Thoughts on IndyTechFest 2008
I'm writing this as I wait on a flight back to Orlando after spending yesterday with John Magnabosco and team...
2008-10-05
162 reads
What I'm Reading (5 Oct 2008)
Technical:Counter Hack Reloadedby Ed Skoudis with Tom Liston
It's a security book and I'm rather late getting a review of it...
2008-10-05
721 reads
An Inconvenient Stay
I'm in Indianapolis for the Indy Tech Fest, having been talked into speaking by John M. He started emailing me...
2008-10-03
409 reads
Blog Changes on SQLServerCentral.com & Visiting The IndyTechFest
Perhaps you've noticed a few of the blog changes if you visit via the web rather than RSS. One good...
2008-10-03
360 reads
Speed or Value - Why Did I Write This?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-10-03
354 reads
Thanks to Andy Leonard
Midlands PASS was privileged to host SQL Server MVP Andy Leonard (Blog #1, Blog #2, his VSTS site, Twitter) tonight...
2008-10-03
719 reads
Through the Looking Glass: Elegant -or Not?
SQL Server as an EAV Database -Good Idea?
It seems like I am getting more and more inquires from potential clients...
2008-10-03
369 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Parameter Sensitive Plan Optimization in SQL Server 2022
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Minimum Change Tracking Retention
Comments posted to this topic are about the item Minimum Change Tracking Retention
AI Steals Joy
Comments posted to this topic are about the item AI Steals Joy
Question of the Day
Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers