Introduction to Common Table Expressions
Learn how to use common table expressions to simplify your code. Replace temp tables and correlated subqueries with this cool T-SQL feature.
2009-12-08
15,265 reads
Kathi Kellenberger
- Interests: Walking, running, grandchildren!
Back Home after PASS 2009
I got home Friday evening after spending several days in Seattle at PASS 2009. This was my seventh PASS Summit...
2009-11-08
440 reads
SQL Server 2008 cluster install and slipstreaming!
I was asked to set up a SQL Server 2008 cluster on Windows 2008 R2 this past week. One interesting...
2009-10-31
2,133 reads
Beginning T-SQL 2008
My book "Beginning T-SQL 2008" came out about two weeks ago. http://www.amazon.com/Beginning-T-SQL-2008-Kathi-Kellenberger/dp/1430224614/ref=sr_1_1?ie=UTF8&s=books&qid=1256604424&sr=8-1 It's a beginning book because I assume that the...
2009-10-26
799 reads
Thanks, Brian!
This past Tuesday, Brian Knight visited the St. Louis SQL Server User Group to present on SSIS. The day ended...
2009-06-14
564 reads
Submit your PASS abstracts now!
Hey, there are probably some other blogs here letting you know that the PASS call for speakers is open right...
2009-03-30
1,349 reads
Tagged again
Once again I was tagged to answer a question. This time by Chris Shaw http://chrisshaw.wordpress.com .
Here is the question: Do...
2009-03-05
578 reads
Chain Blog from Tom LaRock
I have been tagged by Tom LaRock to write about “what was your first computer and what were some of...
2009-02-19
435 reads
St. Louis Day of .Net
Yesterday I spoke on 2008 T-SQL and Data Types at the St. Louis Day of .Net event. This was an...
2008-12-14
425 reads
Grouping Sets
I have given a talk about new data types and T-SQL features to three local groups. I am presenting it...
2008-11-28
2,215 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