Viewing 15 posts - 706 through 720 (of 1,790 total)
Adam Bean (3/10/2009)
Trying to call Microsoft now.
Adam - I was watching your other post yesterday about tips on this and wondered if this wouldn't get here. Such a messy...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 10, 2009 at 9:09 am
The filelistonly function is so that you can see the contents of the backup file and then use that to build your restore statement. The restore syntax would be restore...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 10, 2009 at 5:53 am
Please post back with how things work our for you. Thanks!
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 10, 2009 at 4:42 am
RBarryYoung (3/9/2009)
Good. Then you aren't there yet. 😀
I know that it doesn't bother me. Just something that I have noted. 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 10, 2009 at 4:40 am
Gianluca Sartori (3/10/2009)
chrisau168 (3/10/2009)
Hi,but the table scan uses very little resources.
Yes, it's true, but costs are relative and a cost of 0% doesn't mean the operation comes for free, especially...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 10, 2009 at 4:18 am
I don't remember IIF strings too well but I think it would be something like the following;
select
case
when col1 like '%abc%' then col1
else ''
end as xyz
from Table1
Links to...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 10, 2009 at 4:15 am
As David mentioned already, you have a couple of key lookups that I would want to address as IO can be pretty expensive and it appears that most of your...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 10, 2009 at 4:05 am
Well, I thought this would be a bit easier than it probably will be. The report file itself must be embedded in the actual application as I couldn't find it...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 10, 2009 at 3:51 am
You should be able to use the "drop fulltext index" then "drop fulltext catalog" statement to get rid of that. Review these in Books Online and you should be able...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 10, 2009 at 3:29 am
Are you possibly rebuilding the Full Text Catalog at the same time on this database? Check out this link and let us know what you find. Thanks!
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 9, 2009 at 9:44 pm
Jeff Moden (3/9/2009)
RBarryYoung (3/9/2009)
However, the most important thing to remember is that they ARE a small minority of the folks that we see and help.
And, finally, the thread...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 9, 2009 at 9:40 pm
GilaMonster (3/9/2009)
Lynn Pettis (3/9/2009)
You are one of the top 3 people on SSC
Top 4 actually. Steve, Jeff and Remi are ahead
so they figure if anyone knows the answer you are...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 9, 2009 at 2:00 pm
Can you post the execution plan as an attachment? Thanks.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 9, 2009 at 12:40 pm
My guess is that what you are seeing is due to the use of the differential bitmap in the differential backup process. The differential backup header will contain the DatabaseBackupLSN...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 9, 2009 at 12:09 pm
So, based on your reply, you would need the x64 version of the service pack.
As Lynn suggested, test prior to rolling this out to production and make sure you...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 9, 2009 at 12:01 pm
Viewing 15 posts - 706 through 720 (of 1,790 total)