I would check the data - visually validate if returned rows are the correct ones(*) or not, if not, check what is the query returning.

(*) correct...

what happens if you replace "left outer join sorels" with an inner join?

Koen Verbeeck (7/30/2013)

---

Grant Fritchey (7/30/2013)

---

A pretty common use of unique keys is when you have an artificial primary key for a table, the single most common example is the identity...

sahaamitabha123 (6/15/2013)

---

I have a database containing different product types. Each type contains field that differs greatly with each other. The first type of product, is classified in three categories. The...

... by making sure the connection can be established perhaps?

tomas.lojko 42279 (7/26/2013)

---

Hello everybody.

I need iso file of SQL server 2005 x64 trial version. In my company, we have 3 instances of sql server 2005 x64, but no install media....

'course you should.

Kazarf (7/29/2013)

---

Does anybody know any cases/example that we need to use UNIQUE KEY instead of PRIMARY KEY? I understand that UNIQUE KEY can allow one NULL value in the data,...

Databases are attached by using CREATE DATABASE blah blah blah FOR ATTACH so it should at least catch database...

OnlyOneRJ (7/26/2013)

---

Any script which will provide the below details of the JOBS??? as i have more than 100 jobs :w00t:

1. Job Name:

2. Start time of Job

3. Max time taken by...

Yes.

You can create a...

Go back to your original strategy but, fix your process, the first two tasks should go like:

- Disable the users which inserts and query

- Kill all sessions that are inserting...

Robin35 (7/26/2013)

---

Hi,

I'm trying to get the version and service pack details from all the sql server instances. I have a table which contains the list of sql servers....i just need...

bluefox (6/13/2013)

---

I have an application that connects to a SQL 2005 ENT Database. The app (running on a cluster like environment) on average runs 131 concurrent connections. I notice...

slash.young (7/23/2013)

---

So you are running MS SQL non enterprise edition, meaning you can not utilize true partition tables. You have a 1 billion record sales fact table that contains...