Viewing 15 posts - 5,041 through 5,055 (of 5,678 total)
Bruce-12445 (11/8/2010)
Yes, thanks for that.Would these record counts make any difference to your indexing changes:
select * from dbo.AMS_ASSETREGISTER --66451
select * from dbo.AMS_CATEGORY--115
select * from dbo.AMS_FIN_LINK -- 36240
Bruce
Need to see the...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 9, 2010 at 10:11 am
Bruce-12445 (11/8/2010)
I'll also see if the vendor will allow adding indexes.
If I use a view I obviously can't...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 11:32 pm
Bruce-12445 (11/8/2010)
oh yeah, the tables belong to an application so I can't change any indexes.
Then you're relatively screwed.
You can try dumping it all to a temp table and working it...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 11:12 pm
Test system, I hope? If so, try this:
CREATE INDEX idx_testing_orderby_AMS_CATEGORY ON AMS_Category ( Category_Name, Category_ID)
if that alone doesn't work, alter your JOIN to INNER JOIN dbo.AMS_CATEGORY c WITH (INDEX(...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 11:08 pm
A couple of ideas.
1) Look to see if its waiting on locks. Specifically when it runs long, see if it's waiting for an exclusive table lock. It might...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 9:51 pm
I've always been a fan long term products, and have yet to truly understand the need to re-invent the wheel every 3 to 5 years. Some good has come...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 9:38 pm
Find the drive your main backups are going to on the network, then contact your sysadmins and ask them to see if there's maintenance on those drives at that time.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 6:32 pm
The part of that which matters:
Error: 2010-11-09 08:00:02.97 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "BACKUP DATABASE [New_kvr] TO DISK = N'E:\Database..." failed...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 6:10 pm
WayneS (11/8/2010)
Forget the online text editor... put it into a word document. Steve will convert it.
NOW you tell me... 😛
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 6:04 pm
Diff backup should not break log chain. Have you checked the server logs to determine if something else is doing log backups, or if something is altering the recovery...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 5:35 pm
malik_nagel (11/8/2010)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 5:14 pm
CirquedeSQLeil (11/8/2010)
Craig Farrell (11/8/2010)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 5:07 pm
Minor derail. I wrote up an article in the editor here that I'm working on. I'm not sure how to give a link or visibility to another for...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 5:02 pm
Answer: Yes.
Next Question: How?
Next Answer: Please post DDL and sample data. See the first link in my signature for more help if you need it.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 3:01 pm
pop up a SSIS package with a single data flow item, then put in your three OLEDB sources and destinations in the flow.
Define your source and target server in the...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 1:56 pm
Viewing 15 posts - 5,041 through 5,055 (of 5,678 total)