Viewing 15 posts - 3,571 through 3,585 (of 5,678 total)
Cat, it's for both, and same purpose. In a RAID 5, for each section of disk (I forget the break out) in say a 4 disk array, 3 have...
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
March 24, 2011 at 8:56 pm
Polymorphist (3/24/2011)
Most part-time development jobs want open source knowledge such as PHP, MySQL, etc.
Primarily because most clients who use open source are either small, so they don't have...
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
March 24, 2011 at 7:59 pm
CELKO (3/24/2011)
SELECT A.column_a, A.column_b
FROM TableA AS A
LEFT OUTER JOIN
Flagged_Records AS FR
...
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
March 24, 2011 at 7:39 pm
Try this:
SELECT
drv.ClientID,
ca.*
FROM
(SELECT DISTINCT ClientID from tIdentity) AS drv
CROSS APPLY
(SELECT TOP 1
i.ClientID,
ds.DocSummaryKey,
-- picked a few random fields here, choose what you want to return...
ds.DocKey,
ds.DateExpiry
FROM
tDocSummary AS ds
JOIN
tIdentity 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
March 24, 2011 at 7:31 pm
Can you supply the ddl for the tables and a little sample data?
I was in the middle of providing a pretty quick (usually) cross apply solution, and then realized 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
March 24, 2011 at 7:06 pm
Couple of things, and no, you don't want a cursor if I understand you right.
phil.layzell (3/24/2011)
and convert(varchar(10),I1.DateExpiry,120) >= convert(varchar(10),GetDate(),120)
This can't index seek, it's considered non-SARGable, because you've wrapped DateExpiry in...
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
March 24, 2011 at 5:48 pm
The most important point first:
dji (3/24/2011)
I hope I haven't wasted anyones time with this, all the help is most appreciated.
You haven't Jake. This is an excellent example to learn...
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
March 24, 2011 at 5:43 pm
Craig Farrell (3/24/2011)
Craig Farrell (3/24/2011)
Craig Farrell (3/24/2011)
Craig Farrell (3/24/2011)
WayneS (3/24/2011)
Edit: 36 posts to go. (Watch Alvin...
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
March 24, 2011 at 5:02 pm
Craig Farrell (3/24/2011)
Craig Farrell (3/24/2011)
Craig Farrell (3/24/2011)
WayneS (3/24/2011)
Edit: 36 posts to go. (Watch Alvin post 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
March 24, 2011 at 5:01 pm
Craig Farrell (3/24/2011)
Craig Farrell (3/24/2011)
WayneS (3/24/2011)
Edit: 36 posts to go. (Watch Alvin post the next 36...
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
March 24, 2011 at 5:01 pm
Craig Farrell (3/24/2011)
WayneS (3/24/2011)
Almost at 25,000 posts here on The Thread! At today's rate, we'll hit it tonight.Edit: 36 posts to go. (Watch Alvin post the next 36 messages...)
Now,
two
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
March 24, 2011 at 5:01 pm
WayneS (3/24/2011)
Almost at 25,000 posts here on The Thread! At today's rate, we'll hit it tonight.Edit: 36 posts to go. (Watch Alvin post the next 36 messages...)
Now,
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
March 24, 2011 at 5:00 pm
A couple of first glance notes with the right query.
First, your SQLPlan, which you have to go to the XML to see this, has this problem:
<StmtSimple StatementCompId="1" StatementEstRows="89912" StatementId="1" StatementOptmLevel="FULL"...
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
March 24, 2011 at 4:58 pm
Ah hah! I must have missed that when I re-scanned the thread. That makes more sense as to his earlier observations. I do remember thinking to myself...
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
March 24, 2011 at 4:24 pm
CirquedeSQLeil (3/24/2011)
jcrawf02 (3/24/2011)
GilaMonster (3/24/2011)
Stefan Krzywicki (3/24/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
March 24, 2011 at 3:53 pm
Viewing 15 posts - 3,571 through 3,585 (of 5,678 total)