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,788 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
4,718 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
By kleegeek
You’re invited! I’m thrilled to be co-presenting a session on the top five SQL...
By Steve Jones
We added a solar system to the ranch as a way to hedge against...
TLDR; The code to do this is below but it’s a bit hokey and...
Hi, Can you advise how to remove Duplicated rows in sysobjvalues. or remove the...
Hi I'm currently doing a networks management degree level 7. I'm in the final...
Hello, I need to help my boss come up with a simple-ish SQL quiz....