Viewing 15 posts - 706 through 720 (of 5,678 total)
Not sure we'll be able to help you by close of business but I have a concern. I know substring is the core function and left/right are just wrappers,...
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
April 30, 2013 at 5:12 pm
J Livingston SQL (4/30/2013)
Hi Craig.......run on my laptophope this helps
kind regards
It does J, thanks. It shows that even though you got huge outliers just like above, the ratios stayed...
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
April 30, 2013 at 3:14 pm
Calibear (4/29/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
April 30, 2013 at 11:49 am
ChrisM@Work (4/30/2013)
Test 1, Test 2 and Test 3 are slight variations of the base code, since the performance difference isn't particularly significant I'll not post unless someone requests.
Notice how much...
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
April 30, 2013 at 11:46 am
Mark-101232 (4/30/2013)
Results from 2012 SP1Cascade Test131824601220
CASE Test123823501150
Values Test6011016503
Appreciate the time Mark. Would you be willing to rerun with the harness in the fourth post? After Mr. Magoo brought...
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
April 30, 2013 at 11:44 am
Because of Mr. Magoo's confusion as to my use case, I want to present an idea of the use case. It's not the one in question but that'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
April 29, 2013 at 7:08 pm
mister.magoo (4/29/2013)
Evil Kraig F (4/29/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
April 29, 2013 at 6:59 pm
mister.magoo (4/29/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
April 29, 2013 at 6:32 pm
Grant Fritchey (4/29/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
April 29, 2013 at 5:52 pm
Slightly confused, does this not work?
SELECT
YEAR( Enter_Date) AS yr,
MIN( C_Key) AS MinKey,
MAX( C_Key) AS MaxKey
FROM
Sometable
GROUP BY
Year( Enter_Date)
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
April 29, 2013 at 4:21 pm
Hey guys, asking for a bit of guru inpsection over on this thread I just created:
http://www.sqlservercentral.com/Forums/Topic1447802-392-1.aspx
Basically it's a test harness to try to figure out the most optimal approach 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
April 29, 2013 at 4:16 pm
I'd like to mention here that typically when encrypting like this you store the data one place, the keys in another.
In general I'd have the N-Tier control the encrypt/decrypt, 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
April 29, 2013 at 2:13 pm
john.p.lantz (4/26/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
April 26, 2013 at 6:50 pm
SQLKnowItAll (4/26/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
April 26, 2013 at 4:17 pm
Jared, something else you might think of using is an in-database broker queue, which allows you to queue up asynchronous updates like this and have a built in wrapper for...
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
April 26, 2013 at 3:52 pm
Viewing 15 posts - 706 through 720 (of 5,678 total)