Admingod (7/22/2014)

---

Thanks it worked! So here we are not moving the file to different location.

That means we are just altering the file size with following command.

ALTER DATABASE tempdb MODIFY...

You can adjust the tempdb file(s) size using the following commands. The changes will be in effect the next time SQL Server starts.

--EXEC tempdb.sys.sp_helpfile --to list the logical file...

Btw, for date/datetime, don't use "<=" on the end date, use "<".

In this case, instead of:

[DATE] <= (DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)))

do this:

[DATE] < (DATEADD(mm, DATEDIFF(m,0,GETDATE()),0))

I think that's one of the most value-added and differentiated...

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...