Thanks Chirag,

According to BOL, DBCC Cleantable "Reclaims space from dropped variable-length columns in tables or indexed...

You mean, when changing the datatype from fixed length to varying length?

I'd...

Thanks, Christian.

The padding of fixed...

Hi Daggles,

Yes, you can access sysobjects and other "system table" directly - except that they are in fact no longer system tables, but views. The real system tables are completely...

SELECT * FROM systables;

Msg 208, Level 16, State 1, Line 1

Invalid object...

Nope.

Until SQL Server 2000, sysobjects was a system table. As of SQL Server 2005, system servers...

Yeah, I once had to write code to manipulate some strings that might...

DBA Cabuloso (8/26/2009)

---

Which is the exact meaning of ESCAPE?

I thought it was to escape a wildcard that we would like to search. But the item didn't have any exclamation in...

If you ever need to search a database of newsgroup messages, you'll be delighted to...

I'm not. When you need to search for strings that include characters such as...

CirquedeSQLeil (8/25/2009)

---

This was a good question. I would have initially ticked the truncate table option but ran some testing and research first. Though accurate, I am not sure...

JacekO (8/20/2009)

---

Scary part is over 30% (at the time of this post) got it wrong. Many QoDs are quite tricky but this one is very basic and really not SQL...

I got my points, due to a lucky 50/50 guess. But I'd still like to know, what eexactly is the difference between

DeptId 2 data was updated,Deptid 5 row was...

Chad Crawford (8/6/2009)

---

Wow, that is interesting. I wonder what it is underneath that makes the difference. I'm cleaning up a lot of old data (horizontal and vertical), so...

Cliff Jones (8/5/2009)

---

Hugo Kornelis (8/5/2009)

---

You'll see that after the TRUNCATE TABLE, the space used is zero - but after the INSERT INTO, it is right back at its original size,...