With the inclusion of Python alongside R in SQL Server 2017 are we not all heading in a similar direction. I think whatever the title we're all data related professionals,...

I've seen cases like this before and you tend to find this type of code works fine until you reach a certain "event horizon" level of data. At this point...

"I wanted to know the thoughts of the MVPs " so you have an issue but want to avoid responses from the majority of the people who use this site....

If that's the query causing the problem would it not make sense to review the query and see if it can be optimised. I've only had a brief look but...

put a server side trace on the DB to see what is running overnight to impact the TempDB. If its happening everynight then you'll only need to do it for...

lancaster bomber

Why not add an extra column as specified earlier and then apply your logic to a case statement to populate the column.

You can then split the data out as required.

Or...

Here's another vote for multiple logins.

How about creating a new SA account with SA rights then revoke SA

Think I agree with both Koen and HanShi on this one, optimising the table is fine, however it is also worth looking at the code accessing it, removal of non...

try changing it to a domain account and seeing if that makes a difference the inference from the log is that its a permissions issue.

Other than that supply the windows...

Agree with Koen totally very sad state of affairs, and why can't men be good at deciding on the right shade of red for the curtains...

Hmmmm note to self possible...

Nice and easy if stuck the BOL is a good place to check out.

When you do the save, have you checked to make sure the file type under the filename in the save as dialogue is .SQL and not .TXT ?

Delete and truncate go deeper that that, they also have a major impact on things like Identity columns that need to be taken into account.

Well worth a read when optimising for large datasets

http://technet.microsoft.com/en-us/library/cc879317(v=sql.105).aspx