The goal of this post is to understand the procedure cache and execution plans to ensure we use fewer resources and that queries run better. Better means higher throughput, more concurrency and fewer resources – as described by MVP Joe Webb during SQLTeach in Vancouver just last month.
If you have never used an instead of trigger, it's a great mechanism for evading table triggers in certain situations. MVP Andy Warren brings you part one of this SQL School video.
Tony Davis explains his theory on why developers and DBAs listen to very different types of music, while working, and offers his list of "classic tracks" for all DBAs.
The sharper your SQL skills become, the more robust and error-free your solutions will be. Here are a dozen practical tips to get you started
You can easily limit or group a recordset, but doing both to the same recordset takes a bit of hand coding. Find out how both SQL Server and MS Access can handle the task.
Using a Deployment Manifest in SSIS allows you to deploy a set of packages to a target location using a wizard for installing your packages. The benefit to using it is the nice user interface that a wizard provides. The disadvantage of using it is it’s lack of flexibility. When using the Deployment Manifest keep in mind...
After a week of vacation, Steve Jones feels recharged and ready to head back to work. Today we celebrate the holiday with a blooper reel.
Tweaking SQL Server memory settings to provide support for managed code.
It's a holiday weekend, but for some DBA's it's hard to escape the unwanted clutches of IT...
In SQL Server 2005 and higher versions there are different ways in which one can execute an SSIS package. Let us go through each option one by one.
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...
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
Comments posted to this topic are about the item The Large Encoded Value
Comments posted to this topic are about the item The Side Job
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