Documented and Undocumented Trace Flags for SQL Server 2000 and 7.0
This article contains descriptions of 65 documented and undocumented trace flags currently available in SQL Server 7.0 and 2000.
2002-07-24
14,773 reads
This article contains descriptions of 65 documented and undocumented trace flags currently available in SQL Server 7.0 and 2000.
2002-07-24
14,773 reads
In this article by Randy Dyess he shares with you the script on how he audits his environment and outputs reports of the permissions that users have.
2002-05-30
9,846 reads
As you advance in your skills as a Transact-SQL developer or SQL Server database administrator there will come a time when you need to override SQL Server's locking scheme and force a particular range of locks on a table. This article by Randy Dyess shows you how to optimize your queries using table hints.
2002-04-15
21,879 reads
Script that will show a method of replacing a cursor with a temporary table. This script will loop through all the databases on a server and run sp_spaceused on all user tables.
2002-04-08
623 reads
Ever been placed into a new environment and couldn't
find an ounce of documentation? This article is the first in a series that will help you make an audit of your new environment
and determine if any SQL Server login does not have a password, has a password the same as the login name or a password that is only one character long.
2002-04-02
10,426 reads
This script is actually part of an article written about performing a simple password audit on SQL Server logins when you start to administor a new SQL Environment. The script will scan the sysxlogins table located in the master database for SQL Server logins with no passwords, passwords that are the same as the login […]
2002-03-27
1,542 reads
Use this script to find tables, views, stored procedures that directly reference a column in the SELECT statement or in a join. This script will also return stored procedure and view names that have SELECT * in them when the specified column exists in the table referenced by that SELECT statement.
2002-03-15
1,046 reads
One of the most overlooked areas in optimizing SQL Server and Transact-SQL is the recompilations of stored procedures. A database getting thousands of recompiles an hour will suffer in performance and show short term blocking that will affect the database users. This article by Randy Dyess shows you some of the ways you can avoid stored procedure recompiles.
2002-02-26
24,598 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
I've tried different credentials, target server versions, etc. hitting our Primavera WSDL. Works great...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers