The Sysadmin Price List
Implement this and I guarentee your tech support call volume will drop!!! (Or you'll soon be retiring)
2001-09-25
2,798 reads
Implement this and I guarentee your tech support call volume will drop!!! (Or you'll soon be retiring)
2001-09-25
2,798 reads
IQReference is an online reference platform using well known, published materials. Read about this exciting and benefical product.
2001-09-24
3,159 reads
Or how to query for a particular type of customer. This article examines how you may query for particular rows that match one condition, but may not match another.
2001-09-19
3,731 reads
This script runs within a DTS package. It searches the backup directory stored as a global variable in the script and trims all backup files older than some number of days. the script includes logging to the C: drive so you can trace the effects of the script. You need to create the global variables […]
2001-09-12
1,509 reads
2001-09-11
2,988 reads
Left over from the Y2K fiasco, but a good corporate memo that might still be useful as an alternative to XP.
2001-09-10
2,058 reads
Give this test to your boss...only if he has a sense of humor!
2001-08-27
2,825 reads
Ever wonder what a DBA does? Ever had someone ask you what your job entails? Here's an overview of what a DBA does. Reader feedback will be used to update this article over time.
2001-08-24
9,091 reads
This script will search all logged in users and return the spid along with the number of seconds since that spids last batch was executed.
2001-08-22
947 reads
Lumigent has updated their transaction log analysis tool to include a number of features that every DBA will find handy. Read this review of a great new product.
2001-08-22
6,322 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