Viewing 15 posts - 3,811 through 3,825 (of 5,685 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...
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...
March 5, 2011 at 4:34 pm
Nice article, thanks Paul. Looking forward to the rest of the series.
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...
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...
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...
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...
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...
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...
March 4, 2011 at 5:47 pm
GilaMonster (3/4/2011)
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...
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...
March 4, 2011 at 3:54 pm
elfty (3/4/2011)
ALTER DATABASE xxx SET EMERGENCY
ALTER DATABASE xxx SET...
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....
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...
March 4, 2011 at 2:51 pm
Viewing 15 posts - 3,811 through 3,825 (of 5,685 total)