Running DBCC CHECKDB or DBCC CHECKTABLE on a database may report error 8961. Such a situation could occur while changing the data type of a table column from “ntext...
2021-07-19 (first published: 2021-07-08)
686 reads
We’ve opened up registration and the call for speakers for SQLSaturday Orlando, to be held October 30th at the Orlando Marriott Lake Mary. In-person! We weren’t able to get...
2021-07-19
2 reads
2021-07-18
13 reads
[read this post on Mr. Fox SQL blog] Every now and then you come across a use-case where you need to do something with spatial data, and you need...
2021-07-18
31 reads
[read this post on Mr. Fox SQL blog] Every now and then you come across a use-case where you need to do something with spatial data, and you need...
2021-07-18
7 reads
I want to start by saying thank you to all who submitted, and an amazing collection of people submitted some fantastic content. Also, thanks to Steve for asking me...
2021-07-17
1 reads
This is a quick non-technical discussion (i.e. not a how to in any way) of some of the benefits of ... Continue reading
2021-07-16 (first published: 2021-06-29)
672 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-07-16
8 reads
Come to find out, nope, probably not. My good friend Jim Donahoe (blog|twitter)was very nice to tell me that he’s running 100TB of storage in his house across multiple Synology...
2021-07-16
Come to find out, nope, probably not. My good friend Jim Donahoe (blog|twitter)was very nice to tell me that he’s running 100TB of storage in his house across multiple Synology...
2021-07-16
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...
Hi all We've got 3 servers with the same setup for dbmail. They...
Hi, I have a set of data (for instance sine wave) and I need...
Hey everyone, SQL Server has two mechanisms for deploying and moving a database to...
What do I get as the results from this code?
SELECT CEILING (999.999), CEILING (-999.999);See possible answers