Viewing 15 posts - 2,026 through 2,040 (of 5,678 total)
Chuck Hottle (1/5/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
January 5, 2012 at 1:04 pm
One of the things we almost have to discuss is issues and problems. The trick is who are you throwing under the bus when you discuss it.
If for example...
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
January 5, 2012 at 12:58 pm
Greg J (1/5/2012)
I'm attaching a screeny of the resource monitor's take on memory which is why I originally said it's not taxed.
Also, I saw on the "output"...
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
January 5, 2012 at 11:46 am
Gianluca Sartori (1/4/2012)
Koen Verbeeck (1/4/2012)
Did I...
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
January 5, 2012 at 11:31 am
fabulous617 (1/5/2012)
Ex.
-What I have:
[Column1]
123456.00000
.12345
...
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
January 5, 2012 at 11:23 am
Steve Jones - SSC Editor (1/4/2012)
It should be 12 Monkeys - http://www.imdb.com/title/tt0114746/
Isn't that dodecagibbon? Or is that Dodecachimpie?
@tom: ROFL. 😎
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
January 5, 2012 at 11:17 am
ChrisM@home (1/4/2012)
Have you tried using MERGE for the upsert, instead of your current two-stage process?Shredding XML isn't instant - you may gain by separating this from the table changes too:
Good...
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
January 5, 2012 at 11:14 am
Side note. This analytical software sounds like something you'd usually do in SSAS if you were just using SQL Server tools. You build cubes overnight to see trends...
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
January 5, 2012 at 11:11 am
Greg J (1/5/2012)
just added the perfmon screeny... looks like there are quite a few page faults happening. Does this help? Other counters you'd like to see?
Yep, page...
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
January 5, 2012 at 11:04 am
What's your clustered index? That's the important part here. I notice you mention no PK but that's not necessarily the same thing.
If you don't have indexing going you're...
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
January 3, 2012 at 5:31 pm
clintonG (1/3/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
January 3, 2012 at 5:24 pm
Are you dealing with a hosting provider? If so, you'll need to talk to them. You won't have access to the tools you'll need.
If not, you rarely (preferably never)...
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
January 3, 2012 at 3:43 pm
What's this Exademon... err... Hexawitch... err.. Hexademinali stuff?
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
January 3, 2012 at 3:40 pm
Open this page:
http://msdn.microsoft.com/en-us/library/ms189826(v=sql.90).aspx
The list on the left is relatively complete. It's missing a few things like MERGE and INTERSECT, but it'll get you started at least. I don't...
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
January 3, 2012 at 3:30 pm
Have them look for connection objects that open transactions auto-magically for them as well. I ran into this a while back where my devs swore up and down they...
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
January 3, 2012 at 3:27 pm
Viewing 15 posts - 2,026 through 2,040 (of 5,678 total)