By Karen Watterson, 04/01/2000
Tips on determining the correct service pack build number, using the Database Consistency Checker (DBCC), and more.
By Karen Watterson, 03/30/2000
Stabilize nullability, monitor tables to find script triggers, make SQL Server and Oracle data compatible, implement custom application-locking schemes, and create indexes that ...
By Karen Watterson, 03/08/2000
Investigate how to install multiple instances of SQL Server, use the TOP statement with a local variable, use UDFs in SQL Server 2000, store extended properties, and more.
By Karen Watterson, 02/09/2000
Learn about the paging file's importance, SQL Server 7.0 evaluation version's hazards, build numbers, DBCC DBREINDEX and fragmentation, mysterious indexes, permissions problems, ...
By Karen Watterson, 01/10/2000
By Karen Watterson, 01/06/2000
Karen and Brian explore topics including DTS gotchas, the DTS ScriptPkg utility, FoxPro and SQlL server UDF support, and OLAP Services FoodMart data.
By Karen Watterson, 12/10/1999
Simultaneously manage SQL Server 6.5 and SQL Server 7.0, determine whether you can pipe output from Query Analyzer into a text file, and discover how to remove decimal points from ...
By Karen Watterson, 12/10/1999
Here are tips for transferring encrypted passwords between servers in SQL Server 6.5 and 7.0.
By Karen Watterson, 11/17/1999
Changes that Microsoft made to the SQL Server security model have caused performance slowdowns for certain queries. Here's a workaround.
By Karen Watterson, 11/15/1999
Karen and Brian discuss User DSNs vs. System DSNs, scripts that let you view temporary table structures, enhancements in OLAP Services 7.5, how to disable update triggers, and SQL ...
By Karen Watterson, 11/01/1999
The authors discuss how to customize users' security permissions.
By Karen Watterson, 10/29/1999
Karen and Brian discuss Win2K's effect on SQL Server users, security account delegation, NULL problems, compressed volumes, and SQL Server 7.0's TRUNCATE TABLE statement.
By Karen Watterson, 10/05/1999
Discover how to send large email messages via SQL Mail, read system sp code, and make Enterprise Edition use more memory, and learn about SQL Server 7.0's sysperfinfo table, SQL ...
By Karen Watterson, 10/01/1999
Read the tea leaves of key technologies--collaboration and KM.
By Karen Watterson, 10/01/1999
SQL Server 7.0's new Index Tuning Wizard is one of the basics in a DBA toolbox, but here's a weakness we recently encountered.
By Karen Watterson, 09/14/1999
Learn about single-table backup and restore, SQL Server 7.0 options to remove databases between servers, a REMOVE FILE error message, clustered index performance problems, and ...
By Karen Watterson, 09/01/1999
For Microsoft BackOffice and SQL Server users, Shiloh means the next major release of SQL Server.
By Karen Watterson, 09/01/1999
By Karen Watterson, 09/01/1999
By Karen Watterson, 09/01/1999