Viewing 15 posts - 211 through 225 (of 501 total)
Bradley B (11/10/2010)
Example:Table Customer, with Clustered Index Customer_Clustered
you can page compress Customer, and row compress Customer_Clustered.
If the table has a clustered index the table and clustered index are essentially...
November 10, 2010 at 11:23 pm
For deadlocks you can enable trace flag 1222 which will output to the SQL error log.
To find queries with the highest CPU and IO you can install performance dashboard which...
November 10, 2010 at 10:47 pm
There should be more information about why the job failed. Try expanding the Log Shipping job history by clicking the plus sign (+) on the left of the job history...
November 9, 2010 at 10:13 am
David Levy recently posted a script that should work for what you are trying to accomplish.
November 9, 2010 at 10:04 am
Tara-1044200 (11/8/2010)
I belive if do page compression there is not need to do row compression
Correct. Page compression includes row compression. The trade-off of compression is additional CPU overhead for less...
November 8, 2010 at 10:35 pm
You need to "hack" the database back into SQL server.
1. Create an empty database on the server to match the real database in size, name, files, etc.
2. Stop SQL...
November 8, 2010 at 10:04 pm
Was the Windows server renamed prior to changing the SQL server name?
Can you connect to the server remotely from SSMS?
What network protocols are enabled for SQL server?
Have you tried connecting...
October 21, 2010 at 3:58 pm
Have you restarted SQL Server since renaming using the following?
exec sp_dropserver old_name
GO
exec sp_addserver new_name, 'local'
GO
October 21, 2010 at 3:41 pm
sqlbee19 (10/21/2010)
Thanks.Do I need to set Max memory and min memory if I enable lock pages in memory setting ???
You should definitely set max memory so SQL doesn't...
October 21, 2010 at 3:33 pm
Restoring a database to establish mirroring or log shipping and forget to restore with NORECOVERY.
🙁
October 15, 2010 at 2:27 pm
Article that explains how to retain the SID when transferring logins between servers.
October 8, 2010 at 2:02 pm
To find the memory used by SQL look at the perfmon counter
SQLServer:Memory Manager - Total Server Memory (KB)
October 8, 2010 at 1:54 pm
I ran into the same issue. It's a little convoluted to scan another server.
After you select local server and SQL Server 2008 R2 BPA on the Home page, select Start...
October 8, 2010 at 1:48 pm
Log backups do not shrink the transaction log.
Please read through Gail's article on transaction logs. It should clear up any questions you have.
September 29, 2010 at 6:10 pm
Viewing 15 posts - 211 through 225 (of 501 total)