Viewing 15 posts - 1,246 through 1,260 (of 5,678 total)
sqlfriends (8/22/2012)
Thanks, so I still cannot get a better improved solution?
Without query, underlying schema, and sqlplan? Nope. You've gone from general methodology to a particular solution's optimization. ...
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
August 22, 2012 at 3:45 pm
pooyan_pdm (8/22/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
August 22, 2012 at 3:27 pm
GilaMonster (8/22/2012)
Evil Kraig F (8/22/2012)
GilaMonster (8/22/2012)
Minimal logging and bulk-logged recovery model: http://www.sqlservercentral.com/articles/Recovery+models/89664/ERG, BAD CRAIG! Giving out bad information again. :blush:
Err, you did? Where?
Okay, overreaction... Incomplete information. :hehe:
59...
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
August 22, 2012 at 3:02 pm
Edit: Damned quote bug...
sqlfriends (8/22/2012)
Evil Kraig F (8/22/2012)
sqlfriends (8/22/2012)
can I use isnull(student.mailingaddress,'')<>isnull(esis.mailingaddress,'')Yep, that's the usual workaround, just realize the entire query will be non-SARGable.
I would like my query to be...
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
August 22, 2012 at 2:58 pm
GilaMonster (8/22/2012)
Minimal logging and bulk-logged recovery model: http://www.sqlservercentral.com/articles/Recovery+models/89664/
ERG, BAD CRAIG! Giving out bad information again. :blush: My brain's jumping important pieces of information, sorry bout that.
Alright, Gail's quite...
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
August 22, 2012 at 2:55 pm
Cory Blythe (8/22/2012)
Hi,Easily confused here, I am trying to determine if using BCP to import a large amount of data into a table breaks the log chain?
To second Lynn above,...
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
August 22, 2012 at 2:39 pm
There's another approach. If the config file is non-existant it goes back to the design time values for the variables that are being configured. Make sure those are...
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
August 22, 2012 at 2:37 pm
That's most likely because of your select * from statement.
State the exact columns you want from both the local #tmp and the Openquery aliases to feed into the insert. ...
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
August 22, 2012 at 2:32 pm
@david-2: I agree that if you're warehousing and doing ETL work that you would prefer that approach to keep load down and keep it optimal, but I figured this isn'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
August 22, 2012 at 2:30 pm
There are third party Flat File connectors (I believe one of the keywords is "mutable source") but there is nothing in SSIS standard that allows for it. You either...
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
August 22, 2012 at 2:28 pm
The first column of the merged cells is the only 'data column' the data will arrive in. This is normal. It will not repeat data across each of...
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
August 22, 2012 at 2:09 pm
That should be fine, are you running into an error of some kind?
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
August 22, 2012 at 2:07 pm
sqlfriends (8/22/2012)
can I use isnull(student.mailingaddress,'')<>isnull(esis.mailingaddress,'')
Yep, that's the usual workaround, just realize the entire query will be non-SARGable.
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
August 22, 2012 at 2:05 pm
Heheh, no worries.
USE OPAdmin
GO
CREATE VIEW aggTest AS ...
GO
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
August 22, 2012 at 2:04 pm
Alan Kwan (8/22/2012)
Cool, this might be the solution. Two questions,1) I followed your sql, the command executed successfully, but I can't seem to find it, where is the view stored?
If...
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
August 22, 2012 at 1:34 pm
Viewing 15 posts - 1,246 through 1,260 (of 5,678 total)