SQL Server – Columnstore Index creation error: A columnstore index cannot be created on a SPARSE column
Hi friends, as we know that in SQL Server 2012 a new feature Columnstore index was introduced which made a...
2015-10-23
630 reads
Hi friends, as we know that in SQL Server 2012 a new feature Columnstore index was introduced which made a...
2015-10-23
630 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
646 reads
HI friends, in some working scenario or during interviews we got the task to find the running totals of a...
2015-09-14
598 reads
Hi friends, I was working on a scenario in which I need to assign a unique values to a column....
2015-09-08
613 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
655 reads
2015-07-30
1,277 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
667 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
642 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
730 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,089 reads
By Steve Jones
I saw a post internally that asked this question: Anyone have a handy powershell...
By Rob Sewell
The partner directory connects your agency with new customers.
I had an excellent group of people in Gothenburg Sweden when I taught there...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Hello all, Is there an easy way to output my records to a flat...
Comments posted to this topic are about the item Refactoring Databases: Evolutionary Database Design
What is the result of this code?
SELECT CONCAT(1, 2, 3) + 4See possible answers