T-SQL Random Numbers using RAND() for Test Data
T-SQL Random Numbers using RAND()
SQL Server includes the T-SQL RAND() function to create a random value between 0 and 1...
2015-01-12
1,393 reads
2014 Year In Review
As is our want, we must look back over the past year to see what happened. While I normally focus...
2015-01-11
633 reads
A Whole New Mind by Daniel Pink
I have dedicated much more time to reading in the past 6 weeks (Since the beginning of December 2014), and...
2015-01-11
492 reads
In-Memory OLTP Part 2 : Memory-Optimized tables
In part 1 of the In-memory OLTP articles we gave you an introduction into In-memory OLTP, showing what the requirements...
2015-01-11
4,216 reads
SQL Saturday NYC Update #3
SQL Saturday NYC Planning is in going well and we are now getting ready to finalize our precons as 2...
2015-01-09
473 reads
Learning SQL #1–Start from buying a Copy of SQL Server Developer Edition
If learning SQL is in your New Year Resolution, then you will be happy to read this post.
We all make...
2015-01-09
1,058 reads
SQL – Split delimited columns using XML Or UDF function
The requirement is to convert the delimited column into rows
Input data and required output details are given below
EnoEnameEslocEDept1ABCNJ10,20,30,40,50Output:-
EnoEnameEslocEDept1ABCNJ101ABCNJ201ABCNJ301ABCNJ401ABCNJ50Download the Script Split...
2015-01-09
1,357 reads
The mysterious permission issue
As you might have realized, this is not the title of an Agatha Christie book, but rather about some nasty...
2015-01-09
783 reads
I Am Grateful For
A while back I wrote about saying “Thank you” to people. Last night I was listening to NPR on my...
2015-01-09
696 reads
On Failure
The first rule of blogging is that you should write about topics you know a lot about. And I know...
2015-01-09
706 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers