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...
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...
March 10, 2009 at 5:53 am
Please post back with how things work our for you. Thanks!
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. 🙂
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...
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...
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...
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...
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...
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!
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...
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...
March 9, 2009 at 2:00 pm
Can you post the execution plan as an attachment? Thanks.
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...
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...
March 9, 2009 at 12:01 pm
Viewing 15 posts - 706 through 720 (of 1,790 total)