george sibbald (10/4/2010)

---

🙂 ah such an optimist! I do not think so but if it...

Did they benchmark TVF vs scalar functions vs CLR functions for this case ?

Thank you for the feedback.

Can you provide some performance data of their tests and chosen solution ?

Grant Fritchey (10/2/2010)

---

It depends on how your views are put together. If they're all simply "SELECT *" type of views, then they more or less fix themselves as they are...

What your are trying to do is a piecemeal restore.

(ent edtn / dev edtn needed )

ref: http://msdn.microsoft.com/en-us/library/ms177425.aspx

check Restore headeronly in BOL.

It provides the info you need.

You can use it this way:

if (select isnull( object_id(N'tempdb.[dbo].[#Tmp_BackupHeaders]'), 0)) <> 0

begin

DROP table #Tmp_BackupHeaders

end

-- versie SQL2K5 sp2

create...

please post your configuration settings "min server memory" and "max server memory".

On every 64-bit os, you should set the max server memory or else it may grab all ram.

(the...

If you're going for the choice to copy the table to a staging table scenario, keep in mind to re-link all objects that are related to or have been related...

Adi Cohn-120898 (9/28/2010)

---

I have to admit that I don’t agree with ALZDBA’s opinion. It is important to know and realize what clustered index does and how dropping it and\or...

How is this for a coincidence ... just today ... converting another db to sql2005 .... data_purity messages ....

my query only captured 7 rows of the 68 rows reported...

digdave7 (9/27/2010)

---

...The end goal here is to shift the clustered index from the GUID to the BigInt column, if we can avoid dropping the indexes and migrate them, as you...

sandy-833685 (9/27/2010)

---

Thx,

But its not hardcoded its an value which is stored in variable which is having a datatype as datetime. and after going through certain select and execution stored procedure.And...

sandy-833685 (9/27/2010)

---

Hi i am having table with column name time data type as datetime

And when i try to execute the select statement with convert like

select * from tablename

where convert(varchar(10),time,103)<'06/06/2010'

as i...

I'm glad it has been solved using the page method.

I've been confronted a couple of times with this issue and I've been able to filter the troublesome rows using this...

it's a petty for us all, but "disable trigger" is not a ddl statement !

So you cannot capture it with a ddl trigger.

We have the same issue as you have,...