When a client computer connects to an instance of SQL Server that is running on another computer in the network, the data that is exchanged between the client computer and the server computer may have to be kept confidential, especially in scenarios such as authentication. To make sure that the
Other News
Check rerun status of failed or cancelled jobs
(Jules Bui) This script will check the rerun status of failed or cancelled jobs and the job steps. There are many times when you have multiple job/steps failures and you would like to find out in a quick way of what needs to be rerun. This will help. (script)
The Beauty Is in the Details
(Steven Feuerstein) Some of my past articles in Oracle Magazine have offered a variety of “big picture” best practices to help you write code properly. This article takes a different approach. It invites you to pay attention to seemingly minor details in the way you write IF statements, loops, and d
Be Prepared – Part 2
(Stefan Popovski) Using Hierarchy of Stored Procedures we can generate hierarchical report of nested procedures: If Proc1 calls Proc2 and Proc2 calls Proc3 we will have this report: -Proc1 –Proc2 —-Proc3 (R)
How much CPU overhead used to process SQL error codes?
(Craig Mullins) DB2 v7 z/OS: Our performance monitor has a SQL error summary that shows thousands of SQL error codes per hour. Most of these errors are handled in the application code (COBOL CICS) and do not result in an abend in which the user is aware of. My question is how much CPU overhead is th
Analyze The Analyzed
(Jayant Kulkarni) One of the key pieces of information needed in performance tuning under a Cost Based Optimizer (CBO) is to identify whether stats are run on all the tables, indexes, and their sub-objects (partitions and sub-partitions).
Thinking XML: Harold’s Effective XML
(Uche Ogbuji) Noted XML expert Elliotte Rusty Harold’s book Effective XML offers best practices for users of XML technologies. Much of the discussion in the book touches on issues of XML design that have also preoccupied Uche Ogbuji, and in this article he discusses the book as the thread for furthe
Moving the Tempdb and Master Database in SQL Server
(Steve Warren) There have been many occasions where I found it necessary to move the database and log files to different drives to increase performance. When you want to move a typical user database to a different drive for performance or to split out the logs, you run sp_detach and sp_attach to per
Speed Transact-SQL Development with Speed SQL IDE from Imceda
(Brad M. McGehee) If you do a lot of Transact-SQL development, you know that the tools provided with SQL Server 7.0 and 2000 aren’t as complete or integrated as you might like. In most cases, you probably use some combination of Query Analyzer, Enterprise Manager, DTS, and maybe even some third-
Mainframe EXTRA: A Look at IBM DB2 UDB V8
(Malcolm Nolan) IBM DB2 Universal Database (UDB) for z/OS Version 8 and its feature, DB2 Query Management Facility (QMF) V8.1, became generally available this year. Both improve upon their predecessors and can help streamline the operation of your enterprise.