Because you are wanting to capture this after a statement, you may want to use scope_identity() instead of @@identity.

http://blog.sqlauthority.com/2007/03/25/sql-server-identity-vs-scope_identity-vs-ident_current-retrieve-last-inserted-identity-of-record/

Not entirely sure, but that could be 1 problem in your logging.

Rows do not just "disappear," they have to be deleted. OR they are inserted in a transaction and not committed. Can you please post the script you are using...

My first concern is why you cannot determine a primary key based on your knowledge of the table and its use. It should have some sort of meaning to the...

I would say knowing that performance is the same, it should have been assumed. If they operated...

Charmer (3/28/2012)

---

SQLKnowItAll (3/28/2012)

---

You may not want to hear this... but I suggest hiring a consultant who can sit down and understand the business requirements and design this properly. We won't...

You may not want to hear this... but I suggest hiring a consultant who can sit down and understand the business requirements and design this properly. We won't be able...

Can you be more clear as to how these were installed; i.e. if you install BIDS from the original SQL Server licensed install, it is not trial.

1. Is this a...

S_Kumar_S (3/28/2012)

---

I too executed your query several times on a development server. Depending on load, either of them worked faster but the tests never convinced me that one is faster...

Lowell (3/28/2012)

---

here's one way to do it;

the typical chars you are looking for are highascii between 160 and 255;

here i'm just using a row_number() function generate a table of numbers...

Glad to hear! Thanks for the update!

S_Kumar_S (3/28/2012)

---

Hi

Can you pls guide to some link that shows this difference. Most of the places I know just say that the performance is similar. e.g this one:

http://www.informit.com/articles/article.aspx?p=31283&seqNum=4

SQLKnowItAll (3/27/2012)

---

S_Kumar_S (3/27/2012)

---

Using...

GilaMonster (3/27/2012)

---

SQLKnowItAll (3/27/2012)

---

GilaMonster (3/27/2012)

---

Same as SQL's old join syntax. Table1.Column1 *= Table2.Column2. Oracle syntax is Table1.Column1 (+)= Table2.Column2

sysdate is the Oracle...

GilaMonster (3/27/2012)

---

Same as SQL's old join syntax. Table1.Column1 *= Table2.Column2. Oracle syntax is Table1.Column1 (+)= Table2.Column2

sysdate is the Oracle function to...

Handle what? You want that data in a table? We need a lot...

Not sure what isn't working, since you did not tell us. However, after a quick look I think sysdate may be referring to some PERL function? SQL uses...