Two Digit Dates in SQL – MM/DD/YYYY
When creating dates or numbers as strings it is sometimes required to have two digit numbers.
For example, instead of...
2014-03-10
367 reads
Mike Davis SQL
SSRS Top N and Bottom N reporting with Duplicates
Previously I wrote a blog on Top N and Bottom N reporting. There were a couple of gotcha I did...
2014-03-13 (first published: 2014-03-03)
2,958 reads
SSRS Top N and Bottom N reporting with Duplicates
Previously I wrote a blog on Top N and Bottom N reporting. There were a couple of gotcha I did...
2014-03-03
1,131 reads
Standard Deviations with CTE in SQL
I was working with a client recently getting the number of standard deviations a student was off the average number...
2014-02-27 (first published: 2014-02-24)
3,317 reads
Standard Deviations with CTE in SQL
I was working with a client recently getting the number of standard deviations a student was off the average number...
2014-02-24
346 reads
SSRS – Creating Drill Through reports with MDX
If you are reporting from a Cube in SSRS and you want to drill through to another report you can...
2014-02-10
1,216 reads
SSRS – Creating Drill Through reports with MDX
If you are reporting from a Cube in SSRS and you want to drill through to another report you can...
2014-02-10
347 reads
SSIS – Using Kill with SP_Who to Break locks
The dreaded table lock can occur and cause your SSIS packages to fail. A popular request I receive asks “How...
2014-02-03
1,674 reads
SSIS – Using Kill with SP_Who to Break locks
The dreaded table lock can occur and cause your SSIS packages to fail. A popular request I receive asks “How...
2014-02-03
402 reads
SSAS Trending KPI
KPI’s (Key Performance Indicators) in Analysis Services are a great way to show visually if a measure is trending in...
2014-01-27
794 reads
Blogs
The Third Sabbatical
By Steve Jones
I can’t believe I’ve been at Redgate long enough to get a third sabbatical....
Advice I Like: Focus on what’s important
By Steve Jones
Don’t let someone else’s urgency becomes your emergency. In fact, don’t be governed by...
Is Air Travel Still Safe? | Ahmedabad Plane Crash 2025 Explained | Aviation Safety & AI Solutions
By Rohit Garg
Is Air Travel Safe? Yes, air travel remains statistically the safest mode of transportation. In...
Forums
Can You Ask for a Raise?
Comments posted to this topic are about the item Can You Ask for a...
Stored Procedure Generation Script
Comments posted to this topic are about the item Stored Procedure Generation Script
OpenQuery with Application Intent specified runs on primary node.
I have an Open query that runs on an Always On server via a...
Question of the Day
Generating a Series I
What is returned by this code in SQL Server 2022?
SELECT value FROM GENERATE_SERIES(4, 1);See possible answers