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,087 reads
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,087 reads
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,316 reads
In this article, Brian Knight shows you how to convert data stored in DB2 to SQL Server using DTS.
2001-05-09
7,153 reads
A response from Great Plains Software on the use of the sa account in Dynamics software.
2001-05-09
4,470 reads
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
8,969 reads
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,431 reads
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,016 reads
Using the sa account in development is just plain dumb. Here are some reasons why!
2001-05-08
6,789 reads
The type of datatypes that you use in your schema could impact the performance and the accuracy of your database.
2001-05-07
6,595 reads
Can you run a DTS package from Query Analyzer...you sure can! Read how to integrate DTS, Jobs and Stored Procedures to run a DTS Package from Query Analyzer.
2001-05-07
10,547 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
I assume SSMS V20 encryption and SQL Server SSL encryption are different. I have...
Comments posted to this topic are about the item Enable a Disabled Index
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers