Truncate Table T1

Truncate Table T2

...

Truncate Table T11

A truncate can only affect a single table so you have to write 11 truncate statements, and there cannot be a foreign key...

The only way you're going to change the fill factor is with a rebuild. It's up to you whether that and your sensibilities are worth the work that this is...

Insert, maybe, delete no.

For the insert, maybe, for...

Ken Davis (5/11/2015)

---

The CI on the big 5-month archive table is highly fragmented. Background info: this was implemented with a terrible clustering key - a random GUID. About...

In SQL 2008, with a huge amount of difficulty. The page splits perfmon counter doesn't track page splits but tracks page allocations. The extended event (if it was even in...

Then I'm curious, why do you need an index rebuild?

I'm asking so that I can be sure that I have your requirements right. I don't feel like writing queries multiple times

Status 1 for maximum month (which will be 12)...

No. How could something running on their machine be able to access resources that can't be accessed from their machine?

If a user runs a batch file on their machine,...

For each row in the example data, please could you explicitly state what the value of status should be for that row?

I'd push back on this someone and ask them. Because

What value? Please be specific. For each row in the example you gave, what should the status column be?

So for the example you specified, what should be the output?

Use backup/restore to copy a database from one server to another. Far easier and far less prone to fail than the copy database wizard

If you run the batch file from your machine, it's looking for files and folders on your machine. Hence D:\Path, means it's looking for the drive on your machine mapped...

And does the folder "D:\Path\" exist on your machine?