Viewing 15 posts - 781 through 795 (of 1,464 total)
July 26, 2018 at 12:45 pm
July 24, 2018 at 10:21 pm
July 19, 2018 at 1:43 pm
You have no indexes. So for EVERY select/update/delete, SQL has to do a full scan of the entire table in order to find the records to action.
In order to...
July 16, 2018 at 12:44 pm
Ed Wagner - Wednesday, July 11, 2018 12:44 PMTerminal
Deadly
July 11, 2018 at 11:13 pm
You really shouldn't use varchar(max) in this case. Have you ever come across a first name, or a last name that is longer than 50 characters?
You also want to normalise...
July 6, 2018 at 12:16 pm
Depending on the distribution of your data, this script by Paul White might be of use
Super-fast DISTINCT using a recursive CTE
July 4, 2018 at 5:28 am
July 4, 2018 at 4:19 am
Thank you Des. So if we use SUSER_NAME() then user logged into...
July 3, 2018 at 5:37 am
I have to write a procedure where I need to capture some data from application...
July 3, 2018 at 5:11 am
June 28, 2018 at 10:14 pm
If only i could, the SQL code is genereted in Java at runtime alas.
Good...
June 28, 2018 at 5:11 am
i'm having trouble separating the total query duration into SQL processing time and...
June 28, 2018 at 4:47 am
Viewing 15 posts - 781 through 795 (of 1,464 total)