Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag QUOTED_IDENTIFIER Rss

   Items 1 to 2 of 2   
 

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.  Read more...
By Ravi Kumar SV 2013/05/28 | Source: SQLServerCentral.com | Category: quoted_identifier
Rating: |  Discuss |   Briefcase | 1,990 reads

“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.”  Read more...
By Additional Articles 2011/10/28 | Source: SQLCAT | Category: quoted_identifier
Rating: (not yet rated)  Rate this |   Briefcase | 1,884 reads
   Items 1 to 2 of 2   
 
Tags
ansi_nulls (1)    
computed columns (1)    
powershell (1)    
textmode (1)    
unexpected query plan (1)