When you build applications that store data in SQL Server you will most likely have to store dates and times, and you’ll call functions to do date manipulations. It is important to understand the different date and time data types, and when to use one data type over another. In this level I will be exploring the different date and time data types and discussing when each type is appropriate.
This article explores how raising the Cost Threshold for Parallelism (CTFP) affects missing index recommendations in SQL Server along with examples.
Learn a step-by-step method to save your ADF pipelines in Git and automatically release new changes to test and production.
Governments want backdoors built into encryption software, which Steve thinks is a bad idea.
Have you ever surfed the internet and felt overwhelmed by personalized advertisements that appear to know your every desire? Have you ever been amazed at how accurate some weather forecasts can be? These actions are based on data processing. EsProc SPL and SQL (note, SPL stands for Structured Processing Language and SQL stands for Structured Query Language). SQL is a major language widely encountered and used for data manipulation within relational databases. While EsProc SPL is another effective tool for data processing, especially suited for complex computations and in-memory operations, it is less commonly encountered.
Stored procedures can be poorly written, but Steve prefers them over embedded code.
Calculating elapsed time between time values can be an interesting problem that is easily solved even when data anomalies are present.
In this article, we walk through how to set up a simple Excel interface to work with SQL Server data to insert, update, delete, and select data.
Steve has a few thoughts on the tradeoff between getting work done quickly and producing well performing code.
By Brian Kelley
It's like disaster recovery (and business continuity) planning is the end-of-term research paper that...
The slides and scripts for my session “Tackling the Gaps & Islands Problem with...
Look, we all know data is king these days. But having mountains of data...
I have a scenario where log backup is getting failed in Secondary replica on...
Comments posted to this topic are about the item Everything is Code
Comments posted to this topic are about the item Statistics Histograms
I have a statistics objects with 2 key columns from my tables. How many histograms and their type are stored?
See possible answers