New features in SQL Server 2008 justify migration
New features such as the FILESTREAM data type and Policy-Based Management offer clear performance enhancements that may make the decision to migrate to SQL 2008 a no-brainer.
2009-04-16
4,223 reads
SQL Server 2008
SQL Server 2008 Resource Governor primer
In this chapter excerpt from "Microsoft SQL Server 2008 Management and Administration", learn how Resource Governor can improve SQL Server performance.
2009-04-13
2,489 reads
SQL 2008 MERGE using Dynamic SQL over a Linked Server
Stored Procedure to build a MERGE statement in SQL 2008 using dynamic SQL.
2010-05-31 (first published: 2009-04-06)
2,491 reads
Exploring SQL Server 2008’s Filtered Indexes
One of the most interesting features in SQL Server 2008 is filtered indexes. This article starts with a quick explanation and then digs into the details and results.
2009-04-06
2,810 reads
SQL Server 2008 Service Pack 1 Released
Service Pack 1 for SQL Server 2008 has been released. Follow the link for more information.
2009-03-13
3,769 reads
SQL Server 2008 Integration Services Tasks
This article is the first in a series of articles that will be covering all the Control Flow Tasks and Maintenance Plan Tasks in SQL Server 2008 Integration Services
2009-03-12
2,275 reads
T-SQL Debugger is back in SQL Server 2008
Debugging capability in SSMS was a long sought feature by users and finally the Microsoft SQL Server team decided to provide this feature in SQL Server 2008.
2009-03-09
4,514 reads
The Data Loading Performance Guide
This document described techniques for bulk loading large data sets into SQL Server. It covers both the available techniques as well as methodologies to performance tune and optimize the bulk loading process.
2009-02-24
3,931 reads
New Features in SQL Server 2008 Management Studio – Part 2
This article is the final article in a series that explores new features that are available in SQL Server 2008 Management Studio
2009-02-19
3,549 reads
New Features in SQL Server 2008 Management Studio – Part 1
This article shows the new features that are available in SQL Server 2008 Management Studio
2009-02-17
5,046 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
New SQL Server 2022 Functions
Comments posted to this topic are about the item New SQL Server 2022 Functions
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers