Viewing 15 posts - 1 through 15 (of 314 total)
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...
July 30, 2020 at 5:25 pm
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 =...
October 29, 2012 at 2:30 pm
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'
October 29, 2012 at 1:10 pm
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...
October 26, 2012 at 12:02 pm
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...
October 23, 2012 at 12:41 pm
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...
October 23, 2012 at 12:27 pm
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.
August 4, 2011 at 9:48 am
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?
February 25, 2011 at 5:00 pm
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]...
June 9, 2008 at 12:17 pm
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...
April 2, 2007 at 5:49 pm
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...
February 20, 2007 at 5:57 pm
All the article I searched was pointing to windows2003 server but the server I have is win2k.
January 12, 2007 at 10:46 am
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...
January 11, 2007 at 4:21 pm
master.dbo.xp_sendmail @email@example.com',@query ='EXEC master..xp_fixeddrives'
January 11, 2007 at 4:17 pm
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.
December 14, 2006 at 11:06 am