Best format for SQL Server is 'YYYYMMDD', which is always interpreted correctly. Therefore, for literal dates, always use that format, do NOT do a CONVERT to a date/datetime type...

Would have to see your typical queries to be sure, but it's extremely likely the clustering keys are backwards, i.e., they should be ( timestamp, ident ) rather than...

It depends.

Do you want to check just the column(s) they are actually trying to UPDATE? If so, you can just re-read them and insure they haven't changed...

MyDoggieJessie (7/18/2014)

---

I feel kind of silly asking this but really don't know...does altering a column's length have any impact on non-clustered indexes that use it? More specifically, if I...

halifaxdal (7/18/2014)

---

ScottPletcher (7/18/2014)

---

I put a "\" (backslash) immediately followed by "n" in my previous comments, after the \r, but the site must remove it as some type of special editing...

One very specific no-no that I still see all the time:

Never use ISNULL() or NULLIF() in a WHERE clause or JOIN.

You should avoid any functions against columns whenever possible (because...

Look at:

IS_MEMBER ()

as well.

I think you would need authority to impersonate the user to test their group membership(s).

Read books, articles, etc., from/by Itzik Ben-Gan. Excellent!

I put a "\" (backslash) immediately followed by "n" in my previous comments, after the \r, but the site must remove it as some type of special editing character.

Try setting...

There's no "right" number of indexes per table. It depends entirely on usage.

You need to consider at least SQL's index usage stats and missing index stats. [There are...

halifaxdal (7/17/2014)

---

ScottPletcher (7/17/2014)

---

Since it's from SSMS, it's likely just a standard text file .rpt, rather than a Crystal Reports .rpt.

I suggest using SSIS to import that data. It will...

I'm thinking you're gonna have to...

You really need only a single ROW_NUMBER function:

SELECT

MAX(CASE WHEN row_num % 3 = 0 THEN LotNo ELSE '' END) AS Lot1,

MAX(CASE WHEN...

Yep, looks great, thanks!

Here's my scripted recommendations for index changes/rebuilds. I don't have time right now, but can explain more later if/when you have qs. Hope this helps!

------------------------------------------------------------------------------------------------------------------------

--Table:...

Since it's from SSMS, it's likely just a standard text file .rpt, rather than a Crystal Reports .rpt.

I suggest using SSIS to import that data. It will of course...