Day 6 – Lost in Space
This is the sixth installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...
2013-12-30
1,207 reads
Last Weeks Top “Reading” Links #64
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2013-12-30
1,183 reads
Kissing 2013 Goodbye
The end of the year is here, which means it’s time to look back and review my goals and reflect...
2013-12-30
1,221 reads
SSRS Interactive Sorting a Matrix
Sorting a matrix report can be done interactively. To perform interactive sorting, your report you will need a cell to...
2013-12-30
1,864 reads
Memory Timeouts
Recently I was asked to investigate a timeout issue that was causing SSIS package executions to fail.
The timeouts seemed to...
2013-12-30
1,319 reads
A New Year is Right Around the Corner
If you read my 2013 Year In Review you may be here today wondering why I haven’t posted anything despite...
2013-12-30
1,572 reads
Final December Giveaway!
Today I'm giving away the book Professional SQL Server 2012 Internals and Troubleshooting. If you live outside the continental US,...
2013-12-30
509 reads
Day 5 – Peer Identity
This is the fifth installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...
2013-12-29
7 reads
Day 5 – Peer Identity
This is the fifth installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...
2013-12-29
718 reads
Deleting Duplicate rows using CTE
Many times we caught in a situation where we have a table where there is no primary or unique column...
2013-12-29
59,411 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers