Forum Replies Created

Viewing 15 posts - 17,866 through 17,880 (of 59,102 total)

  • RE: What's Your Downtime?

    Steve Jones - SSC Editor (4/18/2016)

    Jeff Moden (4/15/2016)

    Steve Jones - SSC Editor (4/15/2016)

    I'd hope a cloud provider wouldn't have this happen and would have plans for multiple redundancies and the...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 18, 2016 at 11:39 am

    #1872852

  • RE: Loading files in parallel

    richardmgreen1 (4/18/2016)

    @frederico - we did have a think about the load balancing option by using some sort of load table to pick up the next available file but couldn't quite...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 18, 2016 at 9:42 am

    #1872805

  • RE: Where is my backup?

    dxu (4/17/2016)

    Thanks guys. I think I was correct. I change the full backup to start on 1:30AM everyday and log backup to run every two hours start on 3AM. It...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 18, 2016 at 9:40 am

    #1872803

  • RE: How does SQL detect if a database backup was done?

    Here's what I'm talking about... this checks to find out what the current recovery model is so that you can make better decisions as to what kind of backup is...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 17, 2016 at 12:38 pm

    #1872619

  • RE: How does SQL detect if a database backup was done?

    Jeff Moden (4/17/2016)

    This should help you get started...

    SELECT LastFullBackupDT = MAX(backup_finish_date)

    FROM msdb.dbo.backupset

    WHERE database_name = 'yourdatabasenamehere'

    AND recovery_model...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 17, 2016 at 11:56 am

    #1872613

  • RE: How does SQL detect if a database backup was done?

    This should help you get started...

    SELECT LastFullBackupDT = MAX(backup_finish_date)

    FROM msdb.dbo.backupset

    WHERE database_name = 'yourdatabasenamehere'

    AND recovery_model <>...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 17, 2016 at 11:49 am

    #1872611

  • RE: iam page

    avraham.elad (4/17/2016)

    hi ,

    i dont understand iam pagei read sevral post and is dont get it,

    somone please explain this without qoute msdn ?

    Without knowing why you need to understand IAM...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 17, 2016 at 10:45 am

    #1872604

  • RE: Successful Projects

    manie (4/15/2016)

    It would be interesting to find out what percentage of the world's programmers rely on forums like SSC to actually do their job (sorry, have the job done for...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 17, 2016 at 10:05 am

    #1872603

  • RE: Cannot connect to (local) - how can I copy databases to another computer?

    Just in case you've not already tried...

    Since this isn't a production box, do the "normal" thing... something may have gone haywire with Windows or SQL Server express. Try rebooting...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 17, 2016 at 8:53 am

    #1872600

  • RE: Aggregate data in a row-like fashion

    qwerty.qwertz (4/17/2016)

    I have a SQL input table that is structured like the one shown below. Based on this input table I wanna create another table that aggregates the information in...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 17, 2016 at 8:42 am

    #1872599

  • RE: Loading files in parallel

    richardmgreen1 (4/14/2016)

    Hi Jeff

    If only......

    We get the CSV files as a data extract (I haven't got a clue what format the back end of the application runs on).

    This is also a...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 17, 2016 at 8:27 am

    #1872598

  • RE: Trigger for incrementing

    fareedhmohamed (4/17/2016)

    USE [Supermarket]

    GO

    /****** Object: Table [dbo].[Customer] Script Date: 17/04/2016 13:44:00 ******/

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    SET ANSI_PADDING ON

    GO

    CREATE TABLE [dbo].[Customer](

    [CustomerID] [varchar](10) NOT NULL,

    [FirstName] [nvarchar](50) NULL,

    [Surname] [nvarchar](50) NULL,

    [Gender]...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 17, 2016 at 7:45 am

    #1872596

  • RE: Select records in hierarchical order

    If you click the QUOTE button on this post, you'll see how to use the "IFCode Shortcuts" that you can see to the left of your post when you're creating...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 16, 2016 at 7:34 pm

    #1872572

  • RE: Comparing doc or pdf Files from Using SQL Server

    natigsqlserver (4/16/2016)

    hi friends

    i have very interesting qeustion

    can we comparing two another files with sql server

    for example

    in varbinary column have a pdf format file

    in inserting new data in...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 16, 2016 at 11:39 am

    #1872566

  • RE: The USE command and variables

    Jeff Moden (4/15/2016)

    Sgar... (4/15/2016)

    In above examples you have used Set @dbname= 'database name'.

    I am taking this input from Stored procedure input. How can you help?

    I'm curious... have you ever written...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 16, 2016 at 9:02 am

    #1872561

Viewing 15 posts - 17,866 through 17,880 (of 59,102 total)