Viewing 15 posts - 1 through 15 (of 1,479 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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 30, 2017 at 5:07 am
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 12, 2017 at 2:33 am
Viewing 15 posts - 1 through 15 (of 1,479 total)