Ewald Cress (7/27/2011)

---

David Walker-278941 (7/27/2011)

---

Ewald Cress (7/27/2011)

---

Back on the secondary subject of larger pages, I guess the obvious argument against them would be buffer cache wastage. If you have hundreds...

Ewald Cress (7/27/2011)

---

Back on the secondary subject of larger pages, I guess the obvious argument against them would be buffer cache wastage. If you have hundreds of often-used lookup/dimension tables...

Jakub Dvorak (7/21/2011)

---

See this schematic "code":

1) Pull data from fixed tables to temporary structures (used for sharing) only once

2) Perform complex logic above temporary structures

Point 2) includes calling to many...

Jakub Dvorak (7/21/2011)

---

Agree, but you must also include performance aspect. If I use solution you described it would mean that for every call of this function I would have to...

Jakub Dvorak (7/21/2011)

---

Practical example behind this article was following:

I needed to share data among stored procedures because I had very complex task which required to pull data from fixed...

I believe that the method in the original article is documented as unsupported by Microsoft, and is subject to change, and it may not work in future releases of SQL...

Frank-461314 (4/5/2010)

---

Hello,

I have a 6 billion row table that I want to partition. My question lies with the clustered index and partition key. I want to partition on...

In SQL 2008 Object Explorer, if you right-click on almost any "node" (Databases, a particular database name, a server name, the nodes called Tables, Views, etc.) you'll get a menu....

GilaMonster (11/23/2010)

---

cengland0 (11/23/2010)

---

Doh, I just discovered the maximum key length is 900 bytes so combining two VARCHAR(500) columns into one index results in a warning:

The maximum key length is 900...

cengland0 (11/23/2010)

---

Doh, I just discovered the maximum key length is 900 bytes so combining two VARCHAR(500) columns into one index results in a warning:

The maximum key length is 900 bytes....

"This does not mean that the index 'NonClust_Contact_Name' was not useful. It's still much better than the Clustered scan."

*WHAT* is still much better than the clustered scan? I'm confused...

OK, well, I see that we disagree. People who are smarter than I am (who write books on the guts of SQL, for example) also like GUIDs. I'm...

I originally didn't like GUIDs because I thought they used too much "space". They really don't. Disk space is cheap, and GUIDs are only 16 bytes long.

The nice...

Thanks.

The link to "sql.soendergaard.info" says "no scripts found".