Learn about options to copy a table from one SQL Server database to another including Linked Servers, PowerShell, Integration Services, backup and restore along with the associated performance metrics and completion time.
2019-06-13
2013-08-27
2,620 reads
Shows awesome view of columns with constraints and indexes and foreign keys to spot errors fast.
2010-08-04 (first published: 2009-12-03)
1,463 reads
This is an effort to program the "Estimating the Table size" section given in BOL.
2009-07-06 (first published: 2009-06-19)
1,806 reads
This script helps you to constitute insertion procedures for tables in a millisecond.
2012-08-30 (first published: 2007-11-05)
2,324 reads
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers