RE: Question of the Day for 10 Feb 2004

I see what you guys mean, but it asked about the tran log, not the data file too.  Although it did assume you knew it was asking about redundancy too. 

RE: Question of the Day for 29 Jan 2004

Dave,would you please use the KISS approach when writing? You got me flipping through the pages of my dictionary Actually, I don't mind getting questions from a greate variety of topics as long as I can answer them

RE: How to send SP results to CSV file in DTS?

Definitely a loophole. Here we remove public and create a group in msdb that allows package creation/editing. A separate group is used for job executions on the very rare chance we grant it.

RE: Using xp_cmdshell

 Ok.. this SP.. its great.. but.. i am trying to call some BAT or EXE files.. and does not work...  Is there somebody that use xp_cmdshell to call one BAT or EXE file.. ?for example:xp_cmdshell 'c:\Winnt\System32\calc.exe' Tnks 

RE: DB Backup files

You are correct in your assumption that sqlmaint actually looks at the timestamp portion of the file name to determine which files to delete for a given database.  It will not, for example, delete all old files with a .bak (or any other) extension.  It will also not delete backup files that do not follow the […]

RE: New Forums are Live!

RE: Updating a view in SQL 2000

I ran this from one session: CREATE TABLE [dbo].[tbltest] ( [Pkey] [int] IDENTITY (1, 1) NOT NULL , [fname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [lname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] go CREATE VIEW dbo.vwTest AS SELECT fname, lname FROM dbo.tbltest go grant select on tbltest to public go grant insert, update […]

RE: How to TEST if statistics should be updated.

On this issue of index, what are the implications of having duplicate indexes. I have some on my inherited server and I want to gwet rid of the duplicates. However, I want to know what the implications will be. Thanks.

RE: TempDB operations faster?

Could your TEMPDB be in the fast I/O RAID disks than your user databases?

RE: How to TEST if statistics should be updated.

How is the reindexing being done? dbcc reindex updates statistics but if you are using indexdefrag I believe the statistics are not updated. Might be worth looking into if you did not write the weekly process.