Window Functions in SQL Server
With SQL Server 2012, we are soon to enjoy a full range of Window Functions. They are going to make for some much simpler SQL queries, as Fabiano Amorim ably demonstrates here.
2011-11-14
4,521 reads
SQL Server 2012
New Spatial Features in SQL Server Code-Named 'Denali'
SQL Server 2008 introduced spatial data support into the database server. This paper describes and discusses the new spatial features in SQL Server Code-Named “Denali” CTP1 and CTP3 that augment existing SQL Server 2008 and SQL Server 2008 R2 spatial functionality.
2011-11-03
2,943 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
Tool to help you analyze SQLDIAG and PSSDIAG output
SQLDIAG or PSSDIAG are excellent tools used to collect and analyze data in order to identify possible performance root causes. The issue is that the output produced by such utilities is sometimes convoluted, hard to read and hard to understand. In this tip, I will show you a tool that you can use to read and analyze the data collected by these tools.
2009-12-17
2,873 reads
Blogs
Why Optimize CPU for RDS SQL Server is a game changer
One feature that I have been waiting for years! The new announcement around optimize...
Performance tuning KubeVirt for SQL Server
Following on from my last post about Getting Started With KubeVirt & SQL Server,...
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
Forums
Change Tracking – Troubleshooting
I have change tracking configured in several databases, in QA and production environments, and...
is there a no code way to limit an ssis extract from excel to the 1st 21 rows?
is there a no code way to limit an ssis extract from excel to...
Pivot but preserve all rows on Aggregate column
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers