The cost is a relative number without any units or range associated with it.

The optimizer assigns a cost to every execution plan it creates , think of it as a...

How far apart were these screenshots taken , seeing massive usecounts after the cache has been flushed. conisdering that it flushes every 30 sec , the number doesnt make much...

Phil Parkin (9/20/2015)

---

Jayanth_Kurup (9/20/2015)

---

Phil Parkin (9/18/2015)

---

Jayanth_Kurup (9/18/2015)

---

VS or SSDT uses a version of the database schema to perform the comparison and not the actual database target itself. Its more of...

Lazywriter kicks in when SQL detects memory pressure , I was trying to find out if there is memory pressure which causes the Cache to flush or is it something...

DO NOT CHANGE THE DOMAIN NAME in order to perform your migration, SQL Server stores machine name internally so just changing the domain name to the old value will not...

You might have a policy or trigger preventing the changes the question is why you are not altered about the same.

Phil Parkin (9/18/2015)

---

Jayanth_Kurup (9/18/2015)

---

VS or SSDT uses a version of the database schema to perform the comparison and not the actual database target itself. Its more of an extension of...

VS or SSDT uses a version of the database schema to perform the comparison and not the actual database target itself. Its more of an extension of Data Tier Application,...

Have you explored the Copy database Wiazrd , it provides features to migrate server level objects too. Or you can create and SSIS package with the requried tasks

How about a table create script or some sample data, more importantly You can lookup MSDN since what your asking for a very basic t-SQL.

https://msdn.microsoft.com/en-us/library/ms177673.aspx

Just to add to my original suggestion , since your using this for a ETl process , Here is what I think would work

-create a date table for i...

The irregular timing suggests that it might be a frequently executed procedure. Is the database highly transactional , how frequently does lazywriter and checkpoint run ?

Do you know since how...

Does it flush regularly at 30 sec or is it an approximation? all day or only during peak hours? It doesnt have to be a job it could even be...

I understand not being able to modify the existing tables , but would it be possible the simple add 2 date tables with a set of dates and times...

Windows allows creation of a VHD or image of disk which can be used to launch a VM , this will automatically move the required databases and files in your...