Forum Replies Created

Viewing 15 posts - 2,881 through 2,895 (of 8,753 total)

  • RE: A Better sp_Spaceused

    Jeff Moden (11/6/2016)

    Geez... it would have been SOOOOOOOO simple for them to make the "improvement" so much more worthwhile. I don't know why they even bothered.

    They had to add...

    November 7, 2016 at 7:20 am

    #1910917

  • RE: Check my backup knowledge?

    Brandie Tarvin (11/7/2016)

    GilaMonster (11/7/2016)

    No, a compressed backup is compressed from the start.

    If it worked according to your theory, then a compressed backup would take longer than a normal backup...

    November 7, 2016 at 7:03 am

    #1910912

  • RE: table structure

    Quick thought, if you are storing exactly the same information for all "person types" then a single person table could work.

    😎

    +------------+ ...

    November 7, 2016 at 6:18 am

    #1910898

  • RE: installed memory(RAM)

    You can find detailed memory information in the sys.dm_os_process_memory view.

    😎

    November 7, 2016 at 5:20 am

    #1910882

  • RE: Importing Data and Default Values

    SteveD SQL (11/7/2016)

    Hi Eirikur

    Unfortunately I have no control over the data structure so is not be an option for me.

    Interesting idea though. Quick followup, if I had that as a...

    November 7, 2016 at 5:17 am

    #1910881

  • RE: Importing Data and Default Values

    Here is a possible solution using a trigger

    😎

    USE TEEST;

    GO

    SET NOCOUNT ON;

    IF OBJECT_ID(N'dbo.Product05') IS NOT NULL DROP TABLE dbo.Product05;

    CREATE TABLE dbo.Product05

    (

    ProductName VARCHAR(20) NOT NULL

    ...

    November 7, 2016 at 4:54 am

    #1910876

  • RE: Evalution Expired

    Rechana Rajan (11/7/2016)

    Eirikur Eiriksson (11/7/2016)

    Rechana Rajan (11/7/2016)

    We have two node cluster with 3-2014 Standard edition OLTP instances and 1-2012 Enterprise analysis server instance.

    Earlier the server had evalution edition and because...

    November 7, 2016 at 4:35 am

    #1910871

  • RE: Evalution Expired

    Rechana Rajan (11/7/2016)

    We have two node cluster with 3-2014 Standard edition OLTP instances and 1-2012 Enterprise analysis server instance.

    Earlier the server had evalution edition and because of that now SSMS...

    November 7, 2016 at 4:25 am

    #1910868

  • RE: sp_settriggerorder in section TRY/CATCH

    rajnoha (11/7/2016)

    Yes, it's an explanation. But if the procedure call without section TRY / CATCH then no transaction is open - Example 1.

    When wrapped in a try/catch, the exit clause...

    November 7, 2016 at 3:59 am

    #1910862

  • RE: sp_settriggerorder in section TRY/CATCH

    rajnoha (11/7/2016)

    It's just a question of principle. Why when using the section try / catch remains open transactions?

    In this case it is the poor coding of sys.sp_settriggerorder which is throwing...

    November 7, 2016 at 2:22 am

    #1910856

  • RE: Username increment by 1 if already exists in table

    abhas (11/7/2016)

    hi,

    if first two letters are same then use first three letters for second user and so on......

    Thanks

    Abhas.

    And if the first names are the same?

    😎

    November 7, 2016 at 2:04 am

    #1910854

  • RE: moving databases to a new directory

    sqlserverDBA2016 (11/5/2016)

    I have 40 databases on a single sql server instance

    I wanna move them to 2 new data and log directories

    Using backup and restore but would like to keep the...

    November 7, 2016 at 2:03 am

    #1910852

  • RE: Migrating Data from SQL server 2012 to Data Warehouse

    juniorDBA13 (11/7/2016)

    I won't be changing the data that will be moved.

    It will be just a straight copy from SQL Server to a single source.

    It will be just a copy of...

    November 7, 2016 at 1:45 am

    #1910850

  • RE: sp_settriggerorder in section TRY/CATCH

    Question, do you see the trigger in sys.triggers?

    😎

    SELECT

    OBJECT_NAME(STRG.parent_id) AS TABLE_NAME

    ,STRG.name ...

    November 7, 2016 at 1:42 am

    #1910849

  • RE: Username increment by 1 if already exists in table

    abhas (11/7/2016)

    Thanks Eirikur and Jeff.

    Now again requirement has changed. Now instead of increment, new logic is as below:

    First letter of firstname + LastName.

    If username alreadu exists then create as:

    First ...

    November 7, 2016 at 1:35 am

    #1910847

Viewing 15 posts - 2,881 through 2,895 (of 8,753 total)