Viewing 15 posts - 1 through 15 (of 1,478 total)
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...
October 10, 2017 at 8:23 am
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...
June 27, 2017 at 9:30 am
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...
June 13, 2017 at 9:32 am
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...
March 30, 2017 at 5:07 am
March 19, 2017 at 4:37 am
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...
March 19, 2017 at 4:16 am
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...
March 16, 2017 at 7:12 am
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...
March 16, 2017 at 1:59 am
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...
March 14, 2017 at 10:14 am
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...
March 7, 2017 at 4:18 am
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...
February 19, 2017 at 9:28 am
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...
February 14, 2017 at 9:06 am
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...
February 13, 2017 at 1:39 am
You can only wait. The rollback has to finish and you can't kill a process that is in the middle of rollback.
February 13, 2017 at 1:19 am
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...
February 12, 2017 at 2:33 am