Use dateadd to remove 8 hours from the two datetimes. Is it because sharepoint stored times in GMT?

SELECT NVARCHAR1, NVARCHAR6, DATEADD(hh,-8,Datetime1) as StartTime, DATEADD(hh,-8,Datetime2) AS EndTime

FROM PROWSS_Content.dbo.alluserdata

WHERE DATEADD(dd, DATEDIFF(dd,0,getdate()),0) BETWEEN...

It does during the installation

I hope I don't have to re-install....

You don't need an update in the trigger. The trigger is fired by the update. If you want to check the new values, use the inserted table. deleted, in an...

You can add a filter on the nvarchar6 for the room you want to display.

SELECT NVARCHAR1, NVARCHAR6, Datetime1, Datetime2

FROM PROWSS_Content.dbo.alluserdata

WHERE (DateTime1 >= DATEADD(dd, DATEDIFF(dd,0,getdate()),0) AND DateTime1 < DATEADD(dd, DATEDIFF(dd,0,getdate())+1,0))

...

Doesn't look like a great config. How heavy's the SQL load going to be?

SQL doesn't work well with hyperthreading. SQL 2005 and 2008 are far better than 2000 was, but...

Without seeing the query, the table definition and the indexes (and preferably the execution plan, as a .sqlplan file), it's hard to offer any useful advice.

Raid 5 is not the best of ideas for transaction logs. Logs are write-heavy and raid 5 has the slowest write performance of any of the common raid levels.

If...

Just the admin DB. Unless there's a need to keep the proc in master?

You can't explicitly use the semi-joins. They're used by SQL when it processes an IN or an EXISTS. Both of those require that the contents be checked, but not joined,...

So you want it to appear on...

From the deadlock graph, you can see it occurred in the database with an id of 9 (that's why 9 was the first parameter to DBCC Page - DBCC PAGE(Database...

Meeting start date today, or meeting end date today?

Would this one fall into 18th feb or 19th feb?

Create a login for this purpose and give it rights on the objects needed. You can give it a very long, complex password, since it's not intended to ever be...

Use EXECUTE AS on the DDL trigger so that the trigger executes under the context of a login that has access to the admin DB and all objects involved. That...

nazaninahmady_sh (12/4/2008)

---

Thank you very much,

would you please help me to write a T_SQL block for transfering data from one table in one data base to another table in another data...