Viewing 15 posts - 1,741 through 1,755 (of 5,678 total)
Jeff Moden (2/25/2012)
It'll be so close that I can ride my unicycle to work without having to powder for chaffing. 😀
This is a YouTube video just WAITING to happen....
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
February 27, 2012 at 1:11 pm
CELKO (2/23/2012)
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
February 27, 2012 at 1:03 pm
*vivian* (2/26/2012)
The environment is a cluster. Only this node is having weird problem. Once move the SQL instance to the other node, run the query locally it is very quick.
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
February 27, 2012 at 12:44 pm
jd 67003 (2/23/2012)
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
February 23, 2012 at 4:57 pm
To your specific points.
File Watcher: I've never had much luck with this and usually just iterate the job to repeat every 5 minutes or so, with a quit successfully if...
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
February 23, 2012 at 3:49 pm
I can't find anything wrong with it visually. It seems fine. I can't test your statement in any way because it's been heavily modified (see WHERE...conditions).
Due to that,...
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
February 23, 2012 at 3:21 pm
You didn't close the statement for q and you've got an extra comma in your delimited list. It looks like the end of that line is just trimmed off.
Ignore...
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
February 23, 2012 at 3:16 pm
We're getting there. Sorry this is taking a few iterations, I know you're trying.
A few questions. While trying to slap together some very limited sample data into these...
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
February 23, 2012 at 3:10 pm
What's the error you're getting?
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
February 23, 2012 at 2:58 pm
I need to see the query to help you directly, but basically what you want is a sub-query that will grab the max timestamp for each of the 36 records...
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
February 23, 2012 at 12:35 pm
Lowell (2/22/2012)
one tells you who belongs to a group, the other can tell you all the grouls i belong to:
EXEC master..xp_logininfo
@acctname...
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
February 23, 2012 at 12:31 pm
*vivian* (2/22/2012)
The query I run returns a lot of data (50000), do you think it could because both server activites and client activites happen on this SQL Server so...
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
February 22, 2012 at 5:14 pm
What's the server set to consume for memory? The reason I ask is the client for SSMS may barely have enough room to run via RDC but your local...
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
February 22, 2012 at 5:14 pm
SQLBill (2/20/2012)
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
February 22, 2012 at 5:02 pm
ColdCoffee (2/22/2012)
Both of them wont work if the number of degrees queried is just one.
Agreed, I was answering the initially asked question of what method to use rather then providing...
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
February 22, 2012 at 3:37 pm
Viewing 15 posts - 1,741 through 1,755 (of 5,678 total)