I had a similar requirement, and FTS was the way to go. Only way the performance would get close to being reasonable. A LIKE with % on both...

I have seen it at one of the Big 3. And I actually agreed with why they did it. They had so many disparate systems that you could...

I would also take into consideration what is accessing the data. Entity Framework in .NET positively hates compound primary keys when generating POCO classes. Therefore, by default have...

boehnc (10/25/2012)

---

I have the following table and fields:

Table: tbl.transactions T

Fields: T.visitid, T.diagnosiscode

It looks like this:

visitid, diagnosiscode

1111,34.0

1111,68.0

1111,34.2

1112,34.3

1112,45.0

1112,23.4

I need to identify the individuals that have CHF or pneumonia for each visitID. The...

PiMané (10/25/2012)

---

Hi,

I was trying to get a "rule" for table naming but it's kind of hard to do it since every case is a casa...

You can have a table Customers...

selvakumar.sms (10/25/2012)

---

hi all

I have ON INSERT and UPDATE trigger for my table,if i update any column or inserting any rows in SSMS, trigger is working well, but i...

baabhu (10/19/2012)

---

Hello,

I have a SQL job that deletes 10,000 records in batches of 1000 rows for every 4 minutes.

There is another job that updates the record for the...

jefferyweeks 30481 (10/18/2012)

---

Hello All,

I am new to SQL Server management and I created a BIDS package that accesses QuickBooks and pulls data into Excel. The package runs fine in...

Luis Cazares (10/18/2012)

---

I forgot to complete the condition, it's corrected now.

kapil_kk

---

how to fetch one by one row using...

Sergei Zarembo (10/12/2012)

---

Can I interpret a high value of load factor calculated as

SELECT AVG(load_factor*1.0) as avg_load_factor

FROM sys.dm_os_schedulers

WHERE scheduler_id < 255

..as some indication of work load on the server?

I currently se...

For older environments or other than T-SQL flavor, more generically would be something like (untested):

SELECT c.Accountno,C.Company,C.Contact,C.Recid,H.lastuser,H.lastdate

FROM contact C

LEFT JOIN history h ON C.accountno=h.accountno

LEFT JOIN (SELECT accountno,MAX(lastdate) AS lastdate

...

If it is indeed SQL Server... I would think a long look at the MERGE INSERT/UPDATE command would be beneficial.

Very handy 😀

There are so many WTF's here. First, the argument where you can only access through views has been thoroughly debated and debunked, it shouldn't be held to high here,...

FYI:

The query plans in 2000, 2005 and 2008R2 all appear to be the same regardless if I use IN (x,y,z) OR use or X or Y or Z.

Using UNIONs...

Suresh Kumar-284278 (6/21/2012)

---

Hi,

I am currently working for retail client and primarily on SQL 2008 DB designs though their applications are spread across 3 different DBs (SQL Server 2008, DB2, ORACLE)

I...