2001-05-11
2,300 reads
Articles
Detaching and Attaching a Database
Detaching and attaching a database is an advanced trick that can be useful in anything from transporting your database to recovering from a disaster.
2001-05-10
17,075 reads
Generate Test Data Quickly With Cross Joins
Need to rough up some bulk test data in a hurry? A carefully thought-out Cross Join could be the answer.
2001-05-10
6,490 reads
Putting 'FOR XML' to Use
Want to take advantage of some of the benefits of using XML for data exchange, take a look at 'FOR XML' in SQL 2000.
2001-05-10
6,114 reads
Using the Public Role to Manage Permissions
This article by Andy Warren discusses both how to use the Public Role and how using Public may cause you more problems than it's worth. Great examples!
2001-05-10
18,571 reads
Conversion of DB2 Data to SQL Server through DTS
In this article, Brian Knight shows you how to convert data stored in DB2 to SQL Server using DTS.
2001-05-09
7,183 reads
Someone Actually Thought This Through
A response from Great Plains Software on the use of the sa account in Dynamics software.
2001-05-09
4,484 reads
Avoiding Bottlenecks with Temporary Tables
Were you aware that the act of populating a temporary table can cause system-wide bottlenecks on your server? Problems can occur both with SQL Server 6.5 and 7.0/2000 in different ways, and in this article Neil Boyle discusses how best to avoid them.
2001-05-08
9,011 reads
Configuring SQL Server 6.5
A properly configured SQL Server can mean the difference between a sluggish server and one that runs well. There are a few pitfalls that you can experience in doing this.
2001-05-08
3,483 reads
IIS Connection Pooling ? ADO Gotcha!
This article by Leon Platt speaks to how you can avoid pulling your hair out when configuring connection pooling for IIS.
2001-05-08
8,155 reads
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers