Viewing 15 posts - 3,811 through 3,825 (of 5,678 total)
Nope, not really.
Your best bet is to tag a local recruiter, get yourself a Junior techie on the cheap for a month or two, and have them siphon through 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
March 6, 2011 at 12:36 am
Anamt (3/5/2011)
How do you suggest reclaiming the space for a specific table? Is there any way or some steps we can do?
Most of the time, you don't. You'd have...
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
March 5, 2011 at 4:34 pm
Nice article, thanks Paul. Looking forward to the rest of the series.
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
March 5, 2011 at 2:45 pm
Rog Saber (3/5/2011)
I can research how to do this. In essence, just replace my current view by creating an indexed view?
Yes. See this page for the necessary rules:
http://msdn.microsoft.com/en-us/library/aa933148(v=sql.80).aspx
You'd essentially...
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
March 5, 2011 at 1:37 pm
Rog, to help you understand what Jeff is seeing, if you look at the graphical execution plan, the first upper right componenets are an Index Scan on RT_TRIP and 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
March 5, 2011 at 1:30 pm
As a side note to what Dave offered, which is accurate, Service Broker is only available in Express so it can be connected to a Standard or Enterprise edition. It...
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
March 5, 2011 at 1:19 pm
Gopinath,
I'm hoping you've simplified your example, but in this case:
CAST(
COALESCE(NULLIF(LD.Date1,''),
NULLIF(LD.Date2,''),
NULLIF(LD.Date3,'')) AS DATETIME2) < @DeleteDate
will not allow for any index usage, you've created a non-SARGable expression. You will 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
March 5, 2011 at 12:57 am
To add to the evaluation, the 230 megabytes you're scanning in from RT_Trip can't be helping. The Scan is happening for the Free_Runner = 'N' component, but it's working on...
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
March 5, 2011 at 12:51 am
I see where you're trying to go with this Peter and it breaks a few rules of how SQL will automatically build an XML file for you.
My best recommendation without...
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
March 4, 2011 at 5:47 pm
GilaMonster (3/4/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
March 4, 2011 at 4:28 pm
rVadim (3/4/2011)
^^ That is exactly what I thought but OP for some reason wanted to do it in the trigger.
Yeah, I noticed that after I posted (I had the window...
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
March 4, 2011 at 3:55 pm
Hey folks, Some poor soul is having recovery difficulties across different versions of SQL to boot. Unclosed MDF, out of sync ldf, the works.
If one of the gurus 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
March 4, 2011 at 3:54 pm
elfty (3/4/2011)
ALTER DATABASE xxx SET EMERGENCY
ALTER DATABASE xxx SET...
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
March 4, 2011 at 3:52 pm
niteshrajgopal (2/27/2011)
I have a table with no Primary Key. I have a column that is null. But I want to set it to 'NR' after it has been inserted....
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
March 4, 2011 at 3:25 pm
Sean Lange (3/4/2011)
Friend of mine just ran across this at work.
(TM.TransType IN ('CO') OR
TM.TransType IN ('CM') ) --Not the same as "TM.TransType IN ('CO', 'CM')"
... 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
March 4, 2011 at 2:51 pm
Viewing 15 posts - 3,811 through 3,825 (of 5,678 total)