In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them..
2018-10-08
3,419 reads
The article demonstrates one of the major performance enhancements in checkpoint processes in "in memory tables"
2018-10-05 (first published: 2015-10-27)
3,940 reads
The name of the Agent job isn't necessarily what it does, and just because your'e not getting failure emails doesn't mean the job is working.
2018-10-05
6,492 reads
Learn how to deploy Reporting Services into a container with Windocks.
2018-10-04
8,617 reads
In this tip we look at how to insert missing values for an identity column using the SET IDENTITY_INSERT command.
2018-10-04
2,900 reads
Azure Storage can store many types of data, from NoSQL tables to VHDs. In this article, Supriya Pande explains how to work with Azure Storage Explorer, a tool that makes it easy to manage storage in Azure. She also provides an example of using the Azure Storage .NET SDK to upload files.
2018-10-04
2,593 reads
In this tip look at the undocumented command DBCC WRITEPAGE to corrupt a SQL Server database and then use the command to undo the corruption.
2018-10-03
2,545 reads
Learn how you can determine which connection is using the Dedicated Administrator Connection.
2018-10-02
3,020 reads
Join Anoop Kumar as he discusses two modern design patterns to handle Advanced Analytics on big data, and Real time analytics.
2018-10-02
3,526 reads
Explore using Compress/Decompress with varying types of data and examine size/storage usage
2018-10-01
3,813 reads
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Comments posted to this topic are about the item Database security permissions save script
I have a SQL Agent job for backing up a set of Analysis Services...
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers