j_maloney (1/7/2014)

---

I'm trying to reduce the overhead in some table triggers. I was hoping to replace audit-trail functionality w/ CDC but doesn't look like it will work unless you're...

SQL Guy 1 (1/7/2014)

---

I need to increase fragmentation level for an index. This is in production, and the table has a lot of FK relations, so I can't do...

Not really sure what you are looking for here. Please take a few minutes and read the first article in my signature for best practices when posting questions.

I would recommend...

Luis Cazares (1/7/2014)

---

Sean Lange (1/7/2014)

---

I am guessing that what you really want is all the rows from the function and values from the table if there is a match?

This is...

I am guessing that what you really want is all the rows from the function and values from the table if there is a match?

This is where you can turn...

I would recommend NOT inserting the data into your table. You will be fighting a losing battle. You are going to have a real challenge ensuring that the "missing" data...

Well Jeff is the captain of the guard so all we need is a few...

arsalanayub (1/6/2014)

---

Hi I am no DBA, but we are facing an issue with an application that eventually loops a piece of code which keeps writing records to the db until...

Vincent_Poirier (1/6/2014)

---

I have 2 databases that contain some duplicate data.

One is a ODS and the other is a DW.

Both are located on the same server.

I have a dispatch table in...

Lowell (1/3/2014)

---

Ok Sean, I'm revisiting your ITVF version of this function, and seem to have a problem with it when the data does not have the data at the assumed...

sqlnaive (12/23/2013)

---

The solution provided looks good. However in my actual scenario, there are around 15-20 columns in master table (all have to be included) and around 30 columns in details...

Tamil Vengai (12/23/2013)

---

create TABLE #temp(LoadTemp1 int,LoadTemp2 int,LoadTemp3 int,LoadTemp4 int,[TimeStamp] datetime)

INSERT INTO #temp VALUES

(300, 200, 100, 320, '12-10-2013 13:30:29'),

(100, 250, 113, 340, '12-10-2013 14:20:12'),

(114, 339, 209, 345, '12-10-2013 14:45:01')

declare @Threshold...

wolfkillj (12/20/2013)

---

Andrew Notarian (12/20/2013)

---

I think we phone screened that person for a job once. Every question resulted in awkward silence, then some non-related babble, followed by an extremely well...

GilaMonster (12/20/2013)

---

Can I have "Questions you need to hire...