Question : I’m trying to figure out how to set up the structure for users. Users can have multiple Managers […]
Author: admin
Reusing covering index for fields in FROM, from another query’s index
Question : For the following query I have a covering index as so: SELECT bar_id FROM foo WHERE user_id=:user_id AND […]
Calculation With VARCHAR
Question : I am attempting to do a calculation in SQL Server 2008 R2 but I keep getting an error […]
How to verify a SSAS Backup and how to perform Integrity Checks in SSAS?
Question : I have a procedure to backup SSAS Databases that is working successfully. I also delete the SSAS backup […]
How to re-include excluded folder in SSDT-BI / Visual Studio 2013 database project?
Question : I’ve selected “Excluded from project” on a folder with tables (database was imported first into project). Now I […]
SQL Server Management Studio 18 won’t open (only splash screen pops up)
Question : I just installed SSMS 18 GA on a computer with only VS2019 installed, and when I try to […]
How to repair corruption for “Possible chain linkage problem.”
Question : I have large table with 15 000 000 record and suddenly Select Top stopped working. I use MS […]
Is there a way to rewrite this MySQL query to use window functions, and not use session variables?
Question : I have the following query drop table if exists tradesAndActions; create table tradesAndActions (transik int, ca_date date, terms […]
Is there any way to prevent the memo structure from being pruned?
Question : We know that the memo structure is pruned and some expensive alternative plans are discarded during optimization. I […]
Check constraint on nullable data, how to approach?
Question : This is one of the tables in my database. Constraints omitted for clarity. CREATE TABLE [Person].[Person] ( [ID] […]