ROW_NUMBER SQL Server
Row_Number SQL Server
SQL Server includes several Ranking Functions that can be called in T-SQL. One of these is the Row_Number()...
2014-12-22 (first published: 2014-12-16)
8,855 reads
SQL Server Developer Tips that Can Save Your XXX
Last week I had the honor to present a seminar at Expert Days 2014, which is an annual conference for...
2014-12-16
813 reads
RegEx Those Dates
Recently I was working on transforming some dates, and wanted to generate a large n number of dates for testing....
2014-12-15
1,306 reads
Transaction Isolation Level Blues
Have you ever had a mental block in one particular area when learning something? It might be the simplest thing,...
2014-12-25 (first published: 2014-12-15)
5,500 reads
Last Weeks Top “Reading” Links #113
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-12-15
491 reads
Why You Should Benchmark Your Storage
You should benchmark your storage immediately. If you are a database administrator, you should benchmark it yesterday. And today. And...
2014-12-15
1,278 reads
Create a clustered index and a primary key on existing tables
It’s the simple things in life that can trip people up. I find that creating primary keys and clustered indexes...
2014-12-15
653 reads
The Value of Writing Good
Most of my peers, and likely yours as well, work in some sort of technical field. Odds are that they’re...
2014-12-15
548 reads
Does a clustered index sort the rows within a page
This is just something I was curious about. I ran my tests and got an answer and now I thought...
2014-12-15
1,368 reads
SSAS #39–Building Optimal and Well-Tuned Dimensions
The Analysis Services Performance Guide from bunch of Microsoft Analysis Services experts have been updated since 2005 edition for 2008 R2...
2014-12-14
1,499 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
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
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...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers