Viewing 15 posts - 1,816 through 1,830 (of 5,678 total)
My sincere apologies to those of you who have done counter-myth articles of this nature. I meant to say no OFFICIAL documentation on recovery mode associations, but there are...
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
February 6, 2012 at 11:19 am
goodluck (2/3/2012)
Does having a row_overflow_data in the allocation unit on a partition table not create indexes properly?
Not that I'm aware of... why do you ask, what problems are you seeing?
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
February 3, 2012 at 2:02 pm
snigdhandream (2/2/2012)
Thanks for your replies. I will make the scenario little bit clear...
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
February 3, 2012 at 1:37 pm
Use a subquery grouping on customer number grabbing maxDate. Join that subquery back to the main table as a restriction so you only pull the last record per customer.
If...
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
February 3, 2012 at 1:13 pm
cengland0 (2/3/2012)
Gary Varga (2/3/2012)
cengland0 (2/3/2012)
What? Not using stored procedures!!!
Good question and one I'm glad you asked.
I'm the DBA on several databases, others I'm not. For those that I'm not...
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
February 3, 2012 at 11:57 am
Huge question, short answer: You need to look into disaster recovery. There's articles, blogs, discussions, and methods in abundance, but no piece of the topic is a 'quick'...
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
February 2, 2012 at 4:48 pm
Revenant (2/2/2012)
Evil Kraig F (2/2/2012)
Revenant (2/2/2012)
jcrawf02 (2/2/2012)
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
February 2, 2012 at 4:15 pm
On the particular point of columnAlias = Somestuff, I dislike it particularly for larger queries.
They look like where clauses, or joins, to me when I'm scanning large scripts. An...
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
February 2, 2012 at 3:41 pm
GilaMonster (2/2/2012)
Evil Kraig F (2/2/2012)
GilaMonster (2/2/2012)
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
February 2, 2012 at 3:31 pm
Dave Brooking (2/2/2012)
Paul,Take a look at http://msdn.microsoft.com/en-us/library/hh231256(v=sql.110).aspx. Unfortunately, I don't have 2012 installed. However I have used LAG and LEAD with an Oracle database previously.
Dave
Very interesting, thanks 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
February 2, 2012 at 3:29 pm
paulgill (2/2/2012)
Seems to do what I am wanting.Definitely open to a better way!
I'm afraid I have almost no understanding of LAG and LEAD, however, this isn't an uncommon scenario....
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
February 2, 2012 at 3:27 pm
Revenant (2/2/2012)
jcrawf02 (2/2/2012)
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
February 2, 2012 at 3:22 pm
GilaMonster (2/2/2012)
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
February 2, 2012 at 3:21 pm
homebrew01 (2/2/2012)
If it's going to a different server then you...
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
February 2, 2012 at 3:12 pm
josetur12 (2/2/2012)
Kraig,your sample code works.Thank you.
My pleasure. Good luck. 🙂
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
February 2, 2012 at 12:45 pm
Viewing 15 posts - 1,816 through 1,830 (of 5,678 total)