Viewing 15 posts - 1,246 through 1,260 (of 5,685 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. ...
August 22, 2012 at 3:45 pm
pooyan_pdm (8/22/2012)
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...
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...
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...
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,...
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...
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. ...
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...
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...
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...
August 22, 2012 at 2:09 pm
That should be fine, are you running into an error of some kind?
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.
August 22, 2012 at 2:05 pm
Heheh, no worries.
USE OPAdmin
GO
CREATE VIEW aggTest AS ...
GO
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...
August 22, 2012 at 1:34 pm
Viewing 15 posts - 1,246 through 1,260 (of 5,685 total)