Corrupt means? are u getting any corruption related errors? or it has been deleted from the database? .. If it is deleted and if database is subscriber database in transactional...

Yes !! this query is much simpler !! 🙂

Hi,

I was trying to reply the Posts by David McKinney and chrs-513176 in the same thread.

Where he is talking about rare scenario of having mutiple foreign keys between Table1 and...

We can think of adding column names into foreign key names. But it may not be better if there are multiple columns involved in the relationship.

If you have multiple...

Thanks for the feedback. I will incorporate the inputs.

Regards,

Vidhyadhar

One more thing is this procedure takes care if the partition is compressed. One more manual step is eliminated.

If you are doing it manually you need to find out...

Hi Vinay,

Yes,

For truncating partition you need to create the mirror/dummy table with similar schema and on same file group where the partition is residing; and then use the Alter...

http://www.sqlservercentral.com/scripts/Truncate/69506/

Have a look at this script

Disadvantages of method 1-

1. As per the best practices it is recommended that every column name should be self explainatory or meaningful. Which gives more comfort to developers and...

Disadvantages of method 1-

1. As per the best practices it is recommended that every column name should be self explainatory or meaningful. Which gives more comfort to developers and...

and yes you can store english and combodian data in varchar column nvarchar is not required. But you need to specify combodian collation at column level/ DB level and if...

You can specify collation i.e. language specification to varchar and char columns.

You can not/need not specify collation/ language specification to the nvarchar/nchar columns; because it [nvarchar/nchar i.e. unicode] can...

Few More additions to above mentioned differences-

4. DRI permissions are applicable to UDF and not to SP

5. Schema binding can be done with UDF not with SP.

6. You can make call...

Suppose my database crashes at 8.40 am. I just have last log backup at taken at 8.30 am. Now i want to restore it upto 8.39 am. How would you do...

Following are the key differnces between Stored procedure and UDF.

1.User defined Function returns only one value; It may be the one value of...