Viewing 15 posts - 571 through 585 (of 5,103 total)
Why are you using CTE at all ?
SELECT
t1.PubCode,
t1.Issue,
t1.DeferredCurrency,
t1.PaymentLength ,
DeferredAmount = SUM (case when t1.Issue > @IssueNumber then IsNull(t2.PieceRate,0) else 0 end),
...
February 3, 2009 at 2:24 pm
For some reason
SELECT INTO sounds more efficient to me. You are doing "both" bcp-out-and-in in a minimally logged fashion!
Then drop old rename new and apply indexes ...but then again......
February 3, 2009 at 2:01 pm
This sounds like homework but here you go anyway:
SELECT ClearedDate, TotalCleared,
STUFF(DDS,1,1,'') AS DDS
FROM
(
SELECT ClearedDate, SUM(Cleared) AS TotalCleared
, CASE WHEN SUM( case when...
February 3, 2009 at 1:51 pm
In addition do you need all 6000 rows ?
Can you "page" through them ?
February 3, 2009 at 1:17 pm
Ninja's_RGR'us (2/3/2009)
I think I'd go with the instead of triggers... if it saves me a full clustered index rebuild.
True but like with every thing there is an "it depends" 😀
You...
February 3, 2009 at 12:51 pm
They will embed the update code directly in the sprocs where the base table is itself updated.
WISE decision!
February 3, 2009 at 12:15 pm
GilaMonster (2/3/2009)
February 3, 2009 at 12:07 pm
For passwords:
http://support.microsoft.com/kb/246133
Jobs:
Script them out and apply them on the Target Server!
February 3, 2009 at 12:05 pm
Venkatroyal (2/3/2009)
our db is missing out some items while inserting using OPENXML.
we are inserting items one by one. i.e first item will be fed...
February 3, 2009 at 11:22 am
Are you looking for "no_output" ?
that is a parameter of xp_cmdshell not bcp.
xp_cmdshell { 'command_string' } [ , no_output ]
February 3, 2009 at 11:01 am
Can you verify that *after* you run the snapshot agent the Files are visible from the FTP side ?
February 3, 2009 at 10:58 am
Pardon my ignorance, but what are "full SQL Certified Systems" ?
For SQL Server Clusters MS had a policy that requires Not only The Server but The SAN/Fiber Channel Drives,...
February 3, 2009 at 10:56 am
Actually I have had the need for this feature for a long time.
Suppose you need to prevent changes on ONE table while you are doing some maintenance work in...
February 3, 2009 at 10:41 am
Lynn Pettis (2/3/2009)
Thinking about some more, you may also consider clustering the SQL Server systems that support your WSS/MOSS environment.
Clustering is the other HA that I didn't mentioned but it...
February 3, 2009 at 10:18 am
Your publication must have been setup with *all* ftp parameters requiered for that script to work. Did you verify that the publication is correctly set up ?
February 3, 2009 at 10:15 am
Viewing 15 posts - 571 through 585 (of 5,103 total)