Going to San Diego (#SQLSat157)
It appears that I signed up to speak at the San Diego SQL Saturday coming up this weekend. I knew...
2012-09-11
700 reads
Find Skew in Distributed Tables
The SQL Server PDW (Parallel Data Warehouse) is a beast of a machine. Spreading workload across multiple nodes inside the...
2012-09-11
1,529 reads
Quick tip: Querying database metadata with DBCC DBINFO
Page 9 in file 1 (of the primary filegroup) in a SQL Server database is the header page and contains...
2012-09-11
2,146 reads
SQL Server : Usage of OVER Clause
Over clause can be used in association with aggregate function and ranking function. The over clause determine the partitioning and...
2012-09-17 (first published: 2012-09-10)
10,466 reads
Master Data Services: Changing a model with a subscription view
I have been working heavily with Microsoft Data Services (MDS) in SQL Server 2012 over the past few months, and...
2012-09-10
2,637 reads
Sleepless in Seattle – SQL in the City 2012
A few years ago I went to Seattle a few days before the PASS Summit started. I took my middle...
2012-09-14 (first published: 2012-09-10)
1,907 reads
No Full Outer Join in Access
Recently I needed to help a colleague with a small inventory true up task. We needed to know items that...
2012-09-10
802 reads
Have You Seen This Error?
location: AppendOnlyVerStoreMgr.cpp:776
Expression: 0
SPID: 64
Process ID: 4912
Description: Cannot locate version record and page is not allocated. Status = 3
Msg 3624, Level 20,...
2012-09-10
1,362 reads
Colorado SQL - September 2012
COLORADO SPRINGS SQL
September 19, 2012 at 5:30 p.m.
Meeting Location: Hyatt Place - Garden of the Gods, 503 West Garden of the Gods...
2012-09-10
877 reads
PASS ProfDev VC presentation recording available
Back on August 15th I did a webinar for the PASS Professional Development virtual chapter on my talk Being the...
2012-09-10
1,136 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
Alamat BCA KCP GAMA Telp:08218200233
Telp/Wa 62 8218200233 Gama Tower Lt. Dasar Unit B, Jl. H. R. Rasuna Said...
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...
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