Grant Fritchey (3/24/2016)

---

There's nothing wrong with triggers... used appropriately. Same thing goes for just about every other object within SQL Server (except multi-statement table-valued user-defined functions, those things are pure...

My money at this point is on an interview question. Either taken from the...

Without looking at the actual script, just commenting on the generic process.

One way to achieve what you want is to use a view instead of a table per the "parent"...

The WITH INDEX clause is a so-called index hint. "Hint" is the name, but it is actually a directive. You are saying to SQL Server: "I know that thousands of...

Then two obvious fixes are to replace SET @AcctMgrID = '' with SET @AcctMgrID = 0, and to remove the...

Thanks, Drew! It does not work that way in Dutch, which is why I used the wrong form.

I guess English is better in this then Dutch, because here we never...

In my opinion, the commonly heard arguments against triggers are mostly from a practical angle:

1. Triggers are bad because you can easily mess up - change a row somewhere and...

Jacob Wilkins (3/23/2016)

---

Hugo Kornelis (3/23/2016)

---

...

WHERE LEN(ISNULL(sfl.ConvertedContactId, '')) < 1

Alan already commented on this. I see this type of WHERE clause more often and it always me angers me. Just think...

I would start by using bcp to create a format file, as described here: https://msdn.microsoft.com/en-us/library/ms191516.aspx

Double check the format file, then use it as a parameter for the BULK INSERT command.

Sorry, but that...

When posting the execution plan, please post the plan, not just a picture of it. Capture an actual plan, right-click and choose save as, then attach the .sqlplan file that...

mceventphoto (3/23/2016)

---

Hi Hugo,

Thanks for the feedback. The values represent six working days (days of the month) and are initially stored in a table. This can be sorted. A report is...

Without CREATE TABLE statements for the tables and INSERT statements for sample data, and with no posted exact required output, you are leaving a lot to the imagination.

However, if I...

New persopn (3/23/2016)

---

This not for one server we have total 2000 server and we have to capture it for all the server and we have to store that information in...

When multiple files are in the same filegroup, SQL Server will...