Viewing 15 posts - 4,156 through 4,170 (of 5,685 total)
palpacino (2/3/2011)
February 3, 2011 at 4:19 pm
tfifield (2/3/2011)
I'll try to look up my bench mark tests on this. I seem to recall that the case where ROW_NUMBER() would beat the CROSS APPLY/TOP 1 construct was...
February 3, 2011 at 4:14 pm
The reason that didn't work is you have a select statement before the metadata definition.
SELECT @Dummy = COUNT(*) FROM sys.tables
The first statement that isn't a set of some kind in...
February 3, 2011 at 3:56 pm
Steve Jones - SSC Editor (2/3/2011)
I rarely delete stuff, but that one went so sideways, with almost no technical info, that I decided to whack it.
Probably for the best. ...
February 3, 2011 at 3:53 pm
You're displaying the results as text, not grid, right?
Grid turns CHAR(10) and (13) into hidden characters... and a little testing on my part shows Lutz was right in the first...
February 3, 2011 at 3:39 pm
nbussel (2/3/2011)
@LutzM Thanks for your replyI have tested your suggestion and this gives me the output:
a b c
However I wanted the output to be:
a
b
c
It's this part: CHAR(13))
You want CHAR(10)...
February 3, 2011 at 3:15 pm
palpacino (2/3/2011)
I guess I was under the impression that this could...
February 3, 2011 at 3:12 pm
Mike, are there more senior DBAs on staff, or did you get volunteered to the position because noone else will do it? The reason I ask is to know...
February 3, 2011 at 3:09 pm
SanDroid (2/3/2011)
I was reading someplace that in MS SQL, the leaf level of a nonclustered index contains the clustered key columns that point back to the clustered index...
February 3, 2011 at 2:57 pm
The column in this you care about is 'Final Removal'.
I broke it down so you can see what each component of the function is doing.
Please test and confirm this will...
February 3, 2011 at 2:52 pm
nbussel...
Curious, the only time I know I've ever wanted my DB to do this work was when I had to feed a file for a mainframe consumption. Is that...
February 3, 2011 at 2:07 pm
How about just moving the date around to work within standard functionality?
Basically, take 3 months off an April date, for sorting purposes only, and make the system think that's january.
So,...
February 3, 2011 at 2:01 pm
Is this question highly simplified?
The reason I ask is a WHERE clause for where the status = 2 will return you your order ID's that have a 2 ( or...
February 3, 2011 at 1:58 pm
will s (2/2/2011)
TRAN LOGS:
- Will moving the tran logs from a 6-spindle RAID 5 to a 2-spindle RAID 1 actually slow writes down overall?...
February 3, 2011 at 1:39 pm
What Devesh posted above is the workaround. The reason is that SSIS wants to build out metadata, and it will use the first SQL statement of any kind in...
February 3, 2011 at 1:23 pm
Viewing 15 posts - 4,156 through 4,170 (of 5,685 total)