Viewing 15 posts - 44,041 through 44,055 (of 49,571 total)
Very quick first glance.
There are two places with very bad estimates:
The clustered index scan of Inv_AeX_AC_Client_Agent, which estimates 1901 rows and gets over 6000. It may be that...
October 4, 2008 at 1:59 pm
Cool. I'll take a look and get back to you tomorrow or monday. It's late here.
October 4, 2008 at 1:39 pm
That's odd, because merge replication doesn't use the transaction log. Transactional replication does to track changes from the publisher. According to the opentran output you posted earlier, there are definitly...
October 4, 2008 at 2:03 am
Security checks: Do any of the fixed database or server roles have members that they shouldn't? Are a large number of unexplained login failures occurring?
October 3, 2008 at 2:12 pm
Why the cursor? That whole thing could be replaced by a single statement.
select CONVERT(datetime, FechaRecepcion, 103)
from Ejemplares
where ISDATE(FechaRecepcion) = 1
The reason for what you're getting though is that the cursor...
October 3, 2008 at 2:09 pm
rbarryyoung (10/3/2008)
GilaMonster (10/3/2008)
That looks like the estimated plan. Is there any possibility of seeing the actual plan please?
Probably not from the production environment in the time that I have left...
October 3, 2008 at 2:02 pm
No. The declared order of columns has no effect on anything other than the order they're returned in a select * query. The order defined doesn't even define the physical...
October 3, 2008 at 1:02 pm
That looks like the estimated plan. Is there any possibility of seeing the actual plan please?
The only parameter I can see in there is @collectionGuid. Will vastly different numbers of...
October 3, 2008 at 12:57 pm
binaryspiral (10/3/2008)
Quick Question: If you don't have Enterprise Manager, how do you work with your databases?
SQL Server Management Studio. I only have SQL 2005 and 2008 instances. Enterprise manager doesn't...
October 3, 2008 at 12:50 pm
Odd. While I had the exam crash and restart, it wasn't slow at all. At most a couple secs between questions.
I'm writing 71-433 next week. Will see if it's...
October 3, 2008 at 11:22 am
If that is your log file, then I would hazard a guess that your DB is in full recovery model and you have no log backups.
Read this - http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/
October 3, 2008 at 11:17 am
the 'fullname', if you will, of each primary key is the name of the table plus the column name.
The name of the primary key is whatever you specify it to...
October 3, 2008 at 11:17 am
As far as I'm aware, the support policy for SQL in a virtual environment is still as documented in the following kb article
http://support.microsoft.com/kb/897615
I know SQL 2008 is fully supported on...
October 3, 2008 at 11:15 am
chakri002 (10/3/2008)
Use Instead of Triggers on the Views to Delete or Update Records directly from the view.
You did notice that the thread you answered was 2 years old?
October 3, 2008 at 11:06 am
carlos.tapadinhas (10/3/2008)
Hi again,How can i know which tables are created on tempdb and aren't used anymore, in sysobjects?
Answered here:
http://www.sqlservercentral.com/Forums/Topic580338-146-1.aspx
October 3, 2008 at 11:05 am
Viewing 15 posts - 44,041 through 44,055 (of 49,571 total)