I like the article over all and it is definitely addressing a significant topic, but unless I am missing something, you do have relatively an easy way to enforce the...

I...

You may wish to set up triggers to log whatever level of detail you may need in a separate table.

Of course, the transaction log itself will hold all of that...

I may be missing something. From what I understand, all you need to do is write the query itself, in which you case you just write the query. ...

Can you be a little more specific?

In...

The optimizer treats a CTE almost exactly the same way it does a subquery, which is why you would get the same performance from a CTE and the subquery version.

You might want to look at adding a schema.ini file in the same folder with the text file you are importing and use the schema.ini file to force it to...

CTE (Common Table Expressions) were introduced in 2005 and can make certain things easier.

I cannot think of any way to speed it up immediately.

Matt Miller (12/6/2007)

---

Total disregard for the physical layer implementing this is precisely why something like this is a bad example of set-based (in my mind not even deserving of...

You can use a subquery or a CTE. Either one will do the same thing, but the CTE is more readable if you are using SQL Server 2005.

For instance:

;...

I have not taken the 431 in particular, but in preparing for multiple other computer certifications and of course the classes in college I find it helpful to make an...

The best way to do this is to have an identity column and then have a calculated column that adds whatever prefix you need to the identity. If you...

alien (11/28/2007)

---

hi,

For creating the unique key we are using the function UuidCreate() which always generated the unique charecter. We are using the same mechanism for both SQL...

It was an awesome article. One point I would reemphasize is the customer service piece. Things will go much more smoothly if you are willing and able to...

Clive Strong (11/29/2007)

---

Check out the microsoft sites for the content. Also check Amazon for the study guides.

Also, I disagree that you need certification...Its a nice to have and yes,...