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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 11, 2019 at 6:03 pm
Gail Shaw wrote:Steve Jones - SSC Editor wrote:Well, with the new leaderboard (https://qa.sqlservercentral.com/contributors), we have our first millionaire.
Yay. Um, so what are those points redeemable for again? 🙂
Everlasting Glory!
I hope not...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 8, 2019 at 4:06 pm
Well, with the new leaderboard (https://qa.sqlservercentral.com/contributors), we have our first millionaire.
Yay.
Um, so what are those points redeemable for again? 🙂
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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(),...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2019 at 3:50 am
Logins, no. Permissions, yes, so that you can apply that script after doing the refresh.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2019 at 3:29 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 18, 2019 at 10:37 am
Viewing 15 posts - 1 through 15 (of 49,571 total)