Microsoft Releases SQL Server 2008 SP1 Cumulative Update 9
Microsoft has released SQL Server 2008 SP1 Cumulative Update 9 (CU9). The KB Article for the CU is located here....
2010-07-21
888 reads
Glenn Berry
Pitching in for a Good Cause!
Fellow SQL Server MVP Arnie Rowland (blog | twitter) has done a great job organizing an interesting effort to help unemployed...
2010-07-17
588 reads
Speaking at SQL Server Connections in Las Vegas, November 1-4, 2010
Today, I received the official word that I will be presenting two sessions in the SQLServerCentral.com track at the SQL...
2010-07-14
881 reads
SQL Server DMV Starter Pack E-Book Published
Red Gate Books has published a new e-book called “SQL Server DMV Starter Pack”, which you can download for free...
2010-07-12
2,075 reads
Speaking at 2010 PASS Summit in Seattle
I just found out yesterday that I had one of my General sessions approved for the 2010 PASS Summit in...
2010-07-09
549 reads
Comparing the Performance of Different String Data Types in SQL Server 2008 R2
I thought I would try to do a few quick tests to compare the performance of assigning values and comparing...
2010-07-08
1,339 reads
SQL Server 2008 SP2 CTP Available
Microsoft has made the Community Technology Preview (CTP) of SQL Server 2008 SP2 available for download. This is Build 3798,...
2010-07-08
1,201 reads
Microsoft Assessment and Planning (MAP) Toolkit 5.0
I have been playing around with the new Microsoft Assessment and Planning (MAP) Toolkit 5.0 Beta 2 tool for the...
2010-07-07
801 reads
Electricity Conservation and Solar PV Power
Since I got my grid-tied solar PV system on my roof turned on almost two weeks ago, I have gotten...
2010-07-01
3,091 reads
How To Stay Current with SQL Server Cumulative Updates
Since the release of SQL Server 2005, Microsoft has been using what they call an Incremental Servicing Model for SQL...
2010-06-23
2,181 reads
Blogs
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Finding and Killing Blockers with Redgate AI Tech
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Back at Small Data SF in 2025
By Steve Jones
Today I’m in San Francisco at Small Data SF 2025. I went to the...
Forums
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
T-SQL in SQL Server 2025: Substring Changes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers