I'd definitely restore and use the backup before I deleted the original files.

But rather than detach and delete the files yourself, just do a DROP DATABASE, which would be a...

It seems you do indeed have the proper clustering key.

Next I'd look at the missing index stats from SQL. You may be able to cover a large % of...

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