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,549 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
RE: "Disappearing" Table. Why?
I posted a reply last week, am sure I saw it here for a while but now gone. From quick google search I believe this behavior is MDAC dependent, so only safe way to proceed would probably be something like this "if @@transcount > 0 commit" whenever you make modifications w/in OpenRowSet. It bothers me […]
2004-02-02
2 reads
RE: pages clustered/non-clustered index
Point blank a nonclustered index will always read more pages as oppossed to a clustered if there is a clustered index on the table as well. The reason is the nonclustered index use reference points to the clustered index and must cross it to get to the exact leaf pages needed.
2003-09-04
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers