Introduction to New T-SQL Programmability Features in SQL Server 2008
This paper introduces key new Transact-SQL programmability features in Microsoft SQL Server 2008 as well as SQL/Common Language Runtime (CLR) enhancements.
2008-10-24
6,178 reads
Additional Articles
MSSQL Analysis Services - Attribute Member Names
Business Intelligence Architect Bill Pearson continues his exploration of Attribute Members, in another member of a subseries surrounding significant components of the Analysis Services dimensional model. In this article we examine the attribute member Name property, whose appropriate use is important to good model design and overall system performance.
2008-10-24
2,199 reads
Audit data using SQL Server 2005's COLUMNS_UPDATED function
Auditing data changes in your production environment is very important, especially if you are dealing with confidential information.
2008-10-23
4,223 reads
Auto generated SQL Server keys - uniqueidentifier or IDENTITY
I'm designing a table and I've decided to create an auto-generated primary key value as opposed to creating my own scheme or using natural keys. I see that SQL Server offers globally unique identifiers (GUIDs) as well as identities to create these values. What are the pros and cons of these approaches?
2008-10-23
5,803 reads
Filtered Indexes in SQL Server 2008
This article demonstrates the performance improvements that can be achieved using Filtered Indexes in SQL server 2008
2008-10-22
2,688 reads
Tips for tuning SQL Server 2005 to improve reporting performance
We are required to report from our SQL Server 2005 database. There are five or six tables regularly used for holding the reporting data, but these tables have five-to-seven million rows of data in them already. We need to use these tables consistently and our performance involving reporting is struggling. Do you have any tips to help improve it?
2008-10-22
4,961 reads
SQL Server 2005 Express Edition - Part 32 - Distributed Service Broker Environment - Conducting Dialogs
This installment of our series focuses on establishing, conducting, and terminating a sample Service Broker dialog in a distributed environment, leveraging previously established routes and dialog-level permission.
2008-10-21
1,729 reads
SQL Server Cursor Examples
In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them. Can you provide some cursor examples?
2008-10-21
5,907 reads
SQL errors and other failures fixed from the trenches
Solve your SQL Server error, problem or installation failure with this advice. Learn how to fix SQL performance errors and suspect data recovery problems.
2008-10-20
3,381 reads
SQL Server Sanity: Maintain Healthy Transaction Logs for Easy Data Recovery
Learn how executing frequent backups and maintaining healthy transaction logs in SQL Server leads to quick recovery. Failing to do so can mean having to re-enter a lot of data.
2008-10-20
3,238 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers