Viewing 15 posts - 2,041 through 2,055 (of 5,678 total)
WangcChiKaBastar (1/3/2012)
I dropped the trigger but when I delete a record...
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
January 3, 2012 at 3:23 pm
Check to see if you merely unpinned it, or overlapped it.
Is it in a grey bar on the left side of the object explorer, or in a tab 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
January 3, 2012 at 2:19 pm
No, there isn't. SQL Server always logs. There isn't a 'nologging' option for a database either, it's just a simpler mode where it'll re-use existing log space once...
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
January 3, 2012 at 2:12 pm
Any chance you've got the Deadlock Graph handy?
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
January 3, 2012 at 1:57 pm
Right idea Sean but I believe he'll need to use a derived column instead, since I'm assuming he's using SSIS. Can replace the existing but I usually prefer 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
January 3, 2012 at 1:54 pm
Brandie Tarvin (1/3/2012)
RFIDS exist today, so I'm not sure how that's jumping the shark.
"I just ate at Whattaburger!" I mean seriously, they're tossing them in food for advertising assistance...
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
January 3, 2012 at 1:40 pm
You're right, it doesn't, I was just trying to be thorough.
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
January 3, 2012 at 12:41 pm
And then there's me, who's a DB Developer and not a front-end guy, and I build the back end architecture.
Why don't I usually use constraints except in "absolute, must 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
January 3, 2012 at 12:30 pm
Brandie Tarvin (1/2/2012)
Evil Kraig F (12/30/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
January 3, 2012 at 12:23 pm
My favorite RPG of all time was Shadowrun. 2nd Edition. I recently tried to GM a campaign (well, recently being a year and a half ago) in 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 30, 2011 at 11:24 am
I had a full head of steam going early last year in my self-training for the MCM, blogs, got a few articles up here, etc... and realized I just tried...
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 30, 2011 at 11:17 am
bwagner 90365 (12/29/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
December 29, 2011 at 5:19 pm
drew.allen (12/29/2011)
Evil Kraig F (12/29/2011)
I wouldn't do this with Row_Number
I would use Row_Number, because using MAX() in a subquery has the possibility of duplicate values if there are multiple 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
December 29, 2011 at 3:31 pm
crookj (12/29/2011)
Ray K (12/29/2011)
Evil Kraig F (12/29/2011)
crookj (12/29/2011)
WOTD - stodgyWaldorf (Muppets)
Statler
Flowers on the Wall
Gonzo in the Cannon.. then the wall... then the roof... then the clouds... and another wall... random...
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 29, 2011 at 1:59 pm
I wouldn't do this with Row_Number, I'd approach it this way:
SELECT
elx.*
FROM
dbo.esg_ldc_xref AS elx
JOIN
(SELECT
Account_Number,
MAX(End_Date) AS MaxEndDate
FROM
dbo.esg_ldc_xref
GROUP BY
Account_number
) AS drv
ONelx.Account_number = drv.Account_number
AND elx.end_date = drv.End_Date
WHERE
customer_tkn in ( 56134996 , 90640028, 92448615)
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 29, 2011 at 1:50 pm
Viewing 15 posts - 2,041 through 2,055 (of 5,678 total)