I think that since you are interested in number of week of the date and not the date it self, you can add 7 days in the recursion.  Then you...

The index is using the columns that the clustered index is based on as the pointers to the row in the table.  Since by default the primary key is also...

You can use the convert function instead of the cast function and within the function use the style to determined how the date should look like.  Because the date is...

It relates.  Rebuilding index and updating statistics could bring lots of pages into the memory (depending on index and table size and in case of statistics update the size of...

I didn't check it for a long time, but as far as I remember the GUI creates a new table, copies the data to the new table, drops the old...

The problem was not caused because you are using isnull and left together.   It was caused because your table is using the text data type.  Text data type should...

If you know that your file grows about 1 GB every 3 days, then why not just give it about 150GB so you won't have to worry about it for...

You can find a way to change the location of the error logs here –  https://sqlandme.com/2013/07/08/sql-server-how-to-change-sql-server-errorlog-location/.  I have to admit that I never tried it.  Also you wrote that...

I'll might be missing something but I think that a simple select with range will do it:

SELECT distinct * FROM StgTemp where (ID >='3500' and...

You can change the database's ownership without an worry, but I have to admit that I think that you applicative users got way to many permissions.   There is no...

I'll might give some developers the permissions to use Profiler on development environment.  It will have to be developers that I trust that they know how to use it and...

Sorry, you are correct.  I didn't look at the statement and only read that you killed the process and that the status is killed\rollback.  My mistake.  Looks like a problem...

You can only wait.  The rollback has to finish and you can't kill a process that is in the middle of rollback.  

Adi

The users' permissions are stored in the database so the users won't loss there permissions, but you'll might have another problem.  Each user has a unique SID that is mapped...