Viewing 15 posts - 5,026 through 5,040 (of 5,678 total)
NOLOCK hints are to do non-serialized reads (dirty reads) on data. It ignores all internal locking mechanisms of SQL Server and grabs the data it wants on each table...
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
November 9, 2010 at 2:42 pm
Wildcat, it's SQL Server:
com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 112) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
However, without having tracing...
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
November 9, 2010 at 2:17 pm
GilaMonster (11/9/2010)
Microsoft® SQL Server® code-named 'Denali' - Community Technology Preview 1 (CTP1) : http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9
Got a blog post with a couple...
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
November 9, 2010 at 1:58 pm
GilaMonster (11/9/2010)
I love Wayne's reply there (last page)
My personal favorite is from Sanchin, though I still feel he gave the OP too much.
You really wanna know?
I thought you would rather...
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
November 9, 2010 at 1:57 pm
WayneS (11/9/2010)
@craig-2: 😛 :w00t:
LOL
I was getting brainlocked on trying to get away with some MAXRECURSION 0 method and then had a job I've been working on (at work! ...
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
November 9, 2010 at 1:53 pm
SSSolice (11/9/2010)
@OffBreak : represents a clock scan time of when a break ended.
@DaysHoursWorked : represents total hours worked...
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
November 9, 2010 at 1:04 pm
For the curious, question is from here:
http://www.scribd.com/doc/40561966/sql-Test.
Blocked by websense, I'm assuming it's a historical question/quiz.
How to find it?
So, the answer they really want is:
Blah bla bla, blah blah. ...
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
November 9, 2010 at 12:39 pm
Marcus Farrugia (11/9/2010)
Hi Craig, other than reading you're link:http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
No I haven't seen execution plans. Looks like I have some homework to do... 🙂
Since you're willing to learn, let...
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
November 9, 2010 at 12:22 pm
And back on topic for the thread:
http://www.sqlservercentral.com/Forums/Topic1018016-338-1.aspx
*wallbanger*
I'll be "blah blah"ing over in the corner now.
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
November 9, 2010 at 12:16 pm
Marcus Farrugia (11/9/2010)
Actually no I don't, my knowledge of indexes in general is limited...
Hm, have you any experience then in looking at execution plans?
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
November 9, 2010 at 12:13 pm
David Lester (11/9/2010)
If they find a moderately competent IT director, this will stop. (Over the year there has been no one in the role things have steadily become worse.)
Okay, Career...
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
November 9, 2010 at 12:11 pm
Sachin.Nandanwar (11/9/2010)
rko.37gags (11/9/2010)
i attached the excel file
Now that's better.
Below is your query.
select * from
(
select *,row_number()over(partition by employeeid order by salary desc)rid from salary
)T where...
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
November 9, 2010 at 12:08 pm
To drag the Canadian Geese back to a different formation for a moment, my websense and whatever is used in the Contribution Center doesn't play nice at work. At...
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
November 9, 2010 at 12:04 pm
rohit79 (11/9/2010)
I need to completely refresh Dev/test evn with data ONLY from Prod.And I need to retain the original users on each db servers/ea. databases.
These two items...
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
November 9, 2010 at 11:16 am
rko.37gags (11/9/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
November 9, 2010 at 10:27 am
Viewing 15 posts - 5,026 through 5,040 (of 5,678 total)