Viewing 15 posts - 5,536 through 5,550 (of 5,678 total)
GilaMonster (9/19/2010)
So in other words I am more irritable than usual. 😉Though given his comments about his history, I don't think so much of a 'new DBA'
Well, I think he's...
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
September 19, 2010 at 2:59 pm
GilaMonster (9/19/2010)
Is my irritation with this guy justifiable, or a product of a mostly wasted day? (well, until his last post that is)http://www.sqlservercentral.com/Forums/Topic988907-391-1.aspx
New DBA just in way over his head....
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
September 19, 2010 at 2:33 pm
SQL Express 2k5 9.00.3042.00 Desktop machine.
Sorry it took a bit, I went out and partied last night. 🙂
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
September 19, 2010 at 2:19 pm
Os-984017 (9/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
September 18, 2010 at 3:57 pm
You're running passthrough queries from Access, right?
If so, SQL Server is a two part statement. First 'create table blah AS ( bId int, value1 varchar(50))... etc.
THEN, you do an...
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
September 18, 2010 at 2:50 pm
pravin.sawant99 (9/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
September 18, 2010 at 1:53 am
For posting sample DDL/tables and data, please do a quick check in the link in my signature, will help out tremendously.
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
September 18, 2010 at 1:47 am
Ah, I see the confusion.
You want to test the table to see if the table has the same name in two locations? Can it be any two locations, 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
September 18, 2010 at 1:44 am
Hey Ali,
I'm not sure why you would want to. If you were writing articles and getting them published, sure, I could see that being something for a resume. ...
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
September 18, 2010 at 1:28 am
What Ali mentioned above will put both names on the same line (and any extra data), which is what you'll want 99% of the time in SQL. If 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
September 18, 2010 at 1:19 am
For starters, you have to understand that everything is a transaction, just you usually don't see it.
SELECT * from Foo... is a transaction, as is UPDATE Foo SET Bar =...
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
September 18, 2010 at 12:04 am
That's just beautiful:
SELECT
ss.SecurityID,
POWER( 10.000000, SUM( LOG10( multiplier))) AS TotMult
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
September 17, 2010 at 11:50 pm
drew.allen (9/17/2010)
Well it's not pretty, but you can get the LOG10() of the numbers, sum them and then raise 10 to that power.Drew
That's a deliciously beautiful workaround to the ideas...
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
September 17, 2010 at 8:25 pm
CirquedeSQLeil (9/17/2010)
Brandie Tarvin (9/17/2010)
Trey Staker (9/17/2010)
CirquedeSQLeil (9/17/2010)
Just curious if anybody here has ever walked out of an interview...What would be your justifications for doing so?
I've never walked out on an...
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
September 17, 2010 at 6:09 pm
I've also seen PAGEIOLATCH's block themselves, when they're waiting for drive data, and not seen any multi-threading when I was looking at sysprocesses.
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
September 17, 2010 at 4:53 pm
Viewing 15 posts - 5,536 through 5,550 (of 5,678 total)