Viewing 15 posts - 3,196 through 3,210 (of 5,678 total)
Hey all, sorry I fell off the earth a bit, even when I had an article go up. Thanks for the applause those who posted, and specifically to Koen...
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
May 10, 2011 at 10:56 pm
Anipaul (5/9/2011)
Good article. I think a few more sample questions would have help the freshers more.
Anipaul, what do you mean by sample questions here? I didn't provide any sample...
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
May 10, 2011 at 10:43 pm
Craig-315134 (5/9/2011)
Good article, Craig, thank you.
Thank you, glad you enjoyed it.
I do have what I hope isn't a 'stupid question', please. To be a competent SQL Server DBA, how 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
May 10, 2011 at 10:16 pm
Peter Trast (5/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
May 10, 2011 at 10:10 pm
yan-160997 (5/9/2011)
I have been working for a financial company for over 10 years as a system analyst. During those years I have managed many SQL server both in production 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
May 10, 2011 at 10:07 pm
Insert SELECT, not insert VALUEs.
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
May 7, 2011 at 3:21 pm
Jeff Moden (5/7/2011)
Craig Farrell (5/5/2011)
Shannon, to confirm, in the end, you wanted something like this:
What I was thinking is that no Tally Table is necessary for this. I believe...
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
May 7, 2011 at 11:43 am
Jeff Moden (5/6/2011)
Shoot, I may even find a reason to use SSIS, SSAS, or SSRS someday in the future. 🙂
I take it me beating you with them until you submit...
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
May 7, 2011 at 2:11 am
Lowell (5/6/2011)
ok how about the REPLACE?
this section:
Replace(URL.URL,'{0}',RTRIM(CL.ClientID)) as LOB_CompanyRecord,
uf Url.URL has one row, but CL.ClientID has multiple rows, that oculd cause...
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
May 6, 2011 at 3:21 pm
bcampbell-1136357 (5/6/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
May 6, 2011 at 2:48 pm
dsorensen 74234 (5/6/2011)
I was hoping to avoid running a trace but, if that's the only way to get the job done I'll do it. I probably should...
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
May 6, 2011 at 2:38 pm
Easiest way for us to be able to help is to see the execution plans. If you need help pulling them, see the 'index/tuning' link in my signature.
My guess...
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
May 6, 2011 at 2:36 pm
Probably not the cleanest way, but it'll get you going. I simplified the problem a bit:
DROP TABLE #tmp
GO
CREATE TABLE #tmp (somestuff VARCHAR(50))
INSERT INTO #tmp VALUES ( 'abc')
INSERT INTO #tmp...
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
May 6, 2011 at 2:28 pm
What is the source datatype that you're extracting the information from? DATETIME?
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
May 6, 2011 at 2:21 pm
I'd ask them to supply a whitepaper or similar official item on the subject, news to me.
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
May 6, 2011 at 2:20 pm
Viewing 15 posts - 3,196 through 3,210 (of 5,678 total)