Viewing 15 posts - 2,791 through 2,805 (of 5,678 total)
SQL2k8, if the above didn't help you, can you make that into a CREATE TABLE and INSERT statement for us, so we can see exactly what you're seeing?
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 14, 2011 at 10:10 pm
Jeff Moden (7/14/2011)
Craig Farrell (7/14/2011)
Since sargability and index seeking are pretty much out the window, this should work for your join:REVERSE( RIGHT( REVERSE( AddressCode), 9)) = ID
EDIT: Misplaced a parentheses.
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
July 14, 2011 at 10:04 pm
Since sargability and index seeking are pretty much out the window, this should work for your join:
REVERSE( RIGHT( REVERSE( AddressCode), 9)) = ID
EDIT: Misplaced a parentheses.
Ignore this, massive blonde moment.
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 14, 2011 at 9:05 pm
Jim Murphy (7/14/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 14, 2011 at 9:02 pm
graham.balmer (7/14/2011)
So how do you insert rows into a partitioned view from another table when you have to reference the view to find the rows that don't exist??
Find the missing...
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 14, 2011 at 6:39 pm
Hey guys, does anyone know of boot camp training session(s) for SQL Server for practical skills (not certifications). I'm talking real basics here. I didn't see much when...
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 14, 2011 at 6:21 pm
Um, no? It's against the NDA to provide dumps, and a braindump makes you useless to us because you don't grok the material.
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 14, 2011 at 5:39 pm
Just an odd question, why would you do this?
If you're licensing by processors, like most do, and you're sharing space on the same system, you most likely have licensed 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 14, 2011 at 3:02 pm
Eric M Russell (7/14/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 14, 2011 at 1:05 pm
Eric M Russell (7/14/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 14, 2011 at 12:31 pm
You've looked at the software, now time to investigate the hardware.
There are four bottlenecks: Network, CPU, Memory, and Disk.
Network is unlikely here.
CPU is possible, especially if you're in VMs.
Check your...
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 14, 2011 at 12:30 pm
I'd have to say I'm middle of the road for RI. I don't use it for every lookup under the sun, simply because of the secondary hits that are...
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 14, 2011 at 12:21 pm
The old Raid 5 reads faster then 10 debate got squashed a bit ago. It's no longer the amazing gain it used to be. This is twofold. ...
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, 2011 at 1:35 pm
bopeavy (7/12/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 12, 2011 at 1:27 pm
dhearne 25776 (7/9/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 9, 2011 at 5:39 pm
Viewing 15 posts - 2,791 through 2,805 (of 5,678 total)