Information about the status of your full-text search process is not always readily available or in one place. Although you can check some values in the Support section of Enterprise Manager, not every configuration value is there. In order to check if
Multiple queries against system dynamic management views and catalog views result in database ID's and names with a NULL value. Is something wrong with my queries? How can the database name or ID be NULL? Can I modify my queries to capture the correct v
With the new features in SQL Server 2005 Integration Services, what are the related impacts to SQL Server 2005 Agent? Do I still need to build a dtsrun command (SQL Server 2000) to execute an SSIS Package in an automated manner? What insight do I have i
Finding a good reporting mechanism for your SQL Server environment can be tedious and time-consuming-you can either write your own reporting application or choose a third-party solution. You may also have to install an instance of Reporting Services in yo
In this tip we look at how to track the growth and usage of your SQL Server database transaction logs.
In this tip we look at a simple way to get a sortable list of space used for all tables in a SQL Server database.
Providing Full-Text Search functionality for an application using SQL Server 2000 can be tricky enough even without errors in the population process. There are a number of ways to evaluate and diagnose errors that occur. One way is to look in the Window
For many applications searching and providing a subset of a large result set is the core application functionality. Often the result sets are large and it is a resource intensive process to gather and display the data. This is because the same query is
Review this tip to learn how to schedule backups for SQL Server Express.
Every once in awhile you may have the need to access some data from the Windows operating system or from the contents of a file. The need may be to find out what files exist in a directory, to read the contents of a log file into SQL Server or for some o
Who invited all of these guests to my database? Did you know that the guest user account even exists in your SQL Server databases? Do you know that SQL Server needs the guest user account for particular functionality that differs in SQL Server 2000 vs.
In an earlier tip Energy Policy Act of 2005 Implications on SQL Server we outlined how SQL Server leverage Windows for their date and time needs. As such, applying patches to Win
SQL Server is packed with so many different components that finding the time to discover what is included as well as finding the time to learn about these different features is often a challenge. SQL Server is great as a relational engine, but there are
I have configured Database Mirroring successfully between 2 SQL Server 2005 instances. My application is connecting to SQL Server using a SQL Server login, and is built using ADO and the SQL Native Client. My connection strings/connection settings specify
In addition to hyper-threading (i.e. multiple threads execute on a single physical CPU appearing as 2 logical CPUs) and dual-core technology (i.e. a single CPU socket that has more than 1 core appearing as multiple logical CPUs), chip vendors are beginnin
There are several maintenance tasks you should perform on your SQL Server databases such as handling index fragmentation which we cover in this tip.
We've mentioned in previous tips that the process of creating, building, and maintaining full-text search capabilities is quite a daunting task. During the installation of Full-Text Search for SQL Server 2000, one of the folders gets installed in a not-so
In the United States, the Energy Policy Act of 2005 (http://webexhibits.org/daylightsaving/b.html) was approved by President Bush on August 8, 2005. Due to this legislation, the day light savings start and end times in the United States will change in the
In this tip we look at different approaches for building dynamic SQL code.
In this tip we look at how you can drag query result columns to different locations in a query result window.
SQL Server log shipping overview.
In SQL Server 2000 connections were made by dragging a connection type to the designer. The problem was that the number of connections was limited, and many of them had to be made using a scripting language like VBScript or JScript. The arrival of SQL Ser
You're reviewing your SQL Server error logs and a series of words catch your eye...STOLEN, DIRTY, KEPT, WAITING. And those words are surrounded by a bunch of numbers. The sight is more than a little ominous, particularly if you've never seen it before. So
Have you heard of the SQL Server 2005 Express edition, but not sure where it fits into your overall architecture? Are you concerned it is too constraining and will not meet your business needs? Are you looking for ways to continue to use SQL Server in n