sql-server-2014 – Page 2

LocalDB SQL Server 2014 Express creates 2 instances (localdb)\ProjectsV12 & (localdb)\MSSQLLocalDB?

March 5, 2023 by Tarik

The (localdb)\ProjectsV12 and (localdb)\ProjectsV13 instances are created by SQL Server Data Tools (SSDT) and should not be used by applications (localdb)\MSSQLLocalDB is the SQL Server Express 2014/2016 LocalDB default instance name and an “automatic instance”. You can use the sqllocaldb.exe command line tool to manage which version (2014 or 2016) owns the MSSqlLocaldb instance And … Read more

Partition Function COUNT() OVER possible using DISTINCT

December 25, 2022 by Tarik

There is a very simple solution using dense_rank() dense_rank() over (partition by [Mth] order by [UserAccountKey]) + dense_rank() over (partition by [Mth] order by [UserAccountKey] desc) – 1 This will give you exactly what you were asking for: The number of distinct UserAccountKeys within each month.

SQL Server Management Studio won’t let me add an index to a table

December 14, 2022 by Tarik

Solution: Close your table designers and database diagrams and try again. If that doesn’t help, close all windows in Management Studio. Cause: The “New Index” option gets disabled when the table is schema-locked by the designer window.