Viewing 15 posts - 211 through 225 (of 5,678 total)
Jeff Moden (7/22/2014)
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 22, 2014 at 2:59 pm
Jeff Moden (7/21/2014)
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 21, 2014 at 11:15 pm
mister.magoo (7/21/2014)
Sure Craig, that sounds reasonable, but is that what is happening here?
I usually assume things like this are simplified versions of much larger concerns. Not everyone's comfortable posting...
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 21, 2014 at 6:14 pm
mister.magoo (7/21/2014)
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 21, 2014 at 6:00 pm
Derive the column after the conversion and prepend the 0x.
DT_BYTES has a max length of 8000, which won't handle your MAX. Since there's a single binary value you shouldn'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
July 21, 2014 at 5:54 pm
Sorry Goofy, but I have to disagree with the overall preference with your company. I believe a local power user and/or IT resource to allow for business developed small...
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 21, 2014 at 4:55 pm
Do you have monitoring, baselining for problem comparisons, restore tests, and optimization reviews already in place? If not, you've got your work cut out for you. Best 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 21, 2014 at 4:47 pm
Hit up the second link down in my signature (index/tuning help). It'll show you how to snag and attach the execution plan (actual is preferred). We'll need that...
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 21, 2014 at 4:45 pm
Reports and/or traces on long running and/or high I/O queries. Mark for review and optimization.
Perfmon bottlenecking. Try to find out if it's memory pressure, CPU pressure, I/O pressure,...
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 21, 2014 at 3:37 pm
ranmazure (7/21/2014)
1) Do we 'have' to be SOX compliant? Most of what I read talks about corporations and businesses. What about...
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 21, 2014 at 3:26 pm
Steve Jones - SSC Editor (7/21/2014)
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 21, 2014 at 2:37 pm
@patricia-2 Hartman: Well spoken and described.
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 21, 2014 at 2:31 pm
If you'd like an idea of how last unread is implemented rather well, check out the Dwarf Fortress forums on Bay12.
http://www.bay12forums.com/smf/
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 21, 2014 at 1:13 pm
You wouldn't use rowversion via tempdb, not really.
What you'd do is in your CRUD proc, you'd have an additional parameter of, say, @oldRV. You'd then open a two stage...
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 18, 2014 at 5:57 pm
Lynn, curiousity, why wouldn't you set that to 4,500 rows instead of 10k to avoid table lock escalation?
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 18, 2014 at 4:35 pm
Viewing 15 posts - 211 through 225 (of 5,678 total)