Is there such a thing as a task where you would not need a cursor? Hidden in the depths of the master database are a series of stored procedures that can replace some cursors with these one-liners.
2001-05-22
14,193 reads
What do the TPC-C benchmarks mean to the average DBA? In this article, Neil Boyle steps back and looks at them from a practical view.
2001-05-22
5,772 reads
Using DMO to execute a job is a powerful technique that is easy to apply. This article by Andy Warren has all the code you need to do it!
2001-05-22
5,329 reads
The case where one has to send the results of a query to a text file comes up quite often. This quick tip will show you how to output the results of a query to a text file.
2001-05-21
11,932 reads
Your database design should be impervious to this documented behavior of the ADO delete method. Be one of the first five members to give a compelling reason why not, and take a dollar from starving columnist Sean Burke.
2001-05-21
3,323 reads
An interesting database option which is hidden from Enterprise Manager in SQL Server 7.0 is offline.
2001-05-21
9,704 reads
You cannot do a proper tuning job on SQL server in two minutes, but you can get a good idea of how well a server is set up. This article will show you how to quickly evaluate the efficiency of memory usage on your server.
2001-05-21
10,016 reads
VMWare is a software product that is great for testing new ideas without having to purchase and install a separate machine.
2001-05-21
4,331 reads
A review of the SQL Server 2000 Black Book from the Coriolis Black Book series.
2001-05-18
4,599 reads
In SQL Server 7.0 Data Transformation Services (DTS), dynamically configuring packages was difficult. With the aid of a new Dynamic Properties task in SQL Server 2000, this assignment is easy.
2001-05-18
12,208 reads
I recently received a complaint that Query Store for a particular database was turned...
I love QuickieStore, but I wanted some columns to be at the front end...
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...
Hi All, I would like to know the downsides of giving permissions to run...
I have a stored procedure that pulls JSON data from a US government web...
Don't know if this is the right place for this topic. I have an...
What is wrong with this code?
DECLARE @p NVARCHAR(10) = 'year' SELECT DATEPART(@p, GETDATE())See possible answers