m.henly (9/13/2012)

---

Hi Sean,

When the original developer put it all together (about ten years ago) and started to show me the basics of Sql, he told me to always use...

That may work short...

Because as you say you are an "Accidental DBA" and your query is full of nolock hints you might want to read up on the hint some more.

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

If you can...

I might add to that not to use select * and if at all possible change the name of your table to not use a reserved word.

select * from [order]...

bhushan_juare (9/13/2012)

---

[font="Times New Roman"]Hallo Everyone,

I am using an asp.net v2.0 application for which application pool, web site is created.

Every day multiple users logged into application for doing transactions doing this...

ChrisM@Work (9/13/2012)

---

ScottPletcher (9/12/2012)

---

There is NO case where I would ever want to use a GUID as a clustered key column.

It would have to be THE ONLY WAY POSSIBLE for me...

jane.frasier (9/13/2012)

---

I used the Access upsize wizard to split my database. I still wish to use the Access for the frontend and I don't want to have to go to...

Duplicate post. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1358585-149-1.aspx

Duplicate post. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1358585-149-1.aspx

Kenneth.Fisher (9/13/2012)

---

Sean Lange (9/13/2012)

---

Good question.

For everybody who seems to be hung on the verbiage I can only say "GET OVER IT". English is not the native tongue of everybody on...

honza.mf (9/13/2012)

---

Sean Lange (9/13/2012)

---

Good question.

For everybody who seems to be hung on the verbiage I can only say "GET OVER IT". English is not the native tongue of everybody on...

Good question.

For everybody who seems to be hung on the verbiage I can only say "GET OVER IT". English is not the native tongue of everybody on this site. I...

The same as any other query. What have you tried so far?

Take a look at the...

lareciadbell (9/12/2012)

---

I have 2 datasets from the same database in ssrs 2008 and I need fields from both datasets in one table. I achieved adding the fields from both...