Columnstore Indexes – part 75 (“Stretch DB & Columnstore”)
Continuation from the previous 74 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post focuses on one of...
2015-12-26
534 reads
Blog Posts
Learn How to Insert Data From Stored Procedure Into Table?
Stored Procedures are considered most efficient way for calling and retrieving data and hence users always look forward to encapsulate...
2015-12-26
764 reads
Bad queries!!!
Once it happend quite a black Friday for my environment after a deployment. The application got sucked so that becoming worst and...
2015-12-25
132 reads
Columnstore Indexes – part 74 (“Row Group Merging & Cleanup, SQL Server 2016 edition”)
Continuation from the previous 73 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Row Group merging & cleanup is a very...
2015-12-25
677 reads
Giving Thanks Around the Holidays
In the West, the holiday season summons different memories and plans for different people. The thought of gorging on a...
2015-12-25 (first published: 2015-12-15)
1,020 reads
How a Bad query can rise up your CPU to ceiling
Once it happened quite a black Friday for my environment after a deployment. The application got sucked so that becoming worst and worst. The average CPU raised over 80% (Figure 1)....
2015-12-25
9 reads
How a Bad query can rise up your CPU to ceiling
Once it happened quite a black Friday for my environment after a deployment. The application got sucked so that becoming worst and...
2015-12-25
104 reads
How a Bad query can rise up your CPU to ceiling
Once it happened quite a black Friday for my environment after a deployment. The application got sucked so that becoming worst and worst. The average CPU raised over 80% (Figure 1)....
2015-12-25
7 reads
Advent of Code – Day 3
Continuing with the language-independent code challenge on Advent of Code – Day 3, I’m tasked with figuring out how well a drunken elf can guide Santa to houses. Since...
2015-12-24
24 reads
Advent of Code – Day 3
Continuing with the language-independent code challenge on Advent of Code – Day 3, I’m tasked with figuring out how well a...
2015-12-24
513 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers