Return Query Text Along With sp_who2 Using SQL 2000
This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".
2008-07-18
8,245 reads
Articles
Avoid Untrusted Constraints in SQL Server
Some time ago, I loaded a large set of data into one my tables. To speed up the load, I disabled the FOREIGN KEY and CHECK constraints on the table and then re-enabled them after the load was complete. I am now finding that some of the loaded data was referentially invalid. What happened?
2008-07-18
3,000 reads
Migrating from Business Objects Crystal Reports to SQL Server 2005 Reporting Services
This document assists Crystal Report designers with migrating to Microsoft SQL Server 2005 Reporting Services using a step-by-step migration strategy.
2008-07-18
3,526 reads
The Database Weekly Update for July 21, 2008
In this update from the past week Steve Jones looks at leaks in encrypted disks and Web 2.0 development.
2008-07-18
223 reads
The Database Weekly Update for July 21, 2008
In this update from the past week Steve Jones looks at leaks in encrypted disks and Web 2.0 development.
2008-07-18
212 reads
The Database Weekly Update for July 21, 2008
In this update from the past week Steve Jones looks at leaks in encrypted disks and Web 2.0 development.
2008-07-18
442 reads
SSAS Database Backup
Longtime SQL Server author Dinesh Asanka brings us a new article on backing up an Analysis Services database.
2008-07-17
15,510 reads
Things You Didn't Know About Temp Tables and Table Variables
New author Roi Assa brings us a short look at temp tables and table variables and describes a few of the characteristics and behaviors you might not have been aware of.
2008-07-17
13,983 reads
Soft Skills
A guest Friday poll from Adam Angelini, DBA and member of the band Wakamojo, which was featured on some editorial podcasts. This week Adam wonders about soft skills for DBAs.
2008-07-17
198 reads
Soft Skills
A guest Friday poll from Adam Angelini, DBA and member of the band Wakamojo, which was featured on some editorial podcasts. This week Adam wonders about soft skills for DBAs.
2008-07-17
207 reads
Blogs
Expanding Your DBA Horizons: Installing PostgreSQL in a Home Lab
By gbargsley
Are you diversifying your DBA skillset? My recent job search made one thing clear:...
Back in the EU
By Steve Jones
I flew to Amsterdam last night and hopefully by the time this publishes I’ll...
The Feedback Multiplier: How Leaders Can Turn Input into Innovation
By Chris Yates
In every organization there is a hidden currency more valuable than capital, more enduring...
Forums
Unlocking High-Concurrency Inserts in SQL Server with OPTIMIZE_FOR_SEQUENTIAL_KEY
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
Vector Datatype
Comments posted to this topic are about the item Vector Datatype
PRs Are Like Trouble Tickets
Comments posted to this topic are about the item PRs Are Like Trouble Tickets
Question of the Day
Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers