Possibly the easiest method here providing the table schema is setup correctly is to write your insert as a 'select' statement so in this case possibly along the lines of

SELECT...

Another source of contention especially if you are running multiple indexing jobs could be TempDB as Both DB's will use the one TempDB.

Have you looked at the possibility of using CDC for some of this ?

I think the previous responses are great but i would emphesise the 'Do' part of the equation. As a DBA your really paid for that couple of percent of your...

As far as I remember there is no 32-bit version of SQL Server 2014. Time to upgrade to the 64-bit world ?

Why would you be interested in the IP address if your using DNS and DHCP. Have a play with

SELECT

conn.session_ID as SPID,

conn.client_net_address as IPAddress,

sess.host_name as MachineName,

sess.program_name as ApplicationName,

login_name as LoginName

FROM...

Easily I think the limit is around 500PB on the developer version.

From experience steer well clear of trying to manually defrag disks on a SAN use only recommended utilities. A single .MDF or .LDF can span a large number of disks...

Most of the system information is now held in the Resource DB which is hidden read only (for good reason) you can't even do a SQL backup of this database....

The whole business is changing and I am not sure MS is changing fast enough to accomodate this. MS still seems stuck in its business model of servers and desktops...

Could also use the ISNUMERIC function to check that the data is an integer value.

You planning on a straight SQL Server install onto Windows Server 2012 or are you opting to go down the Server Core route ?

Do a alter database or detach/reattach and move all the inactive or offline databases to a disk not part of the cluster. That will reduce the volume of databases for...

Depending on what your doing, the usual solution is to aggregate a field or two and then group the data. Can you supply a bit more information on what your...

bubble