Forum Replies Created

Viewing 15 posts - 136 through 150 (of 548 total)

  • RE: Starting to Program

    Steve,

    I got a real bang seeing that photo on the right hand side of your editorial. Not many people can say they actually ever used a card punch machine. I...

  • RE: API Changes

    I have recently gotten deeply involved in Web Services technology. This is all about Data API with data moving across the Internet/Intranet from and to heterogeneous technologies. I must say...

  • RE: Lessons Learned Pay Off

    The exams force me to know relevant new features that can increase productivity and add value to a business application.

    This says it all in a nutshell!

  • RE: REPLACE Multiple Spaces with One

    Yes I noticed too how that final 2-space call gets invoked very,very often by your 2^N variant.

    I think the max for N=6 is 751678.

    But I haven't found a formula yet...

  • RE: REPLACE Multiple Spaces with One

    What is strange is that my first suggestion regarding the binary recursive approach corresponds to your sequence derived from 2^N (N starting at 1). But I liked Jeff's idea so...

  • RE: Displaying Sorted Hierarchies (SQL Spackle)

    What sort of hierarchy breaths and depths are people running into in the real world?

    Numbers please!

    Thus for a large telephone company I deal with, I have a table of 300...

  • RE: Displaying Sorted Hierarchies (SQL Spackle)

    Jeff,

    Neat stuff on hierarchies!

    One thing that's confusing me is the use of the back slash and how it orders.

    Thus in the script below, why do I get two different ordering...

  • RE: Where are you?

    The 'where are you' question was pretty much universal.

    You cannot say the same for 'how is the New Year celebrated where you live' because in a large part of the...

  • RE: How to change SQL Server Collation

    du.pereira (11/17/2010)


    Michael Meierruth (11/17/2010)


    Will the following sequence work with your magic command in place of the 'alter database' command?

    Sure! That what it does. It will change collation of all active...

  • RE: How to change SQL Server Collation

    Will the following sequence work with your magic command in place of the 'alter database' command?

    1. create a new database COLL with collation Latin1_General_BIN

    2. create a table and load a...

  • RE: How to change SQL Server Collation

    eduardo.pin (11/17/2010)


    Stop the running server.

    2. Open a Command Prompt and go to the SQL Server directory.

    3. Type:

    sqlservr -m -T4022 -T3659 -q"new collation"

    Example: sqlservr -m -T4022 -T3659 -q"latin1_general_ci_ai"

    I don't know...

  • RE: Instrumentation

    In a lot of apps I did and look after (and not just in SQL code and not just in SQL Server), I create this 'general purpose' logging table for...

  • RE: TSQL Challenge 36 - Create a graph/Chart with TSQL

    Jonathan,

    If you can easily solve the challenge posted, then you might want to submit some challening problems at this site. I can guarantee you that you will be surprised with...

  • RE: SQL Function : Find ‘X’ Business Days in the Future

    mmiller-511987 (7/26/2010)


    Great way to do date advancement: http://codemiller.blogspot.com/2010/07/sql-server-2005-date-advancement.html%5B/quote%5D

    I don't think using recursive CTE is a good approach for doing this kind of date arithmentic.

    Take a look at Jeff...

  • RE: Getting Colorful

    And meaning of ID TEN T?

    Sounds like identity.

    But where exactly is the problem?

Viewing 15 posts - 136 through 150 (of 548 total)