Hi,

Rebuilding indexes will not affect the replication database. You can do it offline and online as well.

Regards,

IgorMi

Nice question!

What if you already have a master key that is used by a certificate aimed for another database (dbA) on the instance you're moving the dbB?

Just for clarification.

I think...

Hi,

Your two nonclustered indexes are not used by your select * query. Use clustered index instead. You can extend your nonclustered indexes with INCLUDE(col1,col2,...coln) but you have to add a...

shyam00 (7/5/2013)

---

Thanks for the reply.

Is there any way to tackle my scenario mentioned here.?

I need to combine (UNION) two non related derived tables and create an indexed...

Hi

Maybe following link https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/ will enclear some things to you.

Hi,

OUTER JOINs are not supported in Indexed views because rows can logically disappear under some update operations in the base tables.

Regards

IgorMi

Humor is always creative 🙂

Thanks

Hi,

Use PARTITION = partition_number to rebuild the index on the specified partition or PARTITION = ALL to rebuild it on all partitions.

If you want to design your own script then...

Hi,

The transaction log has to be configured well too. Growing files is pretty expensive operation.

Do you care about the VLFs count? The following link can help you configure it well...

Hi,

Try this link could help you http://stackoverflow.com/questions/935018/hide-sql-database-from-management-studio

but see the comments, and this https://connect.microsoft.com/SQLServer/feedback/details/273830/need-view-definition-permissions-per-database

as well.

Wonderful!

Regards,

IgorMi

Hi,

@sqlsurfing: Thank you for your links. I knew and read those articles/posts. I was looking to find something concretely for the VLFs' different size, and probably like Gail said it...

Ok. I thought you use another query.

Then, are the settings (ANSI_NULLS, QUOTED_IDENTIFIER, ...) for your connection (OLE DB, ODBC) identical with the settings on both servers?

Regards

IgorMi

Hi

You can catch the execution plans for the query on both servers and comparing them you'd probably come up to the reason why their duration differ.

You'd better clean the cache...

Hi,

The plan tells that everything is just normal.

What about MAXDOP and the Cost threshold for parallelism? Every one node in the sqlplan is marked to use parallelism.

Is it same every...