Dave Ballantyne (6/18/2010)

---

Absolutely.

Since 2 is just a subset of 1 , try something like ...

Sum(case when datediff(mn,DateTimeIn, DateTimeOut) < 60 then 1 else 0 end)

Additionally , you...

GilaMonster (12/8/2009)

---

The proper way is to schedule regular log backups so that the space in...

The...

Tried, but the size not decreasing... still 12GB :pinch:

Hmm... I still not very clear about that.

A temporarily table "@eps" was created to hold...

Jack Corbett (11/30/2009)

---

Note the WHERE clause on the snippet. I load all the rows with a NULL ProcessedDate into the @emps table variable, process the rows. Then use...

Jack Corbett (11/16/2009)

---

A simple, T-SQL only process would be something like this (not tested so you may have to make some changes):

CREATE TABLE EmployeeQueue

(

...

Jack Corbett (11/14/2009)

---

A job could call a stored procedure (my preferred method) or it could just be T-SQL.

You'd have to write a windows service, probably use .NET, that reads unprocessed...

Jack Corbett (11/13/2009)

---

Okay, I have a couple of comments about your situation.

1. Don't do it this way. You do not want a trigger to have to do anything...

CREATE TRIGGER [tr_Emp] ON [Employee]

FOR INSERT

AS

DECLARE

@EmpID varchar(20),

@EmpName varchar(100)

SELECT @EmpID=INSERTED.EmpID, @EmpName=INSERTED.EmpName

FROM INSERTED

BEGIN

SET NOCOUNT ON;

IF @EmpID IS NOT NULL

BEGIN

INSERT INTO [ServerName].[DBName].[Employee] (EmpID, EmpName)

VALUES (@EmpID, @EmpName)

END

END

GO

Is this correct?

WayneS (10/8/2009)

---

setlan1983 (10/8/2009)

---

Btw, why need put double dot before "Table1"? Why not single dot?...

But if I want archive the following:

1. "SELECT Sum(SalesAmt) AS TotalSales, COUNT(*) AS TotalTrans FROM DB_A.Sales WHERE...

Mark-101232 (10/8/2009)

---

setlan1983 (10/8/2009)

---

Mark-101232 (10/8/2009)

---

setlan1983 (10/8/2009)

---

Mark-101232 (10/8/2009)

---

See if this helps

CREATE TABLE Table1 (

column1 int,

column2 int

)

INSERT INTO Table1(column1,column2) VALUES(10,20)

DECLARE @DBName VARCHAR(128)

DECLARE @column1 INT

DECLARE @column2...

Mark-101232 (10/8/2009)

---

setlan1983 (10/8/2009)

---

Mark-101232 (10/8/2009)

---

See if this helps

CREATE TABLE Table1 (

column1 int,

column2 int

)

INSERT INTO Table1(column1,column2) VALUES(10,20)

DECLARE @DBName VARCHAR(128)

DECLARE @column1 INT

DECLARE @column2 INT

SET @DBName=DB_Name()

EXEC...

Mark-101232 (10/8/2009)

---

See if this helps

CREATE TABLE Table1 (

column1 int,

column2 int

)

INSERT INTO Table1(column1,column2) VALUES(10,20)

DECLARE @DBName VARCHAR(128)

DECLARE @column1 INT

DECLARE @column2 INT

SET @DBName=DB_Name()

EXEC ('DECLARE cur1...

Elliott W (9/17/2009)

---

For Case A I would say you have some blocking going on, definitely see who is doing it.

For Case B I would say indexing and tuning sounds right....