Ways to minimize sort operations
In this article Brian Ellul explorea how it's possible to eliminate the SORT operator (and its performance cost) on performing SELECTS statements.
2010-09-15
12,000 reads
Articles
Issuing Current Time Increments in StreamInsight (A Practical Example)
The issuing of a Current Time Increment, Cti, in StreamInsight is very definitely one of the most important concepts to learn if you want your Streams to be responsive. A full discussion of how to issue Ctis is beyond the scope of this article but a very good explanation in addition to Books Online can be found in these three articles by a member of the StreamInsight team at Microsoft, Ciprian Gerea.
2010-09-15
1,779 reads
SQL Saturday #49 - Orlando
A free, one day training event taking place on October 16, 2010 in Orlando, FL.
2010-09-15
1,426 reads
Inside the Optimizer: Constructing a Plan - Part 3
Join Paul White in part three of a four-part series exploring the internals of query optimization as he looks at the rules that are used to build the execution plan.
2010-09-14
6,452 reads
SQL Saturday #55 - San Diego
The first SQL Saturday in San Diego kicks off fall with a full day of free SQL Server information, lectures, and seminars from the experts on the West Coast.
2010-09-14 (first published: 2010-09-07)
1,663 reads
SQL Social - Kent, UK
Andrew Calvett talks Analysis Services for the September meeting of the Kent SQL Server user's group.
2010-09-14
1,427 reads
Synchronizing SQL Server and SQL Azure
SQL Azure Data Sync provides data synchronization between the cloud and local SQL Server databases. Learn how SQL Azure Data Sync allows you to keep the most concurrent information in the cloud while allowing mobile users, businesses, and enterprise data sources all to have access to this data.
2010-09-14
1,240 reads
Mid September Free Training from PASS
There's going to be over 30 hours of free online SQL Server training in the upcoming week and you're not going to want to miss out!
2010-09-13
1,802 reads
Top 10 SQL Server Integration Services Best Practices
Learn the top 10 best practices for large scale SSIS packages from a real world DBA.
2010-09-13
13,625 reads
Performance Issue with large number of Virtual Log Files in SQL Server Transaction Log
SQL Server transaction log files have an internal structure called the Virtual Log File or VLF. When the number of VLFs grow out of control due to autogrowth the log can become fragmented and cause delay. In this tip we look at how to see how many VLFs exist as well as how this can be reduced to a more reasonable number.
2010-09-13
3,345 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
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