2019-12-17
573 reads
SET Options
2019-12-02
596 reads
How to Decipher @@Options
This article will show how you can read the @@OPTIONS variable and determine your settings.
2019-11-14
3,815 reads
2018-09-20
807 reads
2018-08-13
683 reads
2018-02-19
922 reads
2017-08-11
890 reads
What is the impact of setting SET ANSI_WARNINGS OFF?
Setting ANSI_WARNINGS OFF to avoid NULL value elimination warnings can have an impact on the data quality and system behaviour.
2018-09-11 (first published: 2016-08-23)
10,089 reads
2012-12-14
1,924 reads
2012-02-01
2,129 reads
Blogs
Creating a New Sequence–#SQLNewBlogger
By Steve Jones
I wrote about sequences in an editorial recently and decided to start using them....
An All Star Lineup for EightKB
By Steve Jones
An online conference is coming on June 17, 2020 that is full of high...
How should I store currency values in SQL Server?
On Twitter, Michael Dyrynda writes: ?? Never ever ever ever ever ever ever ever...
Forums
Filestream or Filetable or None...what to be used?
I've been assigned with a project that includes converting the columns in the existing...
How to force MS SQL to select a partition instead of making a full table scan
Hi all, I am currently designing a datamart layer in MS SQL 2016 Enterprise....
Daily 3 Coping
Today’s tip is find three good reasons to be hopeful for the future. http://voiceofthedba.com/2020/06/03/daily-coping-3-jun-2020/
Ask SSC