The OVER Clause enhancements in SQL Server code named “Denali”, CTP3
A look at how the OVER clause is changing in SQL 11, based on the CTP 3 released to the public.
2011-08-25
9,412 reads
Articles
XML Configuration files in SQL Server Integration Services
Package configuration files are a great way of providing the values of SSIS package properties so that packages can be used in a far more versatile way. They make the deployment of SSIS packages easier and can provide parameters that are based on the server configuration, or which change for each runtime. They're easy to understand, especially when explained by Rob Sheldon.
2011-08-25
2,997 reads
Help Make SQL Server “Denali” The Best Release Yet!
A blog from Dan Jones of Microsoft asks you to test the next release of SQL Server, in CTP3 now, and send your feedback to Microsoft to ensure that the product is well tested.
2011-08-24
2,006 reads
Understanding the SQL Server NOLOCK hint
It seems that in some SQL Server shops the use of the NOLOCK (aka READUNCOMMITED) hint is used throughout the application. In this tip we take a closer look at how this works and what the issues maybe when using NOLOCK.
2011-08-24
6,556 reads
A faster DBCC CHECKDB?
This article describes a utility that is able to report the most common DBCC CHECKDB errors significantly faster than DBCC CHECKDB does itself.
2011-08-23
15,352 reads
2011-08-23 (first published: 2009-08-19)
11,013 reads
Script to Get Available and Free Disk Space for SQL Server
Often we face the situation where we need to check the total disk space and available disk space for both physical and LUN/Mount drives. See how this can be done using PowerShell.
2011-08-23
5,383 reads
How to Name Sheets in Exported Excel Workbooks with SSRS 2008 R2
A new feature of SSRS 2008 R2 is the ability to name sheets in exported Excel workbooks. This article explains how to utilize this feature.
2011-08-22
8,352 reads
2011-08-22
1,894 reads
SQL Saturday #93 - Toronto
Come get a free day of SQL Server training in Toronto on Sept 17, 2011 at SQL Saturday #93. The event takes place at Humber College in Toronto.
2011-08-22
1,346 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers