#sql-server
Read more stories on Hashnode
Articles with this tag
There may be 2 reasons for this. The first is that the index is less than 8 pages, and the second is that there is not enough space on the hard disk...
Which is a good collation for Turkish? · Quick Answer: Turkish_CI_AS CI : Case insensitive comparisons so 'ABC' would equal 'abc' AS : Accent sensitive,...
Quick Answer : Do not use GUID as primary key As Kimberly Tripp - the Queen of Indexing - and others have stated a great many times - a GUID as the...
Quick answer : Do not use varchar ! A nvarchar column can store any Unicode data. A varchar column is restricted to an 8-bit codepage. Some people...
SQL Server 2022 introduces Parameter Sensitive Plan Optimization (PSPO), a feature that revolutionizes the performance of parameterized queries. With...
View query_plan for the just-running query DECLARE @SearchForSql AS NVARCHAR(MAX) = 'Company' SELECT UseCounts, Cacheobjtype, Objtype, TEXT,...
