Viewing 15 posts - 2,986 through 3,000 (of 3,348 total)
elbedata (9/4/2009)
You mean, when changing the datatype from fixed length to varying length?
I'd hesitate to describe an unasked for removal of trailing spaces "smart". There are builtin functions to remove...
September 4, 2009 at 3:47 am
Chirag (9/4/2009)
That was a good one. Guess DBCC Cleantable also wouldn't help in this case.
Thanks Chirag,
According to BOL, DBCC Cleantable "Reclaims space from dropped variable-length columns in tables or indexed...
September 4, 2009 at 2:37 am
elbedata (9/4/2009)
I thought SQL Server was "smart enough" to remove the trailing spaces. You always learn something new here...:-)
You mean, when changing the datatype from fixed length to varying length?
I'd...
September 4, 2009 at 2:35 am
Christian Buettner (9/4/2009)
This was a very nice one! Out of curiosity - did you realize this via testing or is there official info somewhere in BOL?
Thanks, Christian.
The padding of fixed...
September 4, 2009 at 2:33 am
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...
September 1, 2009 at 1:21 am
vinuraj (8/28/2009)
sysobjects are system tables.. if u query systables u can see that these are system tables in 2005
SELECT * FROM systables;
Msg 208, Level 16, State 1, Line 1
Invalid object...
August 28, 2009 at 8:52 am
Chirag (8/28/2009)
sysobjects is a system table and sys.sysobjects and sys.objects are views. Question mentions sysobjects.
Nope.
Until SQL Server 2000, sysobjects was a system table. As of SQL Server 2005, system servers...
August 28, 2009 at 7:26 am
Steve Jones - Editor (8/26/2009)
Thanks, Hugo, for the practical applications. Didn't think about something like searching the newsgroups.
Yeah, I once had to write code to manipulate some strings that might...
August 26, 2009 at 1:45 pm
DBA Cabuloso (8/26/2009)
I thought it was to escape a wildcard that we would like to search. But the item didn't have any exclamation in...
August 26, 2009 at 12:46 pm
Mark Horninger (8/26/2009)
Clever question, not sure why/how I'd ever use the concept though. Good trivia?
If you ever need to search a database of newsgroup messages, you'll be delighted to...
August 26, 2009 at 12:44 pm
Jesse McLain
When I was researching this, I was quite surprised to see #3 appear in the output.
I'm not. When you need to search for strings that include characters such as...
August 26, 2009 at 12:43 pm
CirquedeSQLeil (8/25/2009)
August 25, 2009 at 1:48 pm
JacekO (8/20/2009)
August 21, 2009 at 3:57 am
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...
August 21, 2009 at 3:51 am
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...
August 6, 2009 at 2:27 am
Viewing 15 posts - 2,986 through 3,000 (of 3,348 total)