meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 9 months |
| seen | May 1 at 18:03 | |
| stats | profile views | 34 |
|
Nov 24 |
comment |
Transactional Replication Error adding new subscription (null) article --read to fast, sorry-- |
|
Nov 16 |
awarded | Nice Answer |
|
Sep 7 |
revised |
Shrink database is not shrinking as much as expected on a 1.5 TB database. Total brain failure about the deallocation of extent |
|
Sep 6 |
revised |
Shrink database is not shrinking as much as expected on a 1.5 TB database. added 118 characters in body |
|
Sep 6 |
comment |
Does Log-Shipping need Transaction Log Backup from Primary Server? Do you mean to initialize the logshipping or in general? |
|
Sep 6 |
answered | Shrink database is not shrinking as much as expected on a 1.5 TB database. |
|
Sep 6 |
comment |
Login to SQL Server 2k8 R2 SP1 via Active Directory Group No problem. Appreciate your feedback. |
|
Sep 5 |
comment |
Error Occured during the login process Open sql server configuration manager on the sql server, look for server protocols, look for named pipes, enable it. Right click an select properties, copy the named pipe string (for later),now restart the sql server service. Open management studio, paste the named pipe string in the server name box. Connect. This should work |
|
Sep 5 |
revised |
Error Occured during the login process added 17 characters in body |
|
Sep 5 |
comment |
Error Occured during the login process What have you tried? |
|
Sep 5 |
comment |
Error Occured during the login process Have you got DAC enabled? |
|
Sep 5 |
answered | Error Occured during the login process |
|
Sep 5 |
answered | SQL: What is slowing down INSERTs if not CPU or IO? |
|
Sep 5 |
answered | PAD_INDEX and FILLFACTOR on clustered Identity index |
|
Sep 4 |
comment |
In-memory SQL Server log file you clear the wait stats using the following (just in case): DBCC SQLPERF ('sys.dm_os_wait_stats', CLEAR); |
|
Sep 4 |
comment |
In-memory SQL Server log file can you clear the wait stats on both source and destination instance and then run the load again. After that, please collect the wait statistics on both instances with this query: sqlskills.com/BLOGS/PAUL/post/… |
|
Sep 4 |
answered | Troubleshooting Failed SQL login from WMI service |
|
Sep 4 |
comment |
Database starts always in recovery mode @Lynn Langit, Checkpointing doesn't clear the log by definition. Only in simple recovery model are inactive VLFs cleared. In any case, if there is an active transaction, you could checkpoint/truncate/clear all you want but luckaly nothing will happen ;-) .Furthermore, Checkpointing could help in any redo delays, but this problem could also be caused by an undo delay. (Most likely). |
|
Sep 4 |
comment |
Create index view with self join could you provide table definition, query and expected result? Please explain why you currently want indexed views. (adn what you want indexed). Somebody might be able to provide you with a alternative. |
|
Sep 4 |
answered | Best value for fill factor in index |
