Forum Replies Created

Viewing 8 posts - 1 through 9 (of 9 total)

  • Reply To: Multiple Collations

    Or even here where the collations are different:

     

    select *

    from sys.objects

    where name = ('sysrscols' collate French_CI_AS) collate French_CS_AS;

     

    At the end of most articles is a small blurb called a person's signature which exists to provide information about how to get in touch with the person posting, including their email address, phone number, address, or where they're located. Signatures have become the graffiti of computers. People put song lyrics, pictures, philosophical quotes, even advertisements in them. (Note, however, that advertising in your signature will more often than provoke negative responses until you take it out.)

  • Reply To: Inserting Sequences

    wow! 1% of respondants considered a cursor was the solution to a question on sequences

    At the end of most articles is a small blurb called a person's signature which exists to provide information about how to get in touch with the person posting, including their email address, phone number, address, or where they're located. Signatures have become the graffiti of computers. People put song lyrics, pictures, philosophical quotes, even advertisements in them. (Note, however, that advertising in your signature will more often than provoke negative responses until you take it out.)

  • Reply To: You are the DBA at a multinational company...

    support for these data types was introduced in sql2005 - instead of keeping the data in the row, pointers to other pages are used to enable larger chunks of memory...

    At the end of most articles is a small blurb called a person's signature which exists to provide information about how to get in touch with the person posting, including their email address, phone number, address, or where they're located. Signatures have become the graffiti of computers. People put song lyrics, pictures, philosophical quotes, even advertisements in them. (Note, however, that advertising in your signature will more often than provoke negative responses until you take it out.)

  • Reply To: The PowerShell Array Removal

    saying an array is '0' based does not really illustrate the situation.  The index is a position offset. So the first element is at the allocated address and the second...

    At the end of most articles is a small blurb called a person's signature which exists to provide information about how to get in touch with the person posting, including their email address, phone number, address, or where they're located. Signatures have become the graffiti of computers. People put song lyrics, pictures, philosophical quotes, even advertisements in them. (Note, however, that advertising in your signature will more often than provoke negative responses until you take it out.)

  • Reply To: Rounding Numerics

    Another QOTD where the explanation would only leave the inexperienced wondering...The correct response was to indicate the setting which would give an error but the explanation contradicts the answer...

    At the end of most articles is a small blurb called a person's signature which exists to provide information about how to get in touch with the person posting, including their email address, phone number, address, or where they're located. Signatures have become the graffiti of computers. People put song lyrics, pictures, philosophical quotes, even advertisements in them. (Note, however, that advertising in your signature will more often than provoke negative responses until you take it out.)

  • Reply To: SQL MI Stop/Start Billing

    What should we do when the answers are flawed like this?  I also went for 9 hours because I assumed that was the intended correct response...

    At the end of most articles is a small blurb called a person's signature which exists to provide information about how to get in touch with the person posting, including their email address, phone number, address, or where they're located. Signatures have become the graffiti of computers. People put song lyrics, pictures, philosophical quotes, even advertisements in them. (Note, however, that advertising in your signature will more often than provoke negative responses until you take it out.)

  • Reply To: Concatenating Dynamic SQL

    Yes,  I had to try it out to prove to myself that "SELECT @sql" wasn't some underhand feature I didn't know about but of course I got the 2 query...

    At the end of most articles is a small blurb called a person's signature which exists to provide information about how to get in touch with the person posting, including their email address, phone number, address, or where they're located. Signatures have become the graffiti of computers. People put song lyrics, pictures, philosophical quotes, even advertisements in them. (Note, however, that advertising in your signature will more often than provoke negative responses until you take it out.)

  • Reply To: Changing the format for a date

    Thank you people - thought I'd lost the plot for a minute there.  Doesn't anyone review these questions before they are published?

    At the end of most articles is a small blurb called a person's signature which exists to provide information about how to get in touch with the person posting, including their email address, phone number, address, or where they're located. Signatures have become the graffiti of computers. People put song lyrics, pictures, philosophical quotes, even advertisements in them. (Note, however, that advertising in your signature will more often than provoke negative responses until you take it out.)

Viewing 8 posts - 1 through 9 (of 9 total)