Viewing 15 posts - 1,816 through 1,830 (of 5,685 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...
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?
February 3, 2012 at 2:02 pm
snigdhandream (2/2/2012)
Thanks for your replies. I will make the scenario little bit clear...
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...
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...
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'...
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)
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...
February 2, 2012 at 3:41 pm
GilaMonster (2/2/2012)
Evil Kraig F (2/2/2012)
GilaMonster (2/2/2012)
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...
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....
February 2, 2012 at 3:27 pm
Revenant (2/2/2012)
jcrawf02 (2/2/2012)
February 2, 2012 at 3:22 pm
GilaMonster (2/2/2012)
February 2, 2012 at 3:21 pm
homebrew01 (2/2/2012)
If it's going to a different server then you...
February 2, 2012 at 3:12 pm
josetur12 (2/2/2012)
Kraig,your sample code works.Thank you.
My pleasure. Good luck. 🙂
February 2, 2012 at 12:45 pm
Viewing 15 posts - 1,816 through 1,830 (of 5,685 total)