Viewing 15 posts - 1,771 through 1,785 (of 5,678 total)
ColdCoffee (2/16/2012)
1. Create a new database in another server with only one table that matches your source table
2. BCP out data from your source table to a file
3....
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
February 16, 2012 at 5:51 pm
Can you help us understand your intent? It looks like you're trying to overload a single column to mean foreign and scholarship. Why would you do that when...
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
February 16, 2012 at 4:46 pm
SQLKnowItAll (2/16/2012)
jake.mayher (2/16/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
February 16, 2012 at 2:53 pm
Ah, thanks J.
Lost, just an FYI, your code doesn't run well. You've mixed and matched #table and hard tables in there. No worries, I realize you're new, we...
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
February 16, 2012 at 2:44 pm
In full recovery mode minimal logging is out.
You'll have to include backups into your process. Do a delete, backup the log. Perform an insert, backup the log. ...
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
February 16, 2012 at 1:01 pm
Hey Lost. Easiest ways are either using a Tally Table if you had one handy, or a quick and dirty Row_Number() function.
Is it possible you can setup that sample...
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
February 16, 2012 at 12:56 pm
Jeff Moden (2/13/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
February 16, 2012 at 12:34 pm
Avoiding the overseas sub-topic...
I'm there now, I'm on a project that hit an oil slick and is at warp 12. Most of it's due to network kablewies during long...
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
February 16, 2012 at 12:26 pm
Brandie Tarvin (2/16/2012)
Evil Kraig F (2/15/2012)
Brandie Tarvin (2/15/2012)
bitbucket-25253 (2/15/2012)
Brandie Tarvin (2/15/2012)
bitbucket-25253 (2/15/2012)
Brandiego here
HA! That's exactly what I need. Thanks. @=)
Now, now be honest is it the chocolate or 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
February 16, 2012 at 12:20 pm
Another +1 for a good question. I got it right by sheer luck. I ignored the trailing semicolon bit earlier, mostly because I always forget them anyway... *blush*.
Seriously...
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
February 15, 2012 at 5:30 pm
Was the sp_executeSQL statement parameterized? It might be caching a bad plan the same way bad parameter sniffs affect queries. This would be my most likely assumption. ...
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
February 15, 2012 at 5:18 pm
SQLKnowItAll (2/15/2012)
More...
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
February 15, 2012 at 3:12 pm
Using Dynamic SQL is an excellent choice for removing the pain point from catchall search queries like this one.
For one of the most effective discussions on it, review this link...
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
February 15, 2012 at 3:10 pm
sql.kishore1 (2/15/2012)
can you please help me to fix the issue with this Query
What is the issue? EDIT: Before you ask, no, I didn't run it to see. I...
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
February 15, 2012 at 3:04 pm
jarid.lawson (2/15/2012)
Now that all of the back story is out, here are my questions. Does SSIS have a way of accounting for multiple file names?
The ForEach loop can handle looping...
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
February 15, 2012 at 3:02 pm
Viewing 15 posts - 1,771 through 1,785 (of 5,678 total)