Viewing 15 posts - 1,381 through 1,395 (of 5,678 total)
weston_086 (7/5/2012)
These tables have no indexes.so if i have to create index which column would be the best in each table .
Schema please? I'd rather avoid giving...
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
July 5, 2012 at 5:44 pm
weston_086 (7/5/2012)
please find attached query plan for that.
Please also include the schema and indexing. In particular for ipv6_Daily_reporting, IP_Ver_Access_Point_Name, IP_Ver_Cl_Hset_Tac_OS_PDP. From what I see here these are simply...
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
July 5, 2012 at 5:02 pm
It's FileSpec, not FileNameRetrieval. Sorry about that.
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
July 5, 2012 at 4:59 pm
No problem. HAd a chance to setup a really simply test, and we've got the wrong expression. Trying to figure out which one it needs.
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
July 5, 2012 at 4:58 pm
PHXHoward (7/5/2012)
Because I have the directory specificed in the line above, I don't need it in the file name do I? I've tried fully qualified and name only.
Nope, you...
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
July 5, 2012 at 4:38 pm
While we could make guesses at this from just the code, there's a few pieces of it that we desire to try to help with optimization issues like this.
Please click...
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
July 5, 2012 at 4:35 pm
mw112009 (7/5/2012)
So you are saying I don't have to modify this any more.You mean, if there is one error along any path the entire package will stop ?
Cool.
Please reply
Unless you've...
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
July 5, 2012 at 3:41 pm
Welsh Corgi (7/5/2012)
What type of an Account are you using for the SQL Server Agent Account?
It's not the agent, but right idea. XP_CmdShell has a proxy user on 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
July 5, 2012 at 3:38 pm
PHXHoward (7/5/2012)
The file name will be CCYYMMDD_HHMMSS_update.txt
I know that I can not ask SSIS to match...
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
July 5, 2012 at 3:37 pm
That should already be occuring unless someone's been messing around with the allowable error counts and error inheritance in the components. A single fail should stop the process completely...
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
July 5, 2012 at 3:29 pm
WayneS (7/5/2012)
GilaMonster (7/3/2012)
For anyone not on/not paying attention to twitter.....It seems to be official.... I'm a Microsoft Certified Master for SQL Server 2008.
https://twitter.com/SQLintheWild/statuses/220252281847808001
Awesome Gail. Major congratulations!
Woot woot, go Gail! ...
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
July 5, 2012 at 3:03 pm
matthew.brown-746365 (7/2/2012)
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
July 2, 2012 at 6:23 pm
Your sysadmin will need to do it. Google it up, the list of instructions is long and intricate. Basically you need to end up having kerberos on Machine...
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
July 1, 2012 at 3:03 pm
You're asking us to look at the results of something when we have no schema nor data to work from, unfortuantely we're not going to be able to help much...
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
July 1, 2012 at 3:01 pm
Les Cardwell (7/1/2012)
>>Please define 'chokes'. You get an error message?Msg 102, Level 15, State 1, Procedure UpdEPCollectorAssociation, Line 15
Incorrect syntax near 'sp_getapplock'.
That's incredibly odd... I wonder if it's whining...
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
July 1, 2012 at 1:41 pm
Viewing 15 posts - 1,381 through 1,395 (of 5,678 total)