having seen my share of queries with too many joins, can't you just use foreign keys to cut down on the number of joins?

it's a varchar column in this case

barunpathak (10/20/2009)

---

Yes. That worked. Now my questions are

1) Seems like it has problem with the Key word FROM. As soon as I put in FROM, it fails. This will...

Ellen-477471 (10/5/2009)

---

Have there been any significant issues reported with any of the cumulative updates? We are planning to apply SP3 -- CU 5 this week and wondered if there...

isn't this most vendors?

i did some studying for SQL 2005 with the MS Prep kit and noticed that a lot of the questions on the CDs are exactly the same between them

few years ago Emulex and Windows 2003 x64 SP2 had an I/O bug and it caused one of our servers to lock up and reboot. MS released a series of...

we always install the HP management software, anti-virus, Emulex HBA Anywhere. The HP software also installs a light version of Apache or Tomcat, forget which one. a lot of people...

thx

haven't looked at the preplogic yet. still on my hard drive and i've been studying with the prep kit.

we had this when we first went to x64 and there was almost nothing on the internet to document the differences except a MSDN blog post by a Microsoft developer...

i run this on a few servers and then there is a job to transfer it to a central server and truncate the data on the source.

insert admindb..tblsupersysprocesses ( session_id,...

it's a PITA but you have to check each login failure with event ID 18456 in the app log on the server. what sucks is that the view may return...

Chris.Strolia-Davis (10/7/2009)

---

SQL Noob (10/7/2009)

---

is there any performance difference doing a union all compared to a join when you need to get all the rows from two or more tables? i...

David Walker-278941 (10/7/2009)

---

Yet another article that makes people think that table aliases (t1 and t2) are part of the required syntax. This first Join statement:

SELECT t1.key1, t1.field1 as Name,...

is there any performance difference doing a union all compared to a join when you need to get all the rows from two or more tables? i have a database...