Only thing that comes to my mind at the moment would be one or more long running transactions.

Could be other things, just not sure what at the moment to suggest.

Is there anything else going on with this database? Is it part of a mirror or anything like that?

Only thing I can suggest at this point is to double check your server properties.

Can you confirm that your transaction log backups are running successfully?

Delete data.

Trying to understand why you are focusing on page count. As data is added to the database the page count is going to go up.

Unfortunately, this edition of SQL Server only supports being a subscriber to replication.

http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).aspx

Daxesh Patel (5/21/2012)

---

I am trying to do following task and I donot know it is possible in this setup or not?

I am trying to setup performance counter on a non-domain...

SQLKnowItAll (5/22/2012)

---

Lynn Pettis (5/22/2012)

---

timwell (5/22/2012)

---

We have 2008 R2 Web edition

This implies that the application is web-based. Does each remote site have their own web server and database server or do...

timwell (5/22/2012)

---

We have 2008 R2 Web edition

This implies that the application is web-based. Does each remote site have their own web server and database server or do they all hit...

mwood 57977 (5/22/2012)

---

What I'm after here is the following.

List of employee total pay hours for last week

How much of that was zvaca, zhol, zawar, etc.

There are three tables that...

This implies that the application is web-based. Does each remote site have their own web server and database server or do they all hit...

chrisdicentes (5/22/2012)

---

Here's my scenario:

2 Win2k8R2 Servers running SQL 2k8R2 Standard edition servers in a failover cluster with a single service (Default SQL instance).

I need to move this service to SQL...

You may need to make a slight change to the insert when a person loses. I just copied what was from the won side.

Is this what you are attempting to accomplish?

CREATE PROCEDURE Casino.Sp_SlotMachine

@User NVARCHAR(10)

,@bet INT

AS

BEGIN

DECLARE @L_Wheel VARCHAR;

DECLARE @M_Wheel VARCHAR;

DECLARE @R_Wheel VARCHAR;

SET @L_Wheel = (

SELECT TOP 1 AA

FROM Casino.Symbols AS...

Can you be a little more specific about your problem?What is, or isn't happening? Are you getting some kind of error message?