Forum Replies Created

Viewing 15 posts - 2,986 through 3,000 (of 3,348 total)

  • RE: Fixed to varying length

    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...

  • RE: Fixed to varying length

    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...

  • RE: Fixed to varying length

    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...

  • RE: Fixed to varying length

    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...

  • RE: sysobjects

    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...

  • RE: sysobjects

    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...

  • RE: sysobjects

    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...

  • RE: LIKEable Brackets

    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...

  • RE: LIKEable Brackets

    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...

  • RE: LIKEable Brackets

    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...

  • RE: LIKEable Brackets

    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...

  • RE: Reclaiming freed space

    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...

  • RE: cast, convert and float!

    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...

  • RE: SQL 2008 T-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...

  • RE: Reclaiming freed space

    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...

Viewing 15 posts - 2,986 through 3,000 (of 3,348 total)