Other than the "keep dev away from Prod boxes" and the issues with performance this might cause - there's no reason I know which would prevent it.

I'm not sure I'm getting all of the nuances here, but this sounds like a counting game problem. It also sounds like there are relations you haven't which would...

Nothing I can't live without for a while. Just kind of an interesting view into the forum when I as a regular user can go check to see who...

SELECT * Into #temp

FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',

'Data Source="c:\abc.xls";

User ID=Admin;Password=;Extended properties=Excel 8.0')...Sheet1$

Meaning -

1. Keep the customer table as is for tracking CURRENT info.

2. At the point in time when an order is processed <snapshot> the relevant fields from...

Well -

TRUNCATE_ONLY is the syntax applied when you don't want the log actually backed up (you just want the truncate, not the backup). That's why I find the...

Agree with Ninja - separate.

I usually force "code integrity" by using relational integrity (i use foreign key constraints on the fields holding said codes), so I almost always split the...

Possibly the "most straightforward" might be to build a CLR UDF implementation of Regex.replace.

Imports System

Imports System.Data

Imports System.Data.SqlClient

Imports System.Data.SqlTypes

Imports Microsoft.SqlServer.Server

Imports System.Text.RegularExpressions

Partial Public Class UserDefinedFunctions

<Microsoft.SqlServer.Server.SqlFunction()>_

...

well - for better or for worse - Min( [varchar]) returns the [varchar], so you could use that as your aggregate. Assuming you can make sure that the grouping...

Well then - it sounds to me that you want that recorded as part of the invoice itself. Meaning - if the ONLY place you care about having the...

well - unless I'm completely off of the boat - OP is looking to do some fancy aggregation. He's trying to get a summary of the promo's on...

I guess the question is - what's important within the context of the application? Is it important to be able to recreate past invoices with exactly the data that...

Also - don't discount solar. The price tag can be very high, but there seem to be a lot of overlapping grants/incentive programs to get it put in. ...

Just remember - you can have a UNIQUE index with nullable fields. It cannot be a primary key however. Primary keys don't allow any nullable fields (even if...

Well - it doesn't help that I didn't notice the word DATABASE in database mirroring. That being said:

Well to setup a SQL Server cluster you have to purchase a...