MAXDOP and Cost Threshold for Parallelism – an example for a parallel query
The most popular post on this blog ranked by hits is one about the CXACKET wait stat. There are no...
2012-06-18
2,394 reads
The most popular post on this blog ranked by hits is one about the CXACKET wait stat. There are no...
2012-06-18
2,394 reads
Tuesday’s (June 19th, 2012) PASS Data Architecture Virtual Chapter has Neil talks about database design that uses Constraints for Integrity...
2012-06-14
690 reads
I have 2 upcoming speaker opportunities in June and am very excited about presenting this material.
June 9th is in...
2012-05-26
754 reads
Baton Rouge’s annual tech event for the IT community is coming up August 4th on the beautiful campus of LSU....
2012-05-17
657 reads
Thursday’s (May 17th, 2012) PASS Data Architecture Virtual Chapter has Mike demonstrating some cool Table Partitioning scripts which I was...
2012-05-14
541 reads
I enjoyed a long weekend in Houston starting with Kalen Delaney’s Pre-con on Query Tuning. I have learned over the...
2012-04-27
1,633 reads
Thursday’s (May 17th, 2012) PASS Data Architecture Virtual Chapter has Mike demonstrating some cool Table Partitioning scripts which I was...
2012-04-18
550 reads
Wow, blessed to speaker at another SQL Saturday in Houston #107. The first task of this weekend is Friday. Kalen...
2012-04-09
718 reads
An important operator to understand in execution plans is a scan. A Scan can be good and bad, so understanding...
2012-04-02
4,294 reads
The Merge Join is a Physical Operation when joining 2 sets of data that are in the same order.
There...
2012-03-15
5,891 reads
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Comments posted to this topic are about the item 50 Years of Microsoft
Comments posted to this topic are about the item Multiple Collations
Comments posted to this topic are about the item Retrieving Data Using the REST...
Can I have a collation expression like this in SQL Server 2022?
... WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS ...See possible answers