Character Datatype Decisions
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
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
In this article, you are shown how to configure StarSQL, which is one method to rapidly connect to DB2 databases.
2001-05-07
3,439 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,746 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,341 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,105 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,215 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,745 reads
I had an excellent group of people in Gothenburg Sweden when I taught there...
By Steve Jones
How can I quickly get a CU patch for a system that’s out of...
Data analysis is all about wrangling massive datasets. To do that efficiently, you need...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
hi a peer of mine recalls an error in an edi app that often...
Hello SSC! First, I would like to thank everyone who has responded to my...
I have created these triggers in SQL Server 2022:
CREATE TRIGGER triggertest_tri_1 ON dbo.triggertest FOR INSERT AS PRINT 'one' GO CREATE TRIGGER triggertest_tri_2 ON dbo.triggertest FOR INSERT AS PRINT 'two' GOI want to be sure that the trigger with "1" runs first. I decide to run this:
EXEC sp_settriggerorder@triggername = 'triggertest_tri_1', @order = 'first'What happens? See possible answers