Viewing 15 posts - 2,671 through 2,685 (of 5,678 total)
Let me break that down to what I think I understood. I'm going for the simplest format:
1) Find all accounts with a transaction on a date.
2) For that account,...
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
August 16, 2011 at 4:05 pm
goodguy (8/16/2011)
Anyone home?
Yes and no. Not a small order to contemplate, and in-depth work at the architecture level is usually paid well for. 😉
First off, it sounds like what...
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
August 16, 2011 at 3:59 pm
tonyppham (8/16/2011)
Evil Kraig F (8/16/2011)
tonyppham (8/16/2011)
Do you know if it's possible with SQL Server 2005 Express since it doesn't have Agent Service?
You can arrange something using the windows scheduler instead,...
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
August 16, 2011 at 1:48 pm
Are these DML statements constantly morphing, or are they pretty much the same structure with different parameters?
If they're the same structure, have you looked into Service Broker? Pretty 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
August 16, 2011 at 1:46 pm
Correct, and this is the older syntax for joins.
Old way:
SELECT *
FROM tblA AS a, tblB AS b
WHERE
a.Col1 = b.Col1
Is equivalent to:
SELECT *
FROM ...
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
August 16, 2011 at 12:16 pm
tonyppham (8/16/2011)
Do you know if it's possible with SQL Server 2005 Express since it doesn't have Agent Service?
You can arrange something using the windows scheduler instead, but it's not as...
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
August 16, 2011 at 12:14 pm
Michael Valentine Jones (8/16/2011)
However, when you add 3 months to November 30, it will return Feb 28 (or...
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
August 16, 2011 at 12:12 pm
quillis131 (8/16/2011)
Evil Kraig F (8/15/2011)
quillis131 (8/15/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
August 16, 2011 at 12:10 pm
Jeff Moden (8/16/2011)
========== DATEADD/DATEDIFF ==========
SQL Server Execution Times:
CPU time = 1326 ms,...
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
August 16, 2011 at 11:01 am
quillis131 (8/15/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
August 15, 2011 at 7:45 pm
Chuck Hottle (8/15/2011)
This is good and simple too.SELECT CAST(FLOOR(CAST(GetDate() AS FLOAT)) AS DATETIME)
I was originally going to call this a bad idea, but I decided a little sample million row...
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
August 15, 2011 at 5:14 pm
Steve Jones - SSC Editor (8/15/2011)
Craig,
It's not inaccurate. You can sit for the test without having the certs. Multiple people, including myself have done it. You can't get awarded 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
August 15, 2011 at 4:51 pm
Yeah, this won't be pretty, if I've understood this right.
Your VARCHAR(MAX) is storing standard ASCII coding, but also html tags and the like. Here's a problem with that:
<a>ABC</a> 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
August 15, 2011 at 4:48 pm
Jeff Moden (8/15/2011)
You might want to check again... what happens on May 31st?
I'm confused here Jeff, nothing bad happens on May 31 + 3 months. August 31st is 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
August 15, 2011 at 4:37 pm
chandleya (8/15/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
August 15, 2011 at 4:32 pm
Viewing 15 posts - 2,671 through 2,685 (of 5,678 total)