This is a matter of opinion. There is no reason a primary key MUST be...

Bill Talada (4/30/2014)

---

The number one rule of a primary key is that it must be "meaningless" yet unique. To be meaningless it must not be one of your four...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

Grant Fritchey (4/30/2014)

---

In some situations it will help performance to...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

eseeweb (4/30/2014)

---

Hi

I am very new to trigger. Not sure how i can do that. If possible, please help out. Is there any example or ideas on how...

Jeremy Brown (4/30/2014)

---

Honestly I don't feel as strongly one way or another. Fine, you want the object name first, go for it. You want the behavior first, fine...

I didn't even notice the NOLOCK hints littered throughout that. Do you know what that hint does? Are the users ok with missing and/or duplicated data occasionally when this runs?

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx

http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx

http://www.jasonstrate.com/2012/06/the-side-effect-of-nolock/%5B/url%5D

WOW!!! I hope your users don't mind going for lunch when they fire this thing off. You have nested cursors. Even worse is your inner cursor is recreated for every...

Jeremy Brown (4/30/2014)

---

I find more often than not, people go overboard on naming standards (in my honest and humble opinion).

I know I'm probably going to catch a lot...

eseeweb (4/30/2014)

---

hi to all

I had to agree that the reason for this trigger doesn't make sense. It is because we have 2 system.

a) the first system can...

LoosinMaMind (4/30/2014)

---

Hi,

Sorry for the delay in responding (meetings Urgghh!!! )

i have yet to try the suggested solutions. I will let you know how i get on.

One of you asked as...

If I understand you correctly you have an application which inserts a row into a table. Then you have a trigger on that table to copy the data that was...

SQLSteve (4/30/2014)

---

Sean Lange (4/29/2014)

---

SQLSteve (4/29/2014)

---

What is everyones view on accessing SQL data which is stored on SQL instances in the DMZ via management tools on your local desktop?

Would you put...

Glad you found something that works. Can you share your solution so that maybe it will others who stumble across this...