Forum Replies Created

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

  • 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

  • RE: Where is my backup?

    dxu (4/14/2016)

    Hi guys,

    I have scheduled full SQL backup on 1AM every morning and then two differential backups on 7AM and 1PM. I have also put hourly log backup in place...

    --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 15, 2016 at 8:44 pm

    #1872547

  • RE: Please help me improve the performance of this query

    Heh... wow... this thread certainly jumped the track. 😉

    The original post is pretty clear. Everything flies when the last condition is removed even though a shedload of...

    --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 15, 2016 at 8:29 pm

    #1872546

  • RE: The USE command and variables

    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 a stored...

    --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 15, 2016 at 8:11 pm

    #1872545

  • RE: Best Practices - SSIS location

    SQL!$@w$0ME (4/13/2016)

    Hi Guys,

    What are the best practices to implement SSIS server.

    Application server?

    Existing DB server?

    Dedicated server per environment?

    one dedicated server for all environments?

    Or any other options.

    Please share your thoughts. SSIS...

    --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 15, 2016 at 8:07 pm

    #1872544

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