DBCC SQLPERF (Logspace) Reporting Internals
This is a broad overview of the DBCC SQLPERF command primarily for version 7 and 2000.
2001-09-17
1,927 reads
This is a broad overview of the DBCC SQLPERF command primarily for version 7 and 2000.
2001-09-17
1,927 reads
By default, network database files are not supported with Microsoft SQL Server. Here's a workaround.
2001-09-14
1,145 reads
In an online transaction processing (OLTP) environment, the connection affinity mask option may provide performance enhancement in high-end, enterprise-level SQL Server environments that are running on computers with 16 or more CPUs. In particular, this option is useful when there are a significant number of network interactions (more than 10,000 per second) between the middle-tier application servers and the back-end SQL Server system.
2001-08-28
1,500 reads
In most tables it is enough to have a stored procedure that performs Update Else Insert logic for data managment. However, in some cases we do not want to destroy the old data with an update statement. Instead we want to maintain history up to a certain number of versions. This article presents a method for doing so.
2001-08-27
3,294 reads
We all know what the ideal application design environment is for building a database back-end: an experienced DBA takes inputs from end users and developers and creates the database design in order to support the application being developed. But in reality, we don't get the opportunity to do application design like this very often. This article covers how to quickly find and fix problems in a design.
2001-08-20
8,207 reads
This document introduces SQL Server administrators and developers to the new security features of SQL Server 2000. In addition to outlining the new features, there is a detailed discussion about how to best implement security in a Microsoft Windows® 2000 domain environment as well as source code examples.
2001-08-02
1,383 reads
This article presents the technical details of the page layout for data in SQL Server 6.5
2001-07-30
2,731 reads
Sizing a database can be one of the most arduous tasks a DBA, analyst or developer must attend to. It?s time consuming and more hours go into analyzing the database than actually sizing it. This article focuses on how to monitor the database?s growth after its deployed and contains some tips on how to size it before deployment. We will also dive a little into how to benchmark your database against a robust data load.
2008-08-01 (first published: 2001-07-25)
43,790 reads
Are you responsible for keeping your organization's database systems up and running? Are you the one they call in the middle of the night if the database server is down? If so, the SQL Server 2000 Operations Guide is for you.
2001-07-24
933 reads
2001-07-13
2,949 reads
I’ve covered how to create Elastic Jobs in the portal (this one is important...
By Steve Jones
redesis – n. a feeling of queasiness while offering someone advice, knowing they might...
By Steve Jones
The Solutions Engineers at Redgate recently released an Introduction to Redgate Flyway Autopilot course...
Comments posted to this topic are about the item No End to Programmers
Hi there to all SQL gurus So, here is the scenario. I have a...
Guys, I am facing problems when running a backup routine JOB in SQL Server,...
What is the result of this query in SQL Server 2022+?
select bit_count('7')See possible answers