Is "SEARCH PROPERTY LIST " feature available before sql 2012 ? and can it be used in sql table too ?

you dont need to...

First of all , take backup of this database you never know what and when...

1 - How does stop lists improve fulltext query performance in SQL Server 2008 (or it does not)? Is it a good idea to have stop lists assign to all...

NOt always parallelism is bad , sometimes...

i got the correct query

select * from [Person].[Person_BK] where

contains([Name], '*ASDGDE* OR *AFASFA*')

it had happened as i had missed the mandate homework 😀

during my testing or learning on Full text search , i found below queries are returning different results .can you please guide me why

select [BusinessEntityID] , [Name] from [Person].[Person_BK]

where...

i chose the wrong option but learned the RIGHT answer:-D

dbasql79 (12/13/2012)

---

Also edition of mirrored server plays a significant role when it comes to synchrnoization.Enterprise editon will use "Parallel redo" using more threads available to mirroring session If you have...

Sorry i dont have but

have...

shd.eftekhari (12/12/2012)

---

the index is in one of sub queries of child SP and I ma wondering that this table and row has not locked any where else except the last...

three things you need...

shd.eftekhari (12/12/2012)

---

I have a stored procedure(parent) which include to many if cases and in each case calls another stored procedure (child).

In child SP I have a transaction with more than...

+ 1

you can maintain the column's list in dtaabase and fetch with the help of additional parameter (says reportID ) in stored proc. see below

table defintion (ColumnID, ColumnName , reportID)...