I can see how the physical row id would be useful for debugging or performance tuning purposes, like...

stephen.lear (7/27/2011)

---

I think the reason you can't access the internal ID is that it can change when a reorganization takes place. So you'd break any integrity that relied on the...

mar10br0 (7/27/2011)

---

paul.knibbs (7/27/2011)

---

I'm not sure increasing the row length in SQL would help much--after all, the largest data types are stored in off-row data pages anyway, and a properly normalised...

cengland0 (7/26/2011)

---

Steve Jones - SSC Editor (7/26/2011)

---

That's so dependent on the indexing, the query structure in places, it's hard.

I supposed you could set up the same hardware, same data set...

Jeff Moden (7/25/2011)

---

For all those balking about column order not mattering in a table, I absolutely agree when it comes to programming.

But, for troubleshooting, it's sometimes very helpful and can...

Clustered vs. Heap, fill factor, fragmentation, and several other factors may influence how the actual size of...

cengland0 (7/26/2011)

---

Revenant (7/26/2011)

---

cengland0 (7/26/2011)

---

Does anyone have a link to the performance differences for all the different database products out there? I heard a rumor that the MS SQL license...

Efficient relational database design is about constraints, normalization, and discrete data types. The problem faced by companies like FaceBook is not that their databases are large or that they have...

Jo Pattyn (7/25/2011)

---

Most people like to work from home/other room when they are interrupted too much or need a focus day, as most of the interruptions start with "Is person...

If your intent is to generate unique integer values for use as a surrogate keys, then I'd reccomend IDENTITY over some function that returns a random number. An identity value...

Chrissy321 (7/24/2011)

---

Hello All,

I have a requirement to build a user interface that will allow end users to generate and issue UPDATE statements. I am fairly certain I need dynamic SQL...

With Outlook 2007, I can create "Search Folders", which are sort of like views my inbox. If an email is addressed specifically to me, or specific team members are in...

The obvious requirements for a "SQL Server Developer" would be to know relational database concepts and how to write SQL. Start with a book on generic RDMS theory, data modeling,...

I suspect there is something in the other four databases that reference the CONFIG database. Trying running a SQL Profiler trace filtered on the database object CONFIG, and then have...

Reading email doesn't necessarily have to involve preemptive multi-tasking. The developer can read and reply as they come in, or he can just let them queue up for a couple...