Viewing 15 posts - 2,341 through 2,355 (of 5,678 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...
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
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...
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
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?
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
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...
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
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....
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
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...
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
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? ...
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
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...
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
November 14, 2011 at 2:54 pm
michael.french 172 (11/14/2011)
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
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...
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
November 14, 2011 at 2:16 pm
jpSQLDude (11/14/2011)
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
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 =...
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
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...
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
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...
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
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...
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
November 14, 2011 at 1:38 pm
Viewing 15 posts - 2,341 through 2,355 (of 5,678 total)