Just an update. Just a plain Update TableName set Col ='xyz' is failing

The server does have enough space, there is no restriction on max file size for data or log...

I think this should do it.

declare @FromDate DateTime, @ToDate DateTime

declare @TempFromDate datetime

Set @FromDate ='2011-01-16'

Set @ToDate = '2013-01-01'

Declare @daysDiff Int

Declare @monthDiff Int

Declare @yearDiff Int

Set @yearDiff = ABS(DATEDIFF(YYYY, @FromDate, @ToDate))

Set @monthDiff =...

Hope this is what you are looking for:

DECLARE @Top int --The number of records to return

DECLARE @SelectType varchar(6) --Either Top, Bottom or ALL

--SET @Top = 5

SET @SelectType = 'Top'

--SET @SelectType...

He put "Select 1" to avoid the overhead of getting meta data for all the columns in the table that is being selected. This has been the standarp practice to...

Thanks for the email. Based on my searches thats what I came across too. Do you know of any one who has created this as CLR function? May be I...

The problem with that solution is that you are not using the key. I need a function that accepts the data to be hashed and Key to use(I need HMAC-SHA...

Thanks for the feedback. Actually I did find the right tool. We bought cast iron (now part of IBM) and helped us with real time integration using messaging functionality.

Were you able to figure out an easy way to import files in HL7 data format using out of the box SSIS? If you have can you share your experience?

1.If your new column is static then

declare @newColID int, @PQID int

Set @newColID = 1

set @PQID =1234

Insert into resultTB( [PQID] , [col1] , [col2], [newColID])

select PQID,col1,col2, @newColID

from TB1 where TB1.[PQID]...

Hope this helps:

----------------

2007-03-30 16:39:21.26 server    Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)

 May  3 2005 23:18:38

 Copyright (c) 1988-2003 Microsoft Corporation

 Enterprise Edition on Windows NT 5.2 (Build 3790: Service...

I think ur database recovery is set to full which can cause the xcation log to grow if u don't have xcation log backup.

Either change the recovery mode or run...

All the article I searched was pointing to windows2003 server but the server I have is win2k.

Do u have SQL Replication set up. If so any pending replicated transactions can cause Database to not shrink.

Or Has the Recovery mode been changed recently(Simple to Full)?

Or do u...

master.dbo.xp_sendmail @recipients='email@xyz.com',@query ='EXEC master..xp_fixeddrives'

Having worn 3 hats at the same time for my previous employer I totally agree with the article. My 2 cents.

1.Prod DBA should be available 24/7 ready for any emergency.

2.Dev...