Viewing 15 posts - 2,821 through 2,835 (of 5,678 total)
TecheeGirl (7/6/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
July 6, 2011 at 9:40 pm
Triality (7/6/2011)
I want to match the table1.Carrier...
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
July 6, 2011 at 9:37 pm
ashkan siroos (7/5/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
July 6, 2011 at 9:31 pm
You know, it IS kind of wierd. Indexing is so central to optimal database performance yet you're right, Gail... there's nothing published as an end to end discussion of...
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
July 6, 2011 at 9:26 pm
I have learned a very simple lesson along the way...
... anytime I dread going to a specific job (not work in general, that's an unavoidable annoyance) consistently, I look to...
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
July 6, 2011 at 9:18 pm
Jeff Moden (7/6/2011)
Chris,Do you know of a way to use the rCTE to do a running total without the ID's being perfectly sequential?
There's a way using Cross Apply by taking...
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
July 6, 2011 at 9:09 pm
Jeff Moden (7/5/2011)
SwayneBell (7/4/2011)
Jeff Moden (7/2/2011)
GilaMonster (7/1/2011)
Thanks everyone. Wasn't actually planning on announcing it here.
Congratulations, Gail. This means that the top two non-employee posters for SSC have been selected...
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
July 5, 2011 at 6:09 pm
Ninja's_RGR'us (7/5/2011)
GilaMonster (7/5/2011)
Pedantic....😉 😀
Craig or me? :w00t:
That'd be me. I pulled a brainfart and thought from your response she was commenting on your stuff, not answering the question long...
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
July 5, 2011 at 5:08 pm
denis.gendera (7/5/2011)
Hi thx for the quick feedback, the solution works for values that are 'NULL'. How about empty/blank columns?
Quick and dirty? Use a NULLIF function around each column...
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
July 5, 2011 at 4:51 pm
GilaMonster (7/5/2011)
Truncate instead of delete will set the identity back to 0.
Narm?
http://msdn.microsoft.com/en-us/library/aa260621(v=SQL.80).aspx
The counter used by an identity for new rows is reset to the seed for the column.
And,...
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
July 5, 2011 at 4:46 pm
GilaMonster (7/5/2011)
Craig Farrell (7/5/2011)
[ There always seems to be one of those jokers hiding in the forum behind every high end article I've seen so far.
And half the QotD discussions...
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
July 5, 2011 at 4:30 pm
In 99% of cases, an Access query becomes a SQL Server view when upgraded. I can't remember if the exception still exists, been a long while.
sqlquest2575 (7/5/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
July 5, 2011 at 4:26 pm
What Todd recommended is about the best I could offer blindly as well. If you'd like more particular help, we're going to need some sample DDL/data to understand 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
July 5, 2011 at 4:20 pm
Tom Van Harpen (7/5/2011)
Unless you have a 3rd party job scheduler, I suggest you install the SQL Engine as well on your SSIS server and...
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
July 5, 2011 at 4:16 pm
Intel, one of my contracts along the way, apparently had an amazing sabbatical program for their researchers and technicians. You couldn't get it until you'd been there a long...
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
July 5, 2011 at 3:53 pm
Viewing 15 posts - 2,821 through 2,835 (of 5,678 total)