Search for a command to run...
Articles tagged with #sql-server
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 to rebuild. Less than 8 pages If an index is very small (less than 8 pages) it will use mixed extents...
Which is a good collation for Turkish?
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 clustering key isn't optimal, since due to its randomness, it will lead to massive page and index frag...
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 think varchar should be used because it takes up less space. I believe this is not the correct answer. ...
SQL Server 2022 introduces Parameter Sensitive Plan Optimization (PSPO), a feature that revolutionizes the performance of parameterized queries. With PSPO, the SQL Server stores multiple execution plans for a single query, each tailored to different ...
View query_plan for the just-running query DECLARE @SearchForSql AS NVARCHAR(MAX) = 'Company' SELECT UseCounts, Cacheobjtype, Objtype, TEXT, query_plan FROM sys.dm_exec_cached_plans CROSS APPLY sys.dm_exec_sql_text(plan_handle) CROSS APPLY sys.dm_e...
