By Alexander Chigrik – When SQL Server is installed the setup program creates tempdb database. Tempdb is a system database used by SQL Server to store temporary tables and temporary stored procedures, for sorting, subqueries, and aggregates with GROUP BY, ORDER BY, for cursors and so on. Tempdb data
Author: SSWUG Research
Run Full-Text Database Searches On a Shoestring
by Roger Jennings – The emergence of XML as the lingua franca of data interchange has caused an increasing demand for storing hierarchical XML documents in relational databases. Inserting XML documents in [n]varchar or [n]text columns of SQL Server tables is easy, but retrieving rows containing rele
Log Switch Activity
by Darrin Deeter – Description: Here’s a simple script that determines when your database is seeing the largest amount of change activity. This is very useful for answering questions like, why was the system so slow yesterday about 2:30? Or trying to balance out a large amount of batch work. Credit
Copy the structure of a table
(Urmila Verma) Here is a very simple tip for Oracle users. Many times in my various projects I have come across cases where I needed to CREATE a table with exactly the same structure as an existing table but without any records. Here’s how to do it. (R)
Bag of new tools for editing XML in simple text form
XML has become more popular as an authoring format, and it brings with it the frustrating choice between typing tags ad nauseum, or adopting XML GUIs that may be too expensive, too buggy or too proprietary for preference. Numerous systems, formats and tools have sprung up to provide useful authoring
Run Full-Text Database Searches On a Shoestring
by Roger Jennings – The emergence of XML as the lingua franca of data interchange has caused an increasing demand for storing hierarchical XML documents in relational databases. Inserting XML documents in [n]varchar or [n]text columns of SQL Server tables is easy, but retrieving rows containing rele
XML Standards For Human Resources Move Forward
By Richard Karpinski – A group of vendors and companies involved in providing human resources software and services said they've approved a new version of XML standards to help automate the exchange of HR information.
How to Perform a SQL Server Performance Audit
by Brad M. McGehee – Over the last five years that I have been a SQL Server DBA, I have put together a mental checklist that I use when it comes to performance tuning SQL Servers. I use this checklist as a guide when I perform a “performance audit” a (new to me) SQL Server for the first time. I […]
Check Out the SQL Server Playback Program
By Brian Moran – Microsoft announced a new SQL Server quality assurance program last year called the SQL Server Playback Program, and the company is now actively seeking a new round of SQL Server Playback customers to get ready for the Yukon rollout in 2003.
Does Sort Order Affect Performance?
I have seen information about how sort order affects performance in SQL Server 6.5, but I can not find similar information about sort-order performance in SQL Server 2000 or SQL Server 7.0. I am trying to decide if using binary sort makes sense for my SQL Server 2000 application. What is the perform