Ok, given the problems in my current strategy that have been pointed out, I'm going to abandon the idea of trying to get my primary instance running in my DR...

I'm not quite sure what the point of this process is. Is there a performance difference between indexing a bigint column and a datetime column? Why not use the datetime...

Here's a performance "gotcha" for that specific stored procedure: http://blogs.msdn.com/b/sqlserverfaq/archive/2009/10/30/sp-columns-take-longer-in-sql-server-2005-sp3-compared-to-sql-server-2000.aspx

Basically, if the database has a table with a name containing an underscore (or another wildcard character), that stored...

I've always avoided using the BETWEEN operator on datetime columns, because most of what I work with should not get any overlap at all between one "window" of time and...

Consider the following tables, and tell me how well this would work for you:

--It's likely this table already exists in your database, but I'm creating it again here as an...

The archive table is even less normalized than the current format. By doing it this way, it will definitely reduce your options in the future.

For example, it may not be...

My testing shows no problems for smalldatetime in my function. Casting a datetime to a smalldatetime rounds the datetime to the nearest minute.

Datetime: 2012-02-02 13:31:52.413

CAST to smalldatetime: 2012-02-02 13:32:00

CEILING...

This is in a function. I specify that it is a datetime datatype. If someone passes a smalldatetime value to it, it gets converted to a datetime.

I'm not able to...

How about:

SELECT c.* --Replace with the desired column list

FROM

/* Get list of all valid BuildingId, UserId combinations. I

assume that these are separate tables that are linked with a...

There's a couple reasons why I don't go that route.

#1: It only works on rounding up or down to the nearest day. My method will work on Seconds, Minutes, Hours...

Would this not work?

CAST(ISNULL(curamount/NULLIF(SUM(curamount),0),0)

OVER (PARTITION BY employeeid,docdate) AS decimal(10,4)) AS Total

If SUM(curamount) is 0, return NULL, else return SUM(curamount). X / NULL is NULL (Same...

I haven't used SSIS at all, so I'm may be completely wrong on this but, wouldn't it be MUCH cheaper to buy a copy of Developer Edition? How many users...

Keep in mind that the TIME datatype is not available in SQL Server 2005, only 2008 and newer. I realize that this is the 2008 forum, but you did ask...

Well, I haven't worked much with Powershell, but if your backups are stored someplace that the other SQL box has access to, you should be able to create a SQL...

What version of SQL server are you using for both servers? It may be that you have no need to use powershell for this. Would anything listed here work for...