How about you give your answer, then the experts here can have a discussion point.

sreenubabu.s (3/12/2014)

---

Some one restarted by Windows Server 2008. On which SQL Server has installed.

can any one tell me how to find who restarted the server ant what time ?

i did...

I only went part way because I often test things a step at a time to cut down the variables if I made a mistake somewhere along the line. ...

According to my faulty memory, part of the setup process was using local SQL login accounts that had the same name & password on both servers, not Windows accounts.

Just 1 tempdb file. I recall reading conflicting opinions, so I left it at 1.

To clarify, I do see the other processors working sometimes, but was surprised this time to...

Bad News: Not much memory

Good News: Approval to upgrade all our servers...

I can only answer a couple of those right now.

MAXDOP is 0, and Cost Threshold for Parallelism is 5. There was no blocking, but I know there was a long...

Perhaps you could declare a variable as DECIMAL(10,2) then set the INT column to the value in the decimal variable... a 2 step conversion.

Thanks

How big is the log file ??

How much free space in the database ?

No other backups running at the time. I can see backup history and the 2 that did run took 4 minutes just after midnight, which is normal. Combined, the...

I ran the select by itself when troubleshooting a few hours later & it worked fine. The next day, the job ran fine again as it has for more than...

Not quite sure what you're asking

Select * into Table_A from Table_B

Did you try my reply in your cross-post ? (which is generally frowned upon)

http://www.sqlservercentral.com/Forums/Topic1538824-392-1.aspx

I run this as a SQL scheduled job on my Windows 2003 server:

[font="Courier New"]ForFiles /P D:\objectscripts /D -180 /C "CMD /C if @ISDIR==TRUE echo RD /Q /S @FILE &RD...