Viewing 15 posts - 5,296 through 5,310 (of 5,678 total)
David Portas (10/13/2010)
I doubt that a password would be a key. Most systems that I know of don't require passwords to be unique.
You're right, it was a bad example of...
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
October 13, 2010 at 3:32 pm
David Portas (10/13/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
October 13, 2010 at 2:53 pm
keith.gerritsen (10/13/2010)
abc def jkl mno ...
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
October 13, 2010 at 2:44 pm
I bounce through a LOT of shops, and here's some average numbers I've seen at successful shops. Mind, this comes under the topic of 'What is a DBA' 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
October 13, 2010 at 2:41 pm
Soulfly73 (10/13/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
October 13, 2010 at 2:26 pm
WayneS (10/13/2010)
You need to look at the MIN, MAX and COUNT functions, as well as the GROUP BY clause of the SELECT statement.
He's going to need a self-referencing CTE for...
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
October 13, 2010 at 12:18 pm
Quirky update is probably the cleanest way out of this, but it's not going to be pretty. I'd like to see your original DDL / proper sample data, please....
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
October 13, 2010 at 11:01 am
As mentioned, make it =0 instead of =1. I meant to switch it when I copy/pasted the code and forgot, sorry.
As Wayne mentioned above, the leap year 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
October 13, 2010 at 10:41 am
Definately an issue. None of the data was cache'd in memory yet, the server was busy using the disks, and your CPU was probably spiked to 100%.
I wouldn't worry...
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
October 13, 2010 at 10:23 am
I saw it once in a blue moon on an equivalent system. Vendor built, horrendous structure, etc.
What we eventually puzzled out (without proof, might I add, 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
October 12, 2010 at 4:54 pm
e3h4 (10/12/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
October 12, 2010 at 4:50 pm
Mod this a little and it should get you where you're going. The trick is using the date manipulation functions and the datediff thresholds.
CREATE TABLE #tmp
( LockEndDate DATETIME)
INSERT INTO...
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
October 12, 2010 at 4:38 pm
This is going to sound mean, but we can't help you with this one without having a copy of the database.
The error says exactly what it means, one of 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
October 12, 2010 at 4:12 pm
I've found that 90% of the time a spid 'blocks itself'... it's waiting on Disk IO, which is what PAGEIOLOCK means.
Tell them the disks are slow, and take a look...
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
October 12, 2010 at 3:25 pm
Well, for starters, it's going to want a year.
I don't have 2k8 handy to run a direct test for datetime2, but stripping off the 'day of week' at the beginning...
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
October 11, 2010 at 5:40 pm
Viewing 15 posts - 5,296 through 5,310 (of 5,678 total)