Yes, use multiple files! It has some advantages, even on a SAN. Because Windows is using a thread for each file, IO management will better perform. Also restoring a database...

I would suggest to select only tables from sysobjects where type = 'U' if you want to update statistics by table (why not using sp_updatestats? This operation is pretty improved...

Thanks for fixing this bug.

I didn't put this into a stored procedure, because it's already isolating the current database (DB_ID() part)

The incorrect syntax issue is indeed caused by the...

Hi,

Your first impression was, ok. However, this is the correct procedure:

ALTER PROCEDURE [dbo].[usp_GetBrentDraegerMdaData]

@Columnnames nvarchar(max),

@Tablenames...