PARTITION BY clause works incorrectly when in nested select over large volumes of data
I have been witnessing a very strange behaviour of ROW_NUMBER() PARTITION BY clause in complex join and nested select or...
2010-11-03
2,773 reads
My PASS Summit Schedule
Several bloggers have posted what their plans are for the PASS Summit and I’m following suit for 2 reasons:
So people...
2010-11-03
669 reads
SQLSaturday #59 – Speaker Interview #16 with DW Expert, Chuck Kelley
SQLSaturday #59 – Speaker Interview #16 with DW Expert, Chuck Kelley
Working on a large DW project, I had the pleasure of...
2010-11-03
820 reads
SQL Saturday 58 – It’s A Wrap! #sqlsat58
It’s Tuesday after PASSMN’s first SQL Saturday event in Minnesota. After a restful weekend, I’m finally starting to completely wind...
2010-11-03
457 reads
DB Maintenance
About a month ago I read a post by Brad McGehee (Blog | Twitter) concerning a checklist for SQL Server. It...
2010-11-02
581 reads
Tips For PASS Summit First Timers
In less than one week the 2010 PASS Summit begins in Seattle and with each day the excitement and anticipation...
2010-11-02
682 reads
TSQL2SDAY #12 - Why are DBA Skills Necessary?
WOW this is the 12th TSQL2Sday albeit this month’s is week early because of the PASS summit next week, so...
2010-11-02
631 reads
Voting Day is Here
Tis the season for voting and SQLServerPedia has thrown out an election as well. The SQLServerPedia awards are under way...
2010-11-02
429 reads
T-SQL Tuesday #012 – Skills
November is upon us and in some areas this also means that the leaves have changed color. With the change...
2010-11-02
636 reads
Why are DBA skills necessary? #TSQL2sDay
Time for another T-SQL Tuesday and this time I’ll finish my entry in time. This month we are talking about...
2010-11-02
783 reads
Blogs
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...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
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