Viewing 15 posts - 12,736 through 12,750 (of 14,953 total)
Probably the main reason it's running so slowly is this:
DATEDIFF(d,CONVERT (VARCHAR(10) ,RL.TS_ID,101),
(SELECT CONVERT(VARCHAR(10),Last_Successful_Run_Date,101)
FROM dbo.tbl_Load_Audit_History WHERE [Object_Name]='PLUS_IDO_SALES_DETAILS' AND System_Name='PivotLink' AND IsActive=1)) <0
(From the Where clause.)
First, it's a correlated...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 18, 2008 at 1:44 pm
I'd say that it had realized after the first run that the only column you're actually using from each of the first CTEs is the SSN column, and that the...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 18, 2008 at 1:31 pm
Is the database running at acceptable speed? Users get their data in a timely way? If so, I wouldn't mess with the indexes. Not with what you're...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 18, 2008 at 1:27 pm
RAID-0 should do well on write performance, in theory. I haven't used that on a database, for data-safety reasons, but it should be okay. RAID-1 won't write as...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 18, 2008 at 1:24 pm
My usual solution would be to either set up an SSIS package and have it clean up the data in there before it goes into the final table, or to...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 18, 2008 at 1:19 pm
I'm not clear on exactly what you're trying to do here, but this part definitely won't work:
sum(select t.tax1_amt as 'IVA' where tran_code='7000'
Nor the other parts like it. Not sure...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 18, 2008 at 1:17 pm
I wrote a couple of articles on logging and auditing a little while back. They might help. They're at:
http://www.sqlservercentral.com/articles/Auditing/63247/
http://www.sqlservercentral.com/articles/Auditing/63248/
The discussions have a lot of good data in them...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 18, 2008 at 1:12 pm
I've used that kind of arrangement before. Lots of companies do that. Can get a little slow if you're transmitting large or frequent data sets/updates across the Net,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 18, 2008 at 1:09 pm
If it's an OLAP database (which is what it sounds like, with infrequent writes and lots of reads), RAID-5 should work well for the data files, but you probably won't...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 18, 2008 at 1:04 pm
Have you taken the samples you provided, and run them in your database on your dev server?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 18, 2008 at 12:21 pm
Can you fit the whole thing on a RAID-1 of the two drives? That's the safest. If you really don't care about that, then RAID-0 with multiple partitions...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 18, 2008 at 12:14 pm
I'm assuming your table has a PK, probably an ID. Here's something that will work:
;with
Numbers (Number) as
(select row_number() over (order by object_id)
from sys.all_objects),
SplitString (ID,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 18, 2008 at 12:01 pm
Before anyone can help you, you need to at least post the code in the proc. Most likely, you'll also need to post the table structure and insert statements...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 18, 2008 at 11:49 am
Since triggers have to be created on each table that you're going to log, why not just put the primary key in the trigger directly? This seems a little...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 18, 2008 at 11:48 am
Shaun McGuile (7/18/2008)
GSquared: Scientology?!?What does that mean? Cruise and Travolta come over and talk at you? :D....--Shaun
LOL
What makes you think I don't go over and talk to them? 😉
(They're both...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 18, 2008 at 8:10 am
Viewing 15 posts - 12,736 through 12,750 (of 14,953 total)