This issue is resolved by installing SP1:

http://support.timextender.com/entries/20833882-Computed-column-deployment-error-on-SQL-Server-2005-SP1

My answer: True-False

Give my points back!

I'm not agree.

With the TSQL evidence given (just " a part of " the command) the default behaviur is to assume a Clustered index.

For me is a tricky question.

Matt Miller (#4) (4/1/2010)

---

Ric Sierra (3/24/2010)

---

vk-kirov (3/23/2010)

---

PWDENCRYPT is a hash function, which means it's a one-way function. Once hashed, data cannot...

vk-kirov (3/23/2010)

---

PWDENCRYPT is a hash function, which means it's a one-way function. Once hashed, data cannot be restored. With cell-level encryption,...

Check out this links...

http://msmvps.com/blogs/gladchenko/archive/2005/04/06/41083.aspx

http://www.sqlservercentral.com/articles/Security/saveyourpassword/1420/

this undocumented function is available since SQLServer 7

so... what you think?

Well, could be better if someone in SSC takes some time to check the questions and answers before the publication. What you think?

Tricky question!

Lynn Pettis (9/15/2009)

---

Ric Sierra (9/15/2009)

---

Lynn Pettis (9/15/2009)

---

Ric Sierra (9/15/2009)

---

Just... keep simple!

If you need to delete a large number of rows and the scenario don't need to keep the database log.

In...

Lynn Pettis (9/15/2009)

---

Ric Sierra (9/15/2009)

---

Just... keep simple!

If you need to delete a large number of rows and the scenario don't need to keep the database log.

In this case I want...

Just... keep simple!

If you need to delete a large number of rows and the scenario don't need to keep the database log.

In this case I want to delete all the...

Char(1) is correct!!

Varchar(1) could be correct, BUT the info of the question gives a not null and not empty constraints, so all the time the field will have a value.

I...

Well, is a good trick of DATETIME field. But is a bad practice if you are looking for performance.

Instead of (if you work with MSSQL2005 or 2008) use the...

It's a nice topic.

The "tuning" is more than just apply the "best practices" to the T-SQL, but is the first step to try to improve the performance of your system.

Many...

I think the answer is just the change the text domain by varchar(max) -that's was my answer-

Because: "If you assume that there is no duplicate data across both tables, then...