Find SQL Server Integer Columns to Make Skinnier
In this tip we look at a SQL Server script you can use to determine if you can convert your big integer columns to smaller integer data types to save storage space.
2019-08-14
In this tip we look at a SQL Server script you can use to determine if you can convert your big integer columns to smaller integer data types to save storage space.
2019-08-14
Easily synchronize live Salesforce data with SQL Server using the Salesforce SSIS DataFlow Tasks.
2014-09-30
5,055 reads
An SSIS package that can generate an XML file for each record in an XML column in a SQL Server Database using the Source Script Component in a Data Flow Task.
2014-08-25
3,884 reads
Starting with SQL Server 2005, developers have had recursion available as a T-SQL language feature. This article describes recursion and its SQL Server implementations, complete with examples. It also includes SQL Server functions and a stored procedure that unpacks, or parses, an integer into its multiple-of-two components.
2013-04-26
3,186 reads
Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe...
By Steve Jones
This is for me, not necessarily for you, but I decided to go with...
By Gerard
This is the fourth and final post in a series about modern Data Lake...
I am trying to pass a parameter into the @query argument of sp_send_dbmail for...
Hello all, I have to create an SSRS Report that will print as a...