StarSQL 3.0 Configuration
In this article, you are shown how to configure StarSQL, which is one method to rapidly connect to DB2 databases.
2001-05-07
3,441 reads
In this article, you are shown how to configure StarSQL, which is one method to rapidly connect to DB2 databases.
2001-05-07
3,441 reads
Have you ever worked with an application that forgot to close its connections? Ever run out of connections on your SQL Server and had to manually go remove the ones that are not in use? This article will present a technique for keeping the database clean.
2001-05-07
5,111 reads
So, you've added a linked server and need information about it. There must be an easier way to fine information about your linked server and keep from walking to the server room.
2001-05-07
9,787 reads
Provides audience with information on cluster analysis algorithm.
2001-05-07
1,594 reads
A little known feature that SQL Server offers is linked servers. Linked servers give the developer the option to use distributed queries and are a vital part of SQL Server's scalability.
2001-05-06
21,346 reads
This article will show you some of the common problems fixed in service pack 3 for SQL Server 7.0 and how to rollback.
2001-05-04
6,106 reads
Need to make changes to table that is an article in a publication? Read this article to get step by step instructions on how to do it without doing a new snapshot!
2001-05-02
8,224 reads
Confused about the difference between using a DSN or DSN-less connection? This article by Andy warren explains the differences and offers some insight into when each is appropriate.
2001-05-02
5,773 reads
In this product review by Brad McGehee, he shows you how Coefficient helps you performance tune your database.
2001-05-02
1,543 reads
2001-05-01
3,270 reads
By Steve Jones
Here are the slides from my talk today: CI in Azure DevOps If you...
By Steve Jones
I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email,...
By Steve Jones
hickering – n. the habit of falling hard for whatever pretty new acquaintance happens...
Comments posted to this topic are about the item Are We Dinosaurs?
Sample query reply appreciated Getting the following error: Conversion failed when converting the varchar...
For the last few weeks every time I get into SSMS 20.2 I am...
What happens with this code:
DECLARE @Iteration INT = 0; WHILE @Iteration < 10 SELECT CustomerName, CustomerStatus FROM dbo.Customer WHERE CustomerID > 3; SET @Iteration += 1;See possible answers