Viewing 15 posts - 5,266 through 5,280 (of 5,678 total)
Ninja's_RGR'us (10/18/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 18, 2010 at 3:48 pm
You're looking for Unpivot.
A quick fix to the sample data:
CREATE TABLE [dbo].[#GblSecurityMain](
[EmployeeNumber] [int] NOT NULL,
...
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 18, 2010 at 3:12 pm
chris.s.powell (10/18/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 18, 2010 at 1:46 pm
I... hesitate to tell YOU that it's okay to destroy YOUR backup files. However, I can help you figure out if it's right for you.
First, keep any trn files...
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 18, 2010 at 1:42 pm
GilaMonster (10/18/2010)
Craig Farrell (10/18/2010)
It can be a lot more complex than that but start there. 🙂
Kalen Delaney did a talk for the 24 hours of PASS earlier this year...
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 18, 2010 at 1:34 pm
chris.s.powell (10/18/2010)
Will the .ldf return to the initial size of 2MB after all transaction have completed?
Nope, and you won't want it to. You'll need that space the next time...
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 18, 2010 at 1:26 pm
To add to what Gail said, yes, your T-Log can still grow. Simply you always need enough space for your largest transactions to occur, in whatever restore method you...
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 18, 2010 at 1:26 pm
To go back to our earlier discussion on bad drivers in random places, apparently hit'n'runs are universal. Took my car out last weekend. Lowspeed, luckily, but it's dead,...
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 18, 2010 at 1:05 pm
WayneS (10/15/2010)
LOL! :w00t:(Think of how much that you learned! Sounds like it's been a good week for learning!)
Oh learned plenty so far. My SQL learning is simply matched up...
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 15, 2010 at 5:29 pm
WayneS (10/15/2010)
Craig Farrell (10/15/2010)
Or, for the 2k8 deprived,Umm, Craig, this is valid syntax for 2005 also! :w00t:
I think I'm going to go hide in my corner now. I'll...
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 15, 2010 at 5:13 pm
Or, for the [EDIT] eternally stuck in 2k mindset... [/EDIT], a bit more oldschool:
SELECT
t1.*
FROM
Table1 AS t1
LEFT JOIN
Table2 AS t2
...
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 15, 2010 at 3:34 pm
smknox (10/15/2010)
ORDER BY
CASE WHEN @SortVar='name' AND @order = 'ASC' THEN s.LastName+s.FirstName END ASC,
CASE WHEN @SortVar='name' 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
October 15, 2010 at 2:34 pm
Constantly forgetting that if I want to know what the SERVER is going to do with an SSIS/DTS package, I have to schedule it, not run it from the design...
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 15, 2010 at 2:25 pm
GilaMonster (10/15/2010)
mtillman-921105 (10/15/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 15, 2010 at 1:24 pm
GilaMonster (10/15/2010)
Relax. Don't exaggerate your abilities. Don't lie. Don't be afraid to say 'I don't know', but have a plan for finding out.
This. This this this. I passed...
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 15, 2010 at 10:38 am
Viewing 15 posts - 5,266 through 5,280 (of 5,678 total)