A quick note comparing ISNULL vs COALESCE
There are hundreds of blogs that compare the T-SQL ISNULL function with the ANSI standard COALESCE function. There are also...
2016-10-13
1,238 reads
There are hundreds of blogs that compare the T-SQL ISNULL function with the ANSI standard COALESCE function. There are also...
2016-10-13
1,238 reads
Today is the last day to register to vote in Texas. I’m not sure about other states in the US...
2016-10-11
423 reads
If you have just begun using SQL Server 2016 or you have been using it for a while now you...
2016-10-05
3,055 reads
Has SSMS (SQL Server Management Studio) been crashing on you? Have you been getting Out of Memory messages when attempting...
2016-10-04
7,160 reads
It’s always been my dream to speak at SQL PASS Summit. It’s a tough egg to crack. In my experience...
2016-09-29
773 reads
If you’re a long time IT professional or an occasional user of high or even low tech software you’ll know...
2016-09-28
525 reads
Up until SQL Server 2016, we had to write our own functions to split a CSV string into a table...
2016-09-15 (first published: 2016-09-08)
2,690 reads
I’m excited to be monitoring Kalen’s session on concurrency. The session is today and is titled “Locking, Blocking, Versions: Concurrency...
2016-09-07
345 reads
If I had a dollar for every CTE solution to a simple query in the forums (pick any SQL forum), I’d...
2016-08-27
768 reads
This will be my second time speaking at SQL Saturday in Dallas. My first was last year and it was...
2016-08-25
430 reads
By Ed Elliott
All Spark Connect Posts Introduction There have been quite a few changes in the last...
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
This is a quick blog post, mainly so I have the code available if...
Comments posted to this topic are about the item How Do You Patch 100...
Comments posted to this topic are about the item Microsoft SQL announcements at PASS...
Comments posted to this topic are about the item How to Develop Custom T-SQL...
What do I get as the results from this code?
SELECT CEILING (999.999), CEILING (-999.999);See possible answers