Collation: Temporary objects and variables: Demonstration
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-21
469 reads
SQLStudies
Who is an expert?
Recently Paul Randal had a brief rant on twitter where he complained about the fact that there are no stupid...
2014-04-16
603 reads
Who is an expert?
Recently Paul Randal had a brief rant on twitter where he complained about the fact that there are no stupid...
2014-04-16
410 reads
Collation: Correction -> Instance
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-14
668 reads
Collation: Correction -> Instance
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-14
462 reads
Collation: Correction -> Expression, Column, Database
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-10
1,001 reads
Collation: Correction -> Expression, Column, Database
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-10
710 reads
T-SQL Tuesday #53: Why so serious
Why so serious? If you ask anyone who knows me they will tell you I’m not a terribly serious person....
2014-04-11 (first published: 2014-04-08)
1,624 reads
T-SQL Tuesday #53: Why so serious
Why so serious? If you ask anyone who knows me they will tell you I’m not a terribly serious person....
2014-04-08
394 reads
Microsoft announces that it will no longer support SQL Server and that SQL 2014 was an April Fools Joke!
Microsoft has announced that SQL 2014 was in fact an elaborate April Fool’s joke and that Microsoft intends to move...
2014-04-01
861 reads
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
BCA KCU GAJAH MADA No.Telpon 087781685647
Whatsapp 087781685647 Jl. Gajah Mada No.112 B-C-D, RT.1/RW.1, Krukut, Kec. Taman Sari, Kota Jakarta...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers