SQL Server – Various methods to generate unique number sequence
Hi all, Friends, most of the time we used ranking function like ROW_NUMBER() when it required to generate unique number...
2015-09-28
654 reads
Kapil Blogs
SQL Server – Methods to find running totals of a column
HI friends, in some working scenario or during interviews we got the task to find the running totals of a...
2015-09-14
607 reads
SQL Server – Using Window ranking function with UPDATE statement
Hi friends, I was working on a scenario in which I need to assign a unique values to a column....
2015-09-08
621 reads
SQL Server – Sparse Column Property using SELECT INTO
Hi friends, in our day to day work we used SELECT…INTO clause to create replica of a table for different...
2015-08-03
667 reads
SQL Server 2016 Blogs
Hi friends, As you all know that SQL Server CTP2 has released with new great features. Here is the list of...
2015-07-26
678 reads
Change in sys.dm_exec_query_stats in SQL Server 2016
Sys.dm_exec_query_stats is most commonly used DMO used by DBA and developers to find out the information about queries involving query...
2015-07-25
646 reads
Changes in In-Memory OLTP in SQL Server 2016
In SQL Server 2014 a new feature In-Memory OLTP was introduced which was referred as ‘Hekaton’. This feature was introduced...
2015-07-23
735 reads
Introduction To Temporal Tables In SQL Server 2016
Hi friends, today I will get you introduced with another new feature of SQL Server 2016 i.e. Temporal Tables. SQL...
2015-07-23 (first published: 2015-07-20)
3,096 reads
Introduction To Query Store In SQL Server 2016 – Part 2
Hi friends, today we will continue with Query Store in SQL Server 2016. In previous blog we learnt about what...
2015-07-17
1,107 reads
Introduction To Query Store In SQL Server 2016 – Part 1
Hi friends, in next few blogs we will explore another new feature named Query Store which gets introduced in SQL...
2015-07-16
710 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers