Database Snapshot and Rollback Transactions
A Rolled back transaction will increase the snapshot sparse file usage. New author Subash brings us an examination of how those database snapshots actually work.
2010-01-07
5,202 reads
Articles
Being Supportive
Steve Jones says we need to stick together in IT, at least from the perspective of the client. Otherwise we can all look bad as an industry.
2010-01-07
2,498 reads
Being Supportive
Steve Jones says we need to stick together in IT, at least from the perspective of the client. Otherwise we can all look bad as an industry.
2010-01-07
2,273 reads
Being Supportive
Steve Jones says we need to stick together in IT, at least from the perspective of the client. Otherwise we can all look bad as an industry.
2010-01-07
2,172 reads
Data searches that leverage existing indexes
Recent installments of our SQL Server 2005 Express Edition series have been discussing its implementation of Full Text Indexing. This article focuses on data searches, which leverage existing indexes, taking into account such features as noise words and thesaurus files.
2010-01-07
2,426 reads
Logging with SQL Server
This article from Ed Swiedler looks at using SQL Server to log activity from various sources. Service Broker and Windows Services are used to create a generic logging service that will build log files for you to examine outside of any application.
2010-01-06
4,623 reads
Transfer database schema objects and data to another server/database with SMO
In this tip, I am going to show you how you can use SMO (SQL Server Management Objects) classes to transfer database objects and data to another server or database.
2010-01-06
3,931 reads
Those Stubborn Database Rules - Finding Them and Scripting Them
Scripting out database rules to help you remove them from your database solutions.
2010-01-05
4,787 reads
Application and Multi-Server Management
This paper introduces the new extensions in SQL Server Management Studio and the Control Point Explorer, and it walks through the simple process of setting up a SQL Server managed server group, including SQL Server Control Point installation, enrolling an instance into central management, extracting Data-tier Applications from existing deployments, and deploying Data-tier Applications to the new managed server group.
2010-01-05
2,161 reads
Managing Large Data Sets in SQL Server 2005 and 2008
Easily manage operations against large data sets, be able to stop and start operations at a whim and throttle them up or down to manage system performance.
2010-01-04
10,560 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
BIT_COUNT() IV
Comments posted to this topic are about the item BIT_COUNT() IV
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers