Viewing 15 posts - 4,771 through 4,785 (of 5,678 total)
sam.dahl (12/1/2010)
Funny thing that, we/I originally had a richer data structure but the boss wanted to keep it simple...
There's such a thing as oversimplifying if you're going to do something...
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
December 1, 2010 at 6:02 pm
david.milburn (12/1/2010)
Questions:
1) Can...
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
December 1, 2010 at 5:53 pm
sam.dahl (12/1/2010)
Yes, it's safe to assume Leave is static (one of 3 values) and also that activity is potentially anything.
Definately new column then...
If I take the suggestion of adding another...
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
December 1, 2010 at 3:41 pm
Hey, if anyone's got a disconnected sandbox they can test someone's code in, this person could use some help:
http://www.sqlservercentral.com/Forums/Topic1028937-149-1.aspx?Update=1
I don't have access to anything I can reinstall at whim 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
December 1, 2010 at 3:37 pm
artan_p (12/1/2010)
...
Did...
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
December 1, 2010 at 3:35 pm
James, has opening a dialog ever helped me... in a word: No.
It will, of course, depend highly on your management, but the higher up management you go the more likely...
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
December 1, 2010 at 3:26 pm
rockingleo (12/1/2010)
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
December 1, 2010 at 3:21 pm
Couple of 'Is it plugged in' questions here.
1) Client is onsite, not at a different location, correct? (Wrong server, or bad params for data)
2) You both look at 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
December 1, 2010 at 2:50 pm
Be careful with the above code, you want to make sure you using spacing well, and you'll want to invert the subset choices.
For example:
DECLARE @CustomerName VARCHAR(100)
SET @CustomerName = 'Bob Jocos...
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
December 1, 2010 at 2:45 pm
alen teplitsky (12/1/2010)
delete sql_server_logswhere timegenerated < getdate() - 30
and eventlog = 'Security'
Hey Alen, I know it's just an doublecheck, but the histogram above shows me something different then 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
December 1, 2010 at 2:37 pm
Stefan Krzywicki (12/1/2010)
Yes, I know, that's what I'm saying. I was trying to restate the NOT LIKE '%[^0--9]%' in english descriptions that would clarify for me exactly what it is...
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
December 1, 2010 at 11:23 am
We'd need to see the code for the trigger and the stored proc to help you with 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
December 1, 2010 at 10:52 am
FYI, works better like this:
Hierarchy - Fixed depth
Global (75)
US (85)
Industry (82)
Sub-industry (null)
...
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
December 1, 2010 at 10:41 am
You mention Activity isn't static, that's going to cause some headaches. Am I correct in assuming LEAVE is always static, but the rest of activity is things like "Modified...
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
December 1, 2010 at 10:33 am
jcrawf02 (11/29/2010)
Craig Farrell (11/29/2010)
Global warming my arse. I think I just frosted my toes off...
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
November 29, 2010 at 2:01 pm
Viewing 15 posts - 4,771 through 4,785 (of 5,678 total)