Did you? Would you care to share it?

Well it was always undocumented, so I suppose I shouldn't be surprised that it has...

There is an error in your code.

Without seeing what you can see (even...

Jeff Moden (1/13/2010)

---

Good article and makes a lot of sense... providing that the table doesn't have a lot of inserts where every index counts AGAINST inserts. Most people don't...

I bet you did :laugh:

The columns base_schema_ver and schema_ver in sysobjects change when an object is marked for recompilation.

Compare the values before and after you run your process.

Quite so. In so...

Assuming you don't mind using the Microsoft version of the Kuwaiti algorithm of the Islamic...

DECLARE @data

TABLE

(

col1 CHAR NULL,

col2 INT NULL

);

INSERT...

Seems to work fine for me:

DECLARE @Table1

TABLE

(

idno INT NULL,

id1...

Very nice link. I've never used single quotes in this way myself (just...

EAV - please Lord no!!! :laugh:

Have a look at 2008's Sparse Columns:

http://blogs.msdn.com/sreekarm/archive/2009/01/08/sparse-columns-in-sql-server-2008.aspx

http://technet.microsoft.com/en-us/library/cc280604.aspx

Efficient, built-in, and play nicely with XML. Awesome.

Paul

Lynn Pettis (1/12/2010)

---

Or, since this is SQL Server 2005, a DDL trigger on the three tables that dynamically rebuilds the view when ever one of the three tables is modified....

Something else to bear in mind about the OPENROWSET method:

Books Online

---

OPENROWSET can be used to access remote data from OLE DB data sources only when the DisallowAdhocAccess registry option is...

See Delimited Identifiers (Database Engine) for full details. Square brackets always work, double quotes depend on the setting of the session's QUOTED_IDENTIFIER set option.

Personally, I prefer square brackets where...