You're welcome.

I've seen them do it quite regularly. Especially since the "ç" makes an "s" sound.

Luau

Here is a similar issue that was resolved using DBCC CheckDB with Repair_Fast.

http://www.sqlservercentral.com/Forums/Topic374617-5-1.aspx#bm379178

rambilla4 (5/7/2010)

---

You have a process that caused your tempdb to grow to a certain size. Once that process finished, the pages became free. Once a file grows, it will not...

rambilla4 (5/7/2010)

---

Hi,

I went through the link http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic5015.aspx

where the user Carolyn Godfrey stating the below:

Since tempdb does not require recovery, are there no automatic checkpoints

for tempdb except those when the...

rambilla4 (5/7/2010)

---

Thanks Jason,

Based on the last query you for which you provided results showing the allocation pages, it appears that checkpointing is occurring just fine. The pages are deallocated and...

Then it all looks to be fine.

SELECT f1.[Checkpoint Begin], f2.[Checkpoint End]

FROM fn_dblog(NULL, NULL) f1

Inner Join fn_dblog(NULL, NULL) f2

On f1.[Current LSN] = f2.[Previous LSN]

WHERE f2.Operation IN (N'LOP_BEGIN_CKPT', N'LOP_END_CKPT');

Lynn Pettis (5/7/2010)

---

CirquedeSQLeil (5/7/2010)

---

GilaMonster (5/7/2010)

---

Here's the Oracle-SQL conversion problem. Maybe stay out for now, we're getting nowhere fast and I don't think adding more people nagging for table defs is...

That measure is a bit out of whack. You only have a 2GB pagefile and 16GB of physical memory. The line graph is showing you the physical memory...

Check out this discussion on the topic

http://www.sqlservercentral.com/Forums/Topic844628-149-1.aspx

Based on the last query you for which you provided results showing the allocation pages, it appears that checkpointing is occurring just fine. The pages are deallocated and freed...

There is no attachment.

For example you have a SQL Server process running on SPID 25 and the third...