Sql Server – Question about optimizing table copy from one database to another

Posted by Sqltimes
On November 27, 2013
0 Comments

Question for everyone: What steps could we take to optimize table copy from one database to another? A few days ago, I was running a large table copy from one database to another. Something like this: 1 2 SELECT Col1, Col2 INTO OtherDB.dbo.TableCopy FROM ThisDB.dbo.Table This is a huge table, it has close to 6 […]

Posted by Sqltimes
On November 23, 2013
0 Comments

A few days ago, I ran into several interesting issues, one of them was documented in a previous post here. Today, I’m going to write about another issue that occurred under similar circumstances. THREADPOOL wait time. Sql Server has its own scheduling mechanism that is part of its ‘operating system’ called SQLOS. It is responsible for […]

Posted by Sqltimes
On November 21, 2013
0 Comments

A few days ago, I was setting up virtual machines on one of my lab servers and I ran into this interesting error. It’s a Windows Server 2008 R2 "virtual machine could not start because the hypervisor is not running". This is a Dell PowerEdge T610 and I’m trying to build multiple virtual machines using […]

Posted by Sqltimes
On November 20, 2013
0 Comments

A few days ago, I was running a large table copy from one database to another. Something like this: 1 2 SELECT Col1, Col2 INTO OtherDB.dbo.TableCopy FROM ThisDB.dbo.Table This is a huge table, it has close to 6 billion records and the table is close to 300 GB in size. As the copy progressed, I […]

Posted by Sqltimes
On November 18, 2013
0 Comments

Quick one today: To insert the output of a stored procedure into a temporary table, I use the following steps. Create a temporary table with necessary table structure Execute the Stored procedure while inserting its output into this table. Example: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 […]

Posted by Sqltimes
On November 17, 2013
0 Comments

Quick one today. One point that I regularly recommend is to optimize TempDB. There are several things we can do to improve overall performance of all the applications hitting the database instance by just improving the performance of TempDB; Does not require changes to a single line of application code. Every improvement you make here, […]

Posted by Sqltimes
On November 16, 2013
0 Comments

Quick one: As I wrote in one of my previous posts, I am not a fan of running COUNT(*) on any table. I prefer these alternative methods that depend on meta data rather than running a scan on table just to get a count. No matter the size of the table, you can get the […]

Posted by Sqltimes
On November 15, 2013
0 Comments

Quick one today Query hints are sometimes very useful. They are great when you need them, but you want to be careful in your usage. Test thoroughly before embarking on this path. As MSDN says, “Because the SQL Server query optimizer typically selects the best execution plan for a query, we recommend only using hints […]

Posted by Sqltimes
On November 15, 2013
0 Comments

Quick one today Sql Server has its own operating system that manages several things before the commands are sent to Windows Operating System. All Sql Server services a.k.a. SSRS, DB Engine rely on SQLOS for Memory Management Scheduling Synchronization Memory Brokers Exceptional Handling Deadlock Detection Extended Events Asynchronous I/O While it performs all the above […]

Posted by Sqltimes
On November 13, 2013
0 Comments

On one of our production Sql Server we ran into this interesting problem. "A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)" I was attempting to login, using admin account, from […]

Page 1 of 212

Sql Server – Question about optimizing table copy from one database to another

Sql Server THREADPOOL Wait Statistic

Error On Windows Server – virtual machine could not start because the hypervisor is not running

SQL Server PREEMPTIVE_OS_WRITEFILEGATHER Wait Statistic

Sql Server: Insert Stored Procedure Results Into Table

TempDB Add Multiple Data Files to Improve Performance

COUNT(*) for larger tables

Sql Server: Use Query Hints

Sql Server Operating System – SQLOS

A connection was successfully established with the server, but then an error occurred during the login process. An existing connection was forcibly closed by the remote host.