search for powershell + dacpacs

https://www.simple-talk.com/blogs/2013/10/18/powershell-script-all-objects-on-all-databases-to-files/

To see what is using the file

http://superuser.com/questions/117902/find-out-which-process-is-locking-a-file-or-folder-in-windows

To use a batch command to make a new copy of the file even if it is in use.

http://stackoverflow.com/questions/7647701/how-to-copy-in-use-files-through-batch-file-in-windows-7

Are you using switching?

http://www.cathrinewilhelmsen.net/2015/04/19/table-partitioning-in-sql-server-partition-switching/

https://www.mssqltips.com/sqlservertip/1406/switching-data-in-and-out-of-a-sql-server-2005-data-partition/

I eventually found an easier and less complicated solution. I created a new column with int values (Y=1, N=0) and then did a straight forward measure on it. Works every...

If you are using a dataset to populate the Available values - just use the same dataset to also populate the default values. This causes every option to be ticked.

Just...

On the plus side, storing telephone number as int uses less storage than a varchar. Ok you won't need to use any numeric functions on it, but you probably won't...

Resolved - Added a new field in database with the count using Partition Over.

I had been using temp tables in a large import process and made the change to table variables and saw a big improvement in performance. However, the server was later...

DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS

http://social.msdn.microsoft.com/Forums/en/sqldisasterrecovery/thread/48cf82c9-2179-46f3-b009-11416a90d248

Mentioned in the other other posting you added to - if no SQL backups check for a software backup of the file system or a Windows Shadow copy backup. If...

Had same proble updating across a linked server.

A unique index did not work for me. I got it to work by:

Creating a temporary table in remote db then did a

...

Can you explain the benefit of this approach in comparison to using: ALTER INDEX REORGANIZE - which can be done online to a partitioned index?

The link below made me realise that we could improve on options of "create new table" / "select into" / "alter table". All of which involve writing a new table...

A few alternatives:

1. Rebuild SSIS jobs as DTS jobs.

2. Add the SQL Server 2000 server as a linked server on a SQL Server 2005 or later server. Then amend the...

Manually shrinking in the scenario you mention (full recovery mode with no tlog backup of any kind) will not remove data from the tlog nor allow it to be reduced...