Viewing 15 posts - 5,356 through 5,370 (of 5,678 total)
Shawn Melton (10/6/2010)
GilaMonster (10/6/2010)
Tom.Thomson (10/6/2010)
Brandie Tarvin (10/6/2010)
GilaMonster (10/6/2010)
Does anyone think my response here was over-the-top? http://www.sqlservercentral.com/Forums/FindPost999124.aspx
No. I find it professional and well-reasoned. It is the correct and necessary response to...
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 6, 2010 at 2:30 pm
GilaMonster (10/6/2010)
Is today 'Mismanage your transaction log' day?http://www.sqlservercentral.com/Forums/Topic999809-146-1.aspx
3rd one so far today.
Until recently I had no idea how many people screwed up full vs. bulk vs. simple...
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 6, 2010 at 2:19 pm
I believe you're looking for this:
UPDATE tu1
SET
first = tu2.first,
last = tu2.last,
local_ID = tu2.local_id
FROM
#Test_Users AS tu1
JOIN
(SELECT
*
FROM
#Test_Users
WHERE
org_id = 50
) AS tu2
ONtu1.local_id = tu2.local_id
where
tu1.org_id = 50
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 6, 2010 at 2:11 pm
Craig,
Is it safe to assume that this field will alway end in numerics? If so, I may have a simple solution for you regarding the variable front 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 6, 2010 at 1:54 pm
Answer: No and no.
This code, as is, will not deadlock independently. There's no transaction calls.
What is the serverwide setting for isolation?
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 6, 2010 at 1:43 pm
WayneS (10/5/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 5, 2010 at 6:08 pm
The Dixie Flatline (10/5/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 5, 2010 at 5:38 pm
TheSQLGuru (10/5/2010)
3) I gotta say it is a darn shame in this day and age that you are fretting over a paltry 50GB of disk space!! :blink:
Wish I could...
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 5, 2010 at 5:24 pm
CirquedeSQLeil (10/5/2010)
select
database_name = DB.name
,sum( MF. /131072.) as 'Gig'
...
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 5, 2010 at 5:19 pm
Double post, sorry.
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 5, 2010 at 5:15 pm
See the link in my sig for help with optimizations. We need a lot of your DDL to help you here.
At first glance, I can imagine those count structures...
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 5, 2010 at 5:15 pm
ricardo_chicas (10/5/2010)
I was dealing with some blocked sessions and I wonder if there is a way to know exactly what object is being blocked, I know how to get...
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 5, 2010 at 4:56 pm
GilaMonster (10/5/2010)
Craig Farrell (10/5/2010)
GilaMonster (10/5/2010)
Alvin Ramard (10/5/2010)
GilaMonster (10/5/2010)
Local version:
Q: How do you eat an elephant?
A: One bite at a time.
That's the opposite of:
Q: How do you put an elephant 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
October 5, 2010 at 4:54 pm
george sibbald (10/5/2010)
WayneS (10/5/2010)
This is too good not to pass onthat post was deserving of being the 1,000,000th .
:w00t: Seconded! Alright, someone get in there and do 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
October 5, 2010 at 4:52 pm
GilaMonster (10/5/2010)
Alvin Ramard (10/5/2010)
GilaMonster (10/5/2010)
Local version:
Q: How do you eat an elephant?
A: One bite at a time.
That's the opposite of:
Q: How do you put an elephant in a refrigerator?
A: Open...
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 5, 2010 at 3:44 pm
Viewing 15 posts - 5,356 through 5,370 (of 5,678 total)