Change the Settings of a Database Object Using Powershell
This post tells you how to change the QUOTED_IDENTIFIER and ANSI_NULLS settings of a database objects using Powershell.
2013-05-28
2,804 reads
QUOTED_IDENTIFIER
“QUOTED_IDENTIFIER” causes Unexpected Query Plan for Persisted Computed Column query
In this blog, you will see the reproducible steps that reveal the following observation: “If the table has a persisted computed column*, the query optimizer will choose a clustered index scan over a clustered index seek.”
2011-10-28
2,092 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Menara ImperiumTelepon 083110611866
WhatsApp 083110611866Jl. H. R. Rasuna Said No.Kav. 01, Guntur, Kecamatan Setiabudi, Kota Jakarta Selatan,...
BCA KCP Mal Ciputra TLP/WA 08216977701
Mal Ciputra, Jl. Arteri Jl. Letjen S. Parman No.28 LG II No. 24, Slipi,...
BCA KCP Batu Ceper No tlpon:083138717148
Whatsapp:083138717148.Jl. Batu Ceper No.18 A-B, Kb. Klp., Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers