Forum Replies Created

Viewing 15 posts - 811 through 825 (of 831 total)

  • RE: Just SQL Auth

    BackupGuy (11/20/2009)

    Secondarily, I think this discussion is probably moot as I don't see Microsoft ever allowing access without authentication as it holds the potential for disrupting a revenue stream.

    Still unclear...

  • RE: Is C# Better?

    dawalker-1068762 (11/13/2009)


    OK, I've read through tons of comments here that amount to nothing more than opinions regarding syntax and have seen very little that answers the real question aside from...

  • RE: Is C# Better?

    Well, if you lay it all out flat like that it won't be very easy to read. Usually you indent the code in between the braces to make it easier...

  • RE: Is C# Better?

    If it's the former, I'm surprised no-one's pointed out both languages compile to the same intermediate language

    Wasn't it mentioned in the original article?

  • RE: Is C# Better?

    I definitely agree with Iain on the positioning of the curly brackets issue. Pretty sure the

    if (x) {

    // something

    }

    only came about to save a few precious characters in the...

  • RE: Is C# Better?

    I suspect a lot of the reason that VB.NET is looked down on is simply because it's BASIC. There have been many truly awful versions of BASIC released over the...

  • RE: Preventing usage of "SELECT *..."

    Another tool along these lines would be to expand select statement itself to allow for an exclusion set of columns. For example:

    select all except (columnX, columnY, columnZ) from Table.....

    That would...

  • RE: Missing Local Server after MSSQL 2005 Installed

    Is this the Developer Edition or Express Edition of SQL 2005? Any other edition won't allow you to install the database engine on a non-server OS, as far as I...

  • RE: Preventing usage of "SELECT *..."

    If you're not actually uising all the columns it also means you're returning a lot more data to the calling application than it actually needs. That's not so much of...

  • RE: Puzzling SQL server performance

    Just to add a note about the load being spread over all the CPUs--that's pretty much normal. When you have a single thread running at 100% CPU the Windows task...

  • RE: Discussion: Removing the option to ' SELECT * FROM OBJECT'

    I think it's a matter of educating developers in proper database design and manipulation. Yes, removing the option for SELECT * would force them to do that one thing properly,...

  • RE: How to find the License Mode for an existing SQL 2005 server?

    Richard M. (10/7/2009)


    Right... they get you with the "You have to acquire licenses only for processors that are accessible to any copy of the operating system upon which SQL Server...

  • RE: WORD UP!

    I've not tried it, but I've found anecdotal evidence that SQL 2000 won't work on Server 2008--given that uses the Vista kernel, as does Windows 7, I'd say the chances...

  • RE: How do you get to a hidden modal dialog box?

    Does using ALT+TAB to switch to another application, then back to the offending app, work?

  • RE: varchar(max) or varchar(some large number)?

    Odd. Just ran that code against a SQL Server 2008 Express Edition database, and the VARCHAR(MAX) runs generally had higher CPU time but lower elapsed time than the VARCHAR(x) ones...

Viewing 15 posts - 811 through 825 (of 831 total)