Viewing 15 posts - 2,326 through 2,340 (of 5,678 total)
notoriousdba (11/3/2011)
Craig,Ah, that's an excellent idea. I should have thought of that. Thanks!
My pleasure. Sorry it's taken me a while to get back to this, was down ill 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 15, 2011 at 4:20 pm
I should have mentioned one thing. I try to avoid LOBs like the plague. Obviously I haven't been able to all the time and have worked with them,...
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 15, 2011 at 3:50 pm
Couple of things here will help.
For starters, make sure you use the TEXTIMAGE_ON for the table creation to move the BLOB data to its own filegroup. You can shove...
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 15, 2011 at 3:45 pm
mandavli (11/15/2011)
under Step ID it shows 0 and that is message it shows.
Sorry, apparently I wasn't clear. you should have a better description if you expand the node and...
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 15, 2011 at 3:33 pm
mandavli (11/15/2011)
server Message
Executed as user: The package execution failed. The step failed.
I donot what is wrong with package as not other details...
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 15, 2011 at 12:23 pm
LutzM (11/15/2011)
Evil Kraig F (11/15/2011)
Ninja's_RGR'us (11/15/2011)
Someone can cover for me here... need to go!ttp://www.sqlservercentral.com/Forums/Topic1206207-1549-1.aspx
Linkie no workie
Try this one: (included the leading "h")
http://www.sqlservercentral.com/Forums/Topic1206207-1549-1.aspx
And I shall now facepalm in a mirror. ...
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 15, 2011 at 12:14 pm
^ Gail is our recovery and restoration god, with the ears of the people who built the system when she's not sure. Trust her, she's your best bet to...
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 15, 2011 at 12:11 pm
Pam Brisjar (11/15/2011)
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 15, 2011 at 12:06 pm
gregory.perry2 (11/15/2011)
You guys are Awesome!! Thanks for the suggestions, I will re work my stored procedure this way and use this technique going forward.I really appreciate the help!!:cool:
No problem, and...
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 15, 2011 at 12:00 pm
That seems like a reasonable start. I'm not sure I'd trust my end/business users to know about what administrative technologies they'll need though. It's not really their job...
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 15, 2011 at 11:55 am
Lowell (11/15/2011)
well, i would consider creating a view that pulls all 18 tables together...then the proc can select directly from the view and contine from there.
Good call Lowell, I hadn'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 15, 2011 at 11:50 am
Ninja's_RGR'us (11/15/2011)
Someone can cover for me here... need to go!ttp://www.sqlservercentral.com/Forums/Topic1206207-1549-1.aspx
Linkie no workie
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 15, 2011 at 11:47 am
For your first question, the reason to avoid dynamic sql is twofold. First is security, dynamic SQL is ripe for risk if you don't handle it properly. 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 15, 2011 at 10:56 am
Ninja's_RGR'us (11/15/2011)
Change between to >= AND <=
+ recompile
If that doesn't do it you'll have to add the extra...
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 15, 2011 at 10:30 am
GilaMonster (11/15/2011)
http://sqlinthewild.co.za/index.php/2011/11/09/sql-university-advanced-indexing-filtered-indexes-2/Query please?
Yum, tasty. Good stuff there Gail, thanks for laying it out.
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 15, 2011 at 10:27 am
Viewing 15 posts - 2,326 through 2,340 (of 5,678 total)