Basically what is happening is that your deleted records become ghost records. This is a performance feature to speed up the delete and rollbacks if needed. Once the record is...

We have tired to give you hints, but you need to give us the create table statement and the sample data if you want a better answer. Also your expected...

Read my post again about using ROUND. Here is a sample:select round('7.88528800',2)

select round('3.06978700',2)

select round('1.78070800',2)

select round('1.67984500',2)

select round('1.59402600',2)

select round('1.36468000',2)

select round('1.09013200',2)

select round('.96727700',2)

select round('.91552000',2)

select round('.82464700',2)

select round('.80762800',2)

mark.dungey 56406 (2/20/2014)

---

select MAX(a.InvoiceId),c.SoldTo,(select 'CustomerOrderNumber1' = CASE WHEN c.SoldTo = 'G09905' THEN 'UN013'

WHEN c.SoldTo = 'G09929' and id.CustomerOrderNumber != '' THEN 'AL037'

WHEN c.SoldTo = 'G09929' and id.CustomerOrderNumber = '' THEN...

Since we don't have the create statement or sample data for your table (hint, hint!), are you asking why is the data incorrect? or why isn't it rounding? If you...

I would look at the following thread: http://www.sqlservercentral.com/Forums/Topic695034-357-1.aspx

Are you running replication? If so, have you checked that it is functioning properly?

Have you checked for long running transactions? You could use sp_WhoIsActive, sys.dm_tran_active_transactions or DBCC OPENTRAN to find long running transactions.

I would add to Lowell's query with the following:SELECT recovery_model_desc, log_reuse_wait_desc

FROM sys.databases

WHERE database_id = DB_ID()

You can try this:declare @timevar int

select @timevar = '145345'

select right('000000' + cast(@timevar as varchar(6)), 6)

select @timevar = '23'

select right('000000' + cast(@timevar as varchar(6)), 6)

Please read the first article in my signature about posting these types of questions to the forum. I have added the tables and some sample data for you and using...

See the following KB article on when you need to add the -T845 trace flag: http://support.microsoft.com/kb/970070

The book that Gail mentioned is the reference, but changing the SCOM alerting threshold is not the point. The point is that you need to understand memory management and monitoring...

I would recommend reading the book (not just the chapter) that...

I almost always have foreign keys in my relation design and not just for academic reasons. This will guarantee that I won't get orphaned records, if you use an ORM...