Viewing 15 posts - 586 through 600 (of 629 total)
Jeff Moden (10/3/2008)
Andrew Gothard (10/3/2008)
...it's a snakepit of cursors and totally unnecessary temp tables and runs forever?
You just described the code at my new job... 😛 except instead of...
October 4, 2008 at 3:36 pm
Jeff Moden (10/2/2008)
Andrew Gothard (10/2/2008)
J (10/2/2008)
For my taste, I find this harder to read (mid-50 eyesight and all), it requires more attention to figure out the meaning of the name....
October 4, 2008 at 3:08 pm
Have you tried running profiler? If you do and post the results this may give us more to go on
October 4, 2008 at 2:52 pm
What defines whether or not the file is invalid?
September 24, 2008 at 6:58 am
Are you running a process loading a table based upon a view on the same table? If so, make sure that the bulkload option's set off.
It'd be worth using...
September 22, 2008 at 2:04 pm
Have you thought of using a multicast and assigning the value for each destination by using a script task? If, on the other hand, you have a dynamic number...
September 22, 2008 at 1:55 pm
rbarryyoung (9/19/2008)
Jeff Moden (9/18/2008)
What ever possesed you to join the darkside?You don't know the power of the darkside!
😀
Oh I do. Worked in an Oracle shop for a bit and...
September 21, 2008 at 6:09 am
GilaMonster (8/15/2008)
Who ever said type completely by hand?
Not you, I'm sure - I do know people who have that attitude, though
Management studio can generate all sorts of stubs for...
August 15, 2008 at 9:13 am
Yeah, that's the View/Query Designer. It's awful and NO ONE should EVER use it. (there's another one of those rules, again)
Sorry - totally disagree. Give me one good...
August 15, 2008 at 7:59 am
GSquared (8/14/2008)
andrew gothard (8/12/2008)
August 15, 2008 at 7:51 am
scottw (8/14/2008)
Nailed It! Thanks much
glad to help
August 15, 2008 at 7:37 am
I tested this out on SQL 2005, using management studio. I created the following monstrosity of bad layout:
CREATE VIEW PerverseLayout AS
SELECT
[name], ...
August 14, 2008 at 8:16 am
If this doesn't help, can you post a little more detail? Jack Corbetts sig gives a link to a good guide to the type of info that's helpful
http://sqlblogcasts.com/blogs/jorg/default.aspx
hth
Andrew
August 14, 2008 at 7:09 am
See http://support.microsoft.com/kb/935897
A GDR is a general release which MS reckon should be installed - or is important enough to be installed - on any live SQL Server instance. QFE's...
August 13, 2008 at 4:59 pm
Viewing 15 posts - 586 through 600 (of 629 total)