Viewing 15 posts - 2,341 through 2,355 (of 5,685 total)
Remi, Filtered Indexes run on a similar component to the partition choices of what indexes to use, aligned or non-aligned, as far as I know.
If the query isn't sure it's...
November 15, 2011 at 10:23 am
Laziness is joy and what else are you going to do in the extra 20 seconds? Besides, two more button pushes is HARD work.
At least they're not burning the...
November 15, 2011 at 10:01 am
coronaride (11/14/2011)
Yes, and it wouldn't compile.
What error did you receive when attempting to do a forced index retrieval?
November 15, 2011 at 12:11 am
Hey folks, calling in backup on this one, I don't know what else to ask him to try to nail down the cause. It's a text file where the...
November 14, 2011 at 4:04 pm
michael.french 172 (11/14/2011)
Screen Shot Attached and the error output is set to fail componentRaw Data Here:
2011050UNKNOWN
2011054WEDNESDAY
2011055THURSDAY
2011056FRIDAY
2011053TUESDAY
2011052MONDAY
2011057SATURDAY
2011051SUNDAY
My apologies. I'm afraid I no longer have a clue what's wrong with this....
November 14, 2011 at 4:02 pm
Bouben (11/14/2011)
I will take my time and make an in-depth research of what you have written so far.
To be honest, this is a...
November 14, 2011 at 3:11 pm
Ah, sorry, didn't realize that was your editor's output instead of the raw data in the file.
Can you post a screenshot of the advanced tab in the flatfile editor? ...
November 14, 2011 at 3:03 pm
learnsql84 (11/14/2011)
Thanks for the reply guysI got a simple way out for it
SELECT convert(varchar, EndDateTime- StartDateTime, 114) FROM Yourtablename
O/p will be :00:00:22:277
It works, but it...
November 14, 2011 at 2:54 pm
michael.french 172 (11/14/2011)
November 14, 2011 at 2:30 pm
michael.french 172 (11/14/2011)
When I open the file in a Hex editor, I do see a line feed character {0A}, but that is all.
Does it match end of row for the...
November 14, 2011 at 2:16 pm
jpSQLDude (11/14/2011)
November 14, 2011 at 2:13 pm
Use DATEDIFF in seconds, then do some math. Note the use of integers for the division to keep it in whole numbers.
IE:
DECLARE @DT1 DATETIME,
@DT2 DATETIME
SELECT@DT1 = '20100101 10:30:45',
@DT2 =...
November 14, 2011 at 2:06 pm
Bouben (11/13/2011)
I have got two questions.
The first question:
Is it possible in SQL Server 2005 to have it automatically update a value from a previous row into a next row...
November 14, 2011 at 1:57 pm
TravisDBA (11/14/2011)
djackson 22568 (11/11/2011)
First impressions are almost always wrong.Not always.:-D
True, I actually am insane. I'm just the friendly kind. 😉
Of course you have to be willing...
November 14, 2011 at 1:46 pm
Open it up in Notepad++ or something similar and confirm the last End of Row/End of File operators are there.
I've seen this before in mainframe outputs that directly include CR/LFs...
November 14, 2011 at 1:38 pm
Viewing 15 posts - 2,341 through 2,355 (of 5,685 total)