Viewing 15 posts - 586 through 600 (of 5,678 total)
Revenant (7/12/2013)
I suggest we relegate this to a separate topic, if anyone wants to dwell into it. I do not.</rant>
Fair enough Rev.
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 13, 2013 at 3:46 pm
L' Eomot Inversé (7/12/2013)
Evil Kraig F (7/12/2013)[hrFrustration in the southwest due to a horribly porous border (that isn't supposed to be, like the one with Canada). Most of our...
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 12, 2013 at 7:11 pm
Steve Jones - SSC Editor (7/12/2013)
L' Eomot Inversé (7/12/2013)
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 12, 2013 at 5:39 pm
Glad to know this article is still helping people out. 🙂
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 12, 2013 at 1:58 pm
It's failing during the metadata check in the pre-compile, not during actual runtime. This is usually ran into when you're dealing with altered #tmp tables in repeated script runs...
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 2, 2013 at 6:00 pm
You're on target Luis. It's a CHARINDEX and right command usage confusion.
OP, let's say you have this:
1234|1234567890
CHARINDEX (|) will = 5.
When you RIGHT(string,5) you get 67890.
What you need 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 2, 2013 at 5:57 pm
First, I'd start with the basics... have you done a maintenance run for index rebuilds and statistics updates? Your messing with maxdop allows queries to recompile. Something may...
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 2, 2013 at 5:52 pm
Lynn Pettis (7/1/2013)
I made it to Bagram last night but looks like I get to hang out here another day (at...
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 2, 2013 at 10:47 am
I agree with David here, since it's a relatively simple paradigm and a direct order of evaluation you've got. Anything more complex would be overkill, as well as non...
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 1, 2013 at 5:53 pm
Aaron,
Just in case you're not aware, best practice when allowing adhoc queries is to enforce usage of sp_executeSQL, because you can parameterize it and avoid injection attacks that way without...
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
June 25, 2013 at 3:44 pm
bill.lawler (6/21/2013)
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
June 21, 2013 at 4:04 pm
Sean,
It's an orgchart chain with the upper root level removed. You want to find the sublevel's highest association. Highest Association is decided by the lowest ID.
I just wanted...
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
June 21, 2013 at 1:30 pm
Dird (6/21/2013)
At work today I noticed that most of our SQL Server environments have the same setup:
2 disks in RAID 1
4 disks in RAID 5
The database config also follows this...
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
June 21, 2013 at 1:27 pm
ekant,
If you continue to get stuck, one of the things that will help us the most is the .sqlplan. If you take a look in my sig, there's a...
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
June 21, 2013 at 1:18 pm
DKG-967908 (6/20/2013)
Being a DB Admin can we do something from the SQL server end? if so please can you point out all the suggestions.
Don't allow ad-hoc querying and restrict 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
June 21, 2013 at 11:18 am
Viewing 15 posts - 586 through 600 (of 5,678 total)