Columnstore Indexes – part 97 (“Working with Strings”)
Continuation from the previous 96 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
After many years of using & fighting the...
2017-02-01
661 reads
Blog Posts
Improve performance by replacing temp tables with memory optimized tables - Part 1
There are many cases where you will be using temp tables, and many of us are trying to seek for...
2017-02-01
6,942 reads
My backup and SLEEP_BPOOL_FLUSH
I noticed that my backup was taking longer than usual. I went to Perfmon to look at some counters, more...
2017-02-01
827 reads
Running SSMS 2016 in Read Uncommitted Mode
Back in July when we received the first official release of SSMS not tied to an engine release we got...
2017-02-01 (first published: 2017-01-25)
2,047 reads
SCOPE_IDENTITY() or @@IDENTITY
I've seen a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from...
2017-02-01 (first published: 2017-01-27)
3,235 reads
Speaking at SQL Konferenz 2017
I’m heading back across the Atlantic this February for SQL Konferenz. This is an intimate SQL Server event in Darmstadt...
2017-02-01
567 reads
SQL and the other technologies
I was curious about how the SQL language stands with the other technologies. Next table shows it. The data is taken from StackOverflow. Charted data looks like in...
2017-02-01
15 reads
SQL and the other technologies
I was curious about how the SQL language stands with the other technologies. Next table shows it. The data is taken from StackOverflow. Charted data looks like in...
2017-02-01
18 reads
Write-Host || Cannot invoke this function because the current host does not implement it
Issue: While running powershell in SQL job step, I am getting below error: –
A job step received an error at...
2017-02-01
1,507 reads
A Letter To A Younger Yates
Hello much younger Yates. Hope you’ve been doing well. Why don’t you pull up a chair and stay for a...
2017-01-31
692 reads
Blogs
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,...
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers