What does this return:

SELECT

i.CreatedDate,

i.EffectiveDate

FROM

Inventory AS i

WHERE

i.InventoryReasonCode = 173

AND i.EffectiveDate...

VG-619426 (10/7/2009)

---

Insert in done through a stored procedure. Stored procedure does use this view, it just references the table.

But, the table is referenced in a view, which has a indexed...

I'd start by searching the MSDN and Technet sites for Cluster Configuration.

Okay, sorry but an empty string ('') is not the same as NULL.

I know that tables inside an ACCESS database can be accessed using linked servers. At a previous employer we attempted to execute inside an ACCESS database but failed as...

How is the insert being accomplished, actual T-SQL command or inside a stored procedure?

I thought so, and just verified it myself as well.

Roy Ernest (10/7/2009)

---

Yes, true... The final decision is theirs. I am not going to force my kids to change their minds... I am just hoping that they wont come with...

What are you trying to accomplish?

You know, if it paid well enough, I'd considering working in the UK for a few years. Been 28 years since I left, and I would love to come...

Looking at BOL for SQL Server 2000, I...

Roy Ernest (10/7/2009)

---

Congrats Lynn. You are a patriot as well. You are letting your offspring go into the army... 🙂 I am not sure how I will take it if...

Can you post the code for your view as well? Are you hardcoding the date parameters?

Haven't tested it, but it is possible the if a Full Backup and Differential Backup start at (or about) the same time, one may block the other until it is...

It depends. Are you getting reports of problems with queries being slow or sow response times in your application(s)? If so, instead of looking at the number of...