Viewing 15 posts - 20,941 through 20,955 (of 26,490 total)
Could you provide the code (stored proc and function), table DDL (target table for the stored proc and the UDF)?
There may be a better way, but we'd need to see...
May 18, 2009 at 1:59 pm
amina omar (1/23/2004)
why does the reindex job fill up the t_log?
The reindex operation is a fully logged operation, that is why it writes to the transaction log. If you...
May 18, 2009 at 1:31 pm
Check out Books On-Line (BOL). You want the REPLACE() function.
May 18, 2009 at 11:17 am
Need more information. What versions of SQL Server are being run on the two servers and what is the database compatibility modes on the databases in question?
May 18, 2009 at 10:48 am
(CONVERT(VARCHAR(10), a.Stage_LoadDate, 112) = CONVERT(VARCHAR(10), GETDATE(), 112)
OR CONVERT(VARCHAR(10), b.Stage_LoadDate, 112) = CONVERT(VARCHAR(10), GETDATE(), 112)
OR CONVERT(VARCHAR(10), c.Stage_LoadDate, 112) = CONVERT(VARCHAR(10), GETDATE(), 112)
OR CONVERT(VARCHAR(10), d.Stage_LoadDate, 112) = CONVERT(VARCHAR(10), GETDATE(), 112))
Try...
May 18, 2009 at 10:36 am
Jeremy Brown (5/18/2009)
May 18, 2009 at 10:33 am
FelixG (5/18/2009)
declare @cargo int
set @cargo = 5
Select distributorid, distributorname, distributorstatus,distributorcargo
from Dist_Main M inner join Dist_Details D on
M.DistPK = D.DistFK
where distribuborcargo = @cargo
and distributorstatus in ('9', '7','5','1')
You should consider the use...
May 18, 2009 at 10:30 am
There may be other alternatives, but the only two I can think of are to create a temorary (dynamic) table and join to it in the FROM clause or create...
May 18, 2009 at 10:09 am
Please don't double post. Please reply on the this thread.
May 18, 2009 at 9:56 am
Since an INSTEAD OF INSERT trigger fires prior to the actual INSERT, I'd actually vote for Gus's solution, but I also agree with him on the testing in a development...
May 18, 2009 at 9:49 am
Not only that, but you are trying to insert records that have already been "inserted" into the table. I agree with Luke. You need to extend your primary...
May 18, 2009 at 9:14 am
I agree with Steve. Also, I'd run separate backup processes for each database.
May 18, 2009 at 9:06 am
The only two things missing from the above is your expected results and the code you have developed so far. Sorry, but the graph and your verbal description just...
May 18, 2009 at 9:03 am
John Marsh (5/17/2009)
Generally speaking it is preferable to filter records at the Server, particularly in order to reduce Network Traffic.
A slight alternative to Lynn Pettis’s suggestion would be to...
May 18, 2009 at 8:35 am
Viewing 15 posts - 20,941 through 20,955 (of 26,490 total)