<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
QUOTED_IDENTIFIER
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,729 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,821 reads
Items 1 to 2 of 2
Tags
ansi_nulls
(1)
computed column
(1)
powershell
(1)
textmode
(1)
unexpected query plan
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
