Viewing 15 posts - 3,331 through 3,345 (of 5,678 total)
I'm afraid I don't know, in particular, why Task Manager wants a shared shema lock on a temp table.
However, regarding your increase in pressure on the Logon Trigger, check 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
April 22, 2011 at 1:21 pm
Not without backups, no. You restore to a point in time, but you can't reverse to it.
Though, that'd be a really cool feature.
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
April 22, 2011 at 1:09 pm
James Stover (4/21/2011)
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
April 22, 2011 at 11:57 am
Phil Parkin (4/22/2011)
Craig Farrell (4/21/2011)
You really don't want to do this in SSIS.---
Actually, I think there is quite a nice way for SSIS to handle this - using...
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
April 22, 2011 at 11:52 am
Scott Carter-357760 (4/22/2011)
The last end date was defaulting to getdate(), but I modified the second part of the isnull...
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
April 22, 2011 at 11:50 am
You really don't want to do this in SSIS. I hate saying that but you will not be well served by the number of multicasts and loops you'll be...
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
April 21, 2011 at 5:33 pm
Steve Jones - SSC Editor (4/21/2011)
Are you guys having a deep technical discussion on some type of performance testing? Shouldn't that be a thread somewhere else besides 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
April 21, 2011 at 4:58 pm
tjaybelt (4/21/2011)
SELECT
o.name AS [Name],
...
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
April 21, 2011 at 4:56 pm
A little more description if you could between the without/with count differences? I'm trying to grok what the difference in the queries would be, count(*) shouldn't cause that much...
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
April 21, 2011 at 4:56 pm
Hey Scott,
What you needed to do was island the groupings, then come back to them. I did this using some RowNumbering tricks. Take a look at the following,...
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
April 21, 2011 at 4:53 pm
Not a cursor, but a while loop. Look at WAITFOR DELAY while testing for the applock's release.
I always recommend when doing an app wait delay that you build 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
April 21, 2011 at 3:52 pm
EDIT: If Celko mentioned any of this, sorry, I pretty much simply skip his posts at this point.
What you'll want to do is JOIN on a subselect of SELECT Date,...
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
April 21, 2011 at 3:12 pm
There are, but it requires a little extra coding on your part. For things like this, I like to use sp_getapplock. Use TRY/CATCH to make sure you release...
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
April 21, 2011 at 3:07 pm
Tom.Thomson (4/21/2011)
nice easy question; but rather boring. How do 38% get this wrong?
I assume because a lot of folks are like me and instead of researching, then answering, they...
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
April 21, 2011 at 2:38 pm
Ninja's_RGR'us (4/21/2011)
tfifield (4/21/2011)
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
April 21, 2011 at 12:56 pm
Viewing 15 posts - 3,331 through 3,345 (of 5,678 total)