Forum Replies Created

Viewing 15 posts - 4,051 through 4,065 (of 7,164 total)

  • RE: Converting first letter of every word to uppercase

    GSquared (5/15/2012)

    opc.three (5/15/2012)

    GSquared (5/15/2012)

    Because of all of those kinds of exceptions, and dozens more, I don't recommend doing this in T-SQL, and don't recommend doing this at all without serious...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 15, 2012 at 11:41 am

    #1487900

  • RE: How to script out in a single .sql file stored procedures containing specific reference on their code

    I would not use xp_cmdshell for this work. Have you tried using bcp directly from the command line?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 15, 2012 at 10:56 am

    #1487870

  • RE: Converting first letter of every word to uppercase

    GSquared (5/15/2012)

    Because of all of those kinds of exceptions, and dozens more, I don't recommend doing this in T-SQL, and don't recommend doing this at all without serious research into...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 15, 2012 at 10:40 am

    #1487861

  • RE: How to insert/update/delete into destination table

    pradeep.mohan (5/15/2012)

    Sorry to say that i did not understand your point.

    can you explain once again briefly.

    Which part are you having trouble understanding?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 15, 2012 at 12:26 am

    #1487543

  • RE: index rebuild no effect

    djordan 41144 (5/14/2012)

    yes still 70% fragemented.

    my table is not a heap table.

    table is 11mb. I suppose that means it is 1375 pages big.

    That is a very small table. In general...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 15, 2012 at 12:22 am

    #1487541

  • RE: Help with Secondary Log Shipping Database in Restoring Mode

    This is normal. When the initial restore was done it was done WITH NORECOVERY. Another option is to restore the database WITH STANDBY, but you have to provide an UNDO...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 15, 2012 at 12:19 am

    #1487539

  • RE: How to insert/update/delete into destination table

    Not really. Please re-read my earlier post.

    The Control Flow would look something like this:

    And your data flow would look something like this:

    Within the second Execute SQL Task is where you...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 15, 2012 at 12:12 am

    #1487535

  • RE: Capturing Multiple errors?

    shaun.stuart (5/14/2012)

    Is there any way to catch multiple errors with a try catch block?

    No, not using T-SQL.

    If you use a programming language like C# (what SSMS uses to run your...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 14, 2012 at 4:45 pm

    #1487445

  • RE: Converting first letter of every word to uppercase

    Jeff Moden (5/14/2012)

    opc.three (5/14/2012)

    bitbucket-25253 (5/12/2012)

    opc.three (5/11/2012)

    Jeff Moden (5/11/2012)

    Do you have any performance metrics for this, Orlando?

    I do not, but I would be happy to mock up some test data and...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 14, 2012 at 2:10 pm

    #1487380

  • RE: Converting first letter of every word to uppercase

    WayneS (5/14/2012)

    opc.three (5/14/2012)

    Calling my example function like this:

    SELECT dbo.ToTitleCase('The quick brown fox JUMPS over the lazy dog.');

    Yields:

    The Quick Brown Fox JUMPS Over The Lazy Dog.

    JUMPS stays uppercase. I may decide...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 14, 2012 at 2:03 pm

    #1487378

  • RE: Where can I find the latest releases of SQL Server 2008 R2?

    This is what I use:

    Where to find information about the latest SQL Server builds

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 14, 2012 at 1:57 pm

    #1487376

  • RE: Fill factor on historical table

    rafael_si (5/14/2012)

    Thank you guys for you time and patience....

    I will do what you've proposed in my test environment. My doubts was solved!

    obs: is there a way in this forum to...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 14, 2012 at 1:54 pm

    #1487371

  • RE: Create database DDL VS creating a database in SSMS

    capn.hector (5/14/2012)

    opc.three (5/14/2012)

    durring the server trace i could not find any differences in the T-SQL being executed between the create database script vs SSMS Create DB Wizard.

    Thank goodness. I think...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 14, 2012 at 1:47 pm

    #1487366

  • RE: Execute output of the output

    RBarryYoung (5/14/2012)

    opc.three (5/14/2012)

    RBarryYoung (5/14/2012)

    I cannot say for sure if it would be better for you, or by your criteria, but here[/url] is stored procedure that I wrote several years ago,...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 14, 2012 at 1:43 pm

    #1487364

  • RE: change dbo of database

    RBarryYoung (5/14/2012)

    Jeff Moden (5/13/2012)

    You can also do this by right-clicking on the database, selecting "properties", and then follow your nose.

    Really??? Jeff, I must be dense, because the initial "Owner"...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 14, 2012 at 1:39 pm

    #1487361

Viewing 15 posts - 4,051 through 4,065 (of 7,164 total)