Viewing 15 posts - 1 through 15 (of 49,571 total)
Gail, you hypothesized “You should use integers for the key rather than strings. The joins will be faster.”
If you read the blog post, the hypothesis was "integers are easier...
September 12, 2019 at 8:33 am
she then concludes that these results should all but put the nail in the coffin on integers vs naturals keys. This is NOT a valid conclusion to draw....
September 11, 2019 at 6:03 pm
Gail Shaw wrote:Steve Jones - SSC Editor wrote:Well, with the new leaderboard (https://www.sqlservercentral.com/contributors), we have our first millionaire.
Yay. Um, so what are those points redeemable for again? 🙂
Everlasting Glory!
I hope not...
April 8, 2019 at 4:37 pm
Probably a damaged database file. It's one of the things that can go wrong when you detach a corrupt database.
April 8, 2019 at 4:06 pm
Well, with the new leaderboard (https://www.sqlservercentral.com/contributors), we have our first millionaire.
Yay.
Um, so what are those points redeemable for again? 🙂
April 8, 2019 at 4:04 pm
No, with the exception that the primary key is unique and your other index is not.
Other than that, they'll work identically.
April 5, 2019 at 6:21 pm
Not necessarily true. Indexes can also allow SQL to avoid a sort (and sorts are expensive operations).
Which is completely irrelevant, as neither of the queries given in the OP...
April 4, 2019 at 5:46 pm
Run 1, because the index is useless. Indexes are for reducing the rows read, they have no value at all when you don't have a where clause filtering the rows.
April 4, 2019 at 3:03 pm
Physical stats returns data about the physical layout of the index in the file, but the other two are memory-only and hence not included in a backup and cleared when...
April 4, 2019 at 3:01 pm
Can't help you with the memory, but disabling the cores in the BIOS is not apparently sufficient to reduce licensing. Create a VM and license that, or remove cores (physically).
The...
April 4, 2019 at 3:00 pm
Or use TRY-CATCH for error handling.
No need to check @@Error, no need for SET @ErrMsg = OBJECT_NAME(@@procid) (use ERROR_PROCEDURE()), no need for GOTOs
BEGIN TRY
INSERT Whatever ...
....
END TRY
BEGIN CATCH
SELECT ERROR_NUMBER(), ERROR_MESSAGE(),...
April 3, 2019 at 6:27 pm
I like using sa as the database owner. Since sa already has all permissions, you can't accidentally give extra permissions by doing so. It's not escalating any privileges, it's not...
April 2, 2019 at 9:33 pm
Indexes aren't going to help here, because the server is not having any problems.
System.OutOfMemoryException is a .net error. The client tool that you're running this query from is...
January 20, 2019 at 3:50 am
Logins, no. Permissions, yes, so that you can apply that script after doing the refresh.
January 20, 2019 at 3:29 am
January 18, 2019 at 10:37 am
Viewing 15 posts - 1 through 15 (of 49,571 total)