Upper case reminds me too much of COBOL, plus I don't like having to hold the shift key while typing or using the caps lock.

Natural Keys vs Surrogate Keys

Here's a battle. I like the idea of using Natural Keys, but sometimes thoses are the best choice as they can change which affects historical...

sqlguru (7/7/2009)

---

Actually, it's not.

The DB automatically creates the foreign keys between the two tables BUT it is not seen by the...

I like it because you get in and get out as quickly as possible.

Okay, but what edition?

sqlguru (7/7/2009)

---

These are two of the most fundamental features needed for SQL Server in terms of administration, developing, performance.

Pointer-based foreign keys

The relational model has no place for surrogate keys. When...

What edition of SQL Server, and what have you written so far to meet your requirements?

ChandraMohan Nandula (7/7/2009)

---

Hi,

I did not find any articles related to sql server 2005 architecture here. Even in the forums when a user ask about the sql...

I think I'd do it more like this:

declare @NextProductID int;

update dbo.ProductsSequence set

@NextProductID = ProductID = ProductID + 1

from

dbo.ProductSequence with (tablockx)

where

...

I think he is asking about the naming conventions used for naming the transaction log backup files, but I could be wrong.

I'm not a zealot, and i don't have any supporting documentation. What I will tell you is that you will get a lot of differing opinions on the matter.

I...

we still need to see the different scenarios that may be present inthe values provided in the variable.

Haven't tried it or fully researched it, but I don't think you can convert an existing table into a partitioned table. If this is possible, I'd love to see...

Double posted. Please post reponses here.

hi_abhay78 (7/6/2009)

---

As per this MSDN , yes its not supported .

http://msdn.microsoft.com/en-us/library/ms165636(SQL.90).aspx

But there is a tweak 🙂

Copy DatabaseMail90.exe, DatabaseMailEngine.dll and DatabaseMailProtocols.dll into the MSSQL\Binn directory and execute below mentioned system...