Initially, size it twice as large as the largest index(clustered or non or column store) to allow an index rebuild and rollback without having to grow mid operation.

You probably have the option to replicate schema changes set to false.

So this may have to be taken into account when the devs add columns in future as you may...

create procedure ProcBlah(@param1 varchar(100),@param2 varchar(100))

as

BEGIN

Select code,icode

from dbo.Blabla(@param1,@param2)

END

GO

if you want to fix it once off, select all the columns for all the tables and only show the tables and column names that do not exist in the...

It may be many single threaded requests are running concurrently, or some requests are running with parallelism.

A table scan will most likely cause parallelism.

Check you CXPacket waits stats.

You may be...

Find out how to bring the latest state of the art hardware to its knees, what type of code is needed to make a mockery of the most awesome servers.

Basically,...

Hi

No

My ssms version = 13.0.15000.23 and seems to remember the change in setting.

Have you benchmarked the disks where log used to be and where the log file is now?

Can you find out from the san admin how many channels previous log disk...

Physical reads.

Your data is not in memory so it has to go to disk.

This is even worse if it has to do an index seek or scan and then has...

1 Yes, if you do it in the same step, else it will look at modification count.

2. https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

Just beware that if you have a billion row table and...

kiran08.bi (9/26/2016)

I want to implement purging process in our production environment. For that i am dumping the transactions into “ Purge_work “ table and then deleting...

Is there a DB which is not synchronized?

maybe you could try this. with a little bit more parameterisation, you could make a proc.

Check if a backup operation is running for this particular DB then if it is...

Not sure how you calculated the 5 hours, but you dont have to do all the extracts from.

Just subtract the 2 dates if they are TIMESTAMP.

If they are not TIMESTAMP,...

Give us the defintiion of the tables, as well as the data in the source tables.

Create another result table which will contain the result set that you need based...