Tags » SQL Server 2008 R2
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. 160 more words
You can use this script to see where the SQL Server error log is located
SELECT is_enabled, , max_size, max_files
FROM sys.dm_os_server_diagnostics_log_configurations WITH (NOLOCK)
A few days ago, I was running a large table copy from one database to another. Something like this:
SELECT Col1, Col2 INTO OtherDB.dbo.TableCopy FROM ThisDB.dbo.Table … 295 more words
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… 77 more words
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. 329 more words