(Andy Warren) I bet you’ve all had what I call a mini disaster, something that entirely disrupts production for a minute to a day or so. Sometimes it’s user error, a bad patch, user error, hardware failure, or user error! These mini’s are times that will often test your character. As much as I hate

(Marcin Policht) SQL Server 2000 offers a number of security mechanisms that impose predefined levels of control over database objects and operations. We have discussed the most common of them, such as server and database roles, in the previous articles of this series. While they are convenient

(Brian Moran) I have two tables, Account and AccountTransaction, that have more than 20 million records each. There’s a one-to-many (1:M) relationship between Account and AccountTransaction. Data Transformation Services (DTS) constantly loads new records into the tables by using a text file. My comp

When you try to start an instance of SQL Server after you restore the model system database by using the WITH NORECOVERY option, the instance of SQL Server may not start successfully. Additionally, you may notice the following error messages in the SQL Server error log files: 2003-04-18 09:37:3

(Nicholas Cain) There are a lot of posts on the site regarding index fragmentation and possible ways to deal with this. You could certainly use the Database Maintenance Plans built into SQL Server to handle your re-indexing needs, however frequently you want something a little more directed than the

(William Pearson) In this lesson, we will conclude our “triptych” of articles exposing set functions that deal specifically with subsets. As we have noted, each function returns a subset of a larger set, as part of its operation. We began the subset functions articles with an examination of the Head

(Shankar Pal, Vasili Zolotov and Leo Giakoumakis) This paper covers several ideas, which are designed to improve query and data modification performance of the XML data type in the upcoming version of Microsoft SQL Server 2005.

Inside a trigger, if there is an ambiguous update statement and the first table in the FROM section is the logical table INSERTED or DELETED, the resulting message 8154 has an incorrect tablename. In SQL Server 7.0, the resulting message 1032 has an incorrect tablename.

(Anthony Glenwright) Most report design tools attempt to please both developers and non-technical end users by combining high levels of flexibility and power and ease-of-use. This accommodation naturally requires various sacrifices on both sides. With the Reporting Services Report Designer, Micr

(Brian Moran) Does SQL Server keep track of when new files and filegroups are added to or removed from a database, maybe in the form of a timestamp in the catalog? If so, how can I access that information? (R,$)