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
Integers
Synchronize Salesforce with SQL Server using SSIS
Easily synchronize live Salesforce data with SQL Server using the Salesforce SSIS DataFlow Tasks.
2014-09-30
5,297 reads
Auto Generating Multiple XML Files Using SSIS
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,136 reads
Unpack an Integer with SQL Server Recursion
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
Blogs
Speaking at DataMinds Connect 2020
I’m delighted to announce I’ll be speaking again at DataMinds Connect this year, one...
SQLSaturday Auckland: Certification Exams Inside Out this Weekend!
By Will Assaf
Looking forward to virtually presenting at SQLSaturday Auckland 2020 this weekend! I'll be presenting...
Data Cleanup for WordPress Tags without a Plugin
By Steve Jones
Over the years I’ve had this blog, I’ve added lots of tags. In 15...
Forums
Operating system error 1117 (I/O device error)
Hi, I have 3 Hyper-V servers in a cluster with a SQL2019 VM on...
how to add a second file share witness?
Morning all, Within failover cluster manager, how do add a 2nd file share...
SELECT Statement BLocking
Hi Experts, we have observed that the SELECT statements are causing from application which...
Ask SSC