Viewing 15 posts - 2,326 through 2,340 (of 5,685 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...
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,...
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...
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...
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...
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. ...
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...
November 15, 2011 at 12:11 pm
Pam Brisjar (11/15/2011)
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...
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...
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...
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
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...
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...
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.
November 15, 2011 at 10:27 am
Viewing 15 posts - 2,326 through 2,340 (of 5,685 total)