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
769 reads
Blog Posts
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
133 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
678 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,022 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
106 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
11 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
25 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
Advent of Code – Day 4
Day 4 of the Advent of Code has us mining for data in MD5 hashes, which is out of the comfort zone for a SQL DBA to say the...
2015-12-24
13 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Designing for Teams
Comments posted to this topic are about the item Designing for Teams
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers