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,208 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,774 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,333 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,933 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,324 reads
An interesting database option which is hidden from Enterprise Manager in SQL Server 7.0 is offline.
2001-05-21
9,712 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,022 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,601 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,221 reads
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
Recently I received a cry for help over Teams. The issue was that an...
You can't handle the truth!! (about data integrity) A few good database administrators https://www.helpmasterpro.com/blog/a-few-good-database-administrators/...
I have installed Machine Learning with SQL 2022 Enterprise Edition and installed and configured...
Comments posted to this topic are about the item A Guide to SQL Security...
I have run this on SQL Server 2022 for the Sales database:
ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)I then run this in the Sales database:
USE Sales GO CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers