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
643 reads
Hi all, Friends, most of the time we used ranking function like ROW_NUMBER() when it required to generate unique number...
2015-09-28
643 reads
HI friends, in some working scenario or during interviews we got the task to find the running totals of a...
2015-09-14
597 reads
Hi friends, I was working on a scenario in which I need to assign a unique values to a column....
2015-09-08
610 reads
Hi friends, in our day to day work we used SELECT…INTO clause to create replica of a table for different...
2015-08-03
651 reads
Hi friends, As you all know that SQL Server CTP2 has released with new great features. Here is the list of...
2015-07-26
665 reads
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
639 reads
In SQL Server 2014 a new feature In-Memory OLTP was introduced which was referred as ‘Hekaton’. This feature was introduced...
2015-07-23
727 reads
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,085 reads
Hi friends, today we will continue with Query Store in SQL Server 2016. In previous blog we learnt about what...
2015-07-17
1,097 reads
Hi friends, in next few blogs we will explore another new feature named Query Store which gets introduced in SQL...
2015-07-16
700 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers