Forum Replies Created

Viewing 15 posts - 5,701 through 5,715 (of 9,241 total)

  • RE: Database Cluster vs single Database

    KTG (4/13/2012)

    I know I am leaving a lot out

    Way too much for us to make a sensible recommendation.

    KTG (4/13/2012)

    the cluster distributed work, while everything has to be funnelled to a...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    April 13, 2012 at 12:26 pm

    #1473411

  • RE: about restore

    praspras42 (4/13/2012)

    No I mean sorry that i was not specific

    I just want to know that can i write a

    procedure with the help of which i can take the

    backup of...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    April 13, 2012 at 8:16 am

    #1473271

  • RE: SQl Server Backups and Clustering

    ha haaaaa, bollywood comes to SSC 😀

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    April 13, 2012 at 7:45 am

    #1473248

  • RE: System Databases on C or with User Databases?

    Henrico Bekker (4/13/2012)

    Sys db's on own disk

    user db's on own disk.

    I never see a need to dedicate a whole drive\volume to what are essentially little used and extremely small...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    April 13, 2012 at 7:21 am

    #1473219

  • RE: Linked server not pointing to right server!

    Can you detail the exact steps you are taking and the options you are using to create the linked server?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    April 13, 2012 at 7:14 am

    #1473212

  • RE: Procedure sp_change_users_login error

    chumphrey 12211 (4/12/2012)

    SELECT NAME FROM sysusers WHERE issqluser = 1 and (sid is not null and sid <> 0x01) and suser_sname(sid) is NOT null ORDER BY name

    Firstly, use the catalog...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    April 13, 2012 at 6:24 am

    #1473183

  • RE: Procedure sp_change_users_login error

    chumphrey 12211 (4/12/2012)

    SELECT NAME FROM sysusers WHERE issqluser = 1 and (sid is not null and sid <> 0x01) and suser_sname(sid) is NOT null ORDER BY name

    Firstly, use the catalog...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    April 13, 2012 at 6:23 am

    #1473182

  • RE: Help working out some issues with my Delete Login script

    Are you wanting to remove the server level login or the server login and the database user?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    April 12, 2012 at 1:41 pm

    #1472914

  • RE: Database mirroring question

    Always On in 2012 works the same, one full backup and restore followed by at least one t-log backup and restore. More importantly bear in mind this scenario

    full backup at...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    April 12, 2012 at 1:38 pm

    #1472910

  • RE: Question on bloated Transaction Log after doing index maintenance.

    Greg.Jackson (4/12/2012)

    Thank you, guys. I changed the frequency to every 15 minutes and now my log_reuse_wait_desc is finally set to NOTHING. So it looks like the Log will finally get...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    April 12, 2012 at 1:31 pm

    #1472903

  • RE: SQL Server is unresponsive

    a quick through the DMVs would have been helpful but to late now

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    April 12, 2012 at 10:41 am

    #1472761

  • RE: How database grows?

    Thinky Night (4/12/2012)

    Thanks again, I am still reading Kalen's book, and tring to understand concepts.

    New question:

    Can i see all pages in a database with a command like DBCC IND?

    OR

    How...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    April 12, 2012 at 10:38 am

    #1472756

  • RE: Msg 468, Level 16, State 9, Procedure "procedurename", Line 129 Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

    tt-615680 (4/12/2012)

    Thank you for your reply!

    This is part of the stored procedure:

    ........................

    ...................

    CREATE TABLE Data

    (

    Total_TY decimal(10,2), --this is where is gives the error

    Total_LY decimal(10,2),

    variance decimal(10,2)

    )

    INSERT INTO #Data

    SELECT

    CASE WHEN ISNULL(ISNULL(Total_TY,0)/ISNULL(Total_LY,1), 0)...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    April 12, 2012 at 10:23 am

    #1472744

  • RE: Question on bloated Transaction Log after doing index maintenance.

    Greg.Jackson (4/12/2012)

    I would appreciate some input on this one.

    I have an Enterprise Class database (SQL Server 2008 R2) that I perform Index Maintenance on nightly (non peak hours using...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    April 12, 2012 at 10:12 am

    #1472733

  • RE: Mirroring Error

    Glad you're sorted

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    April 11, 2012 at 1:19 pm

    #1472182

Viewing 15 posts - 5,701 through 5,715 (of 9,241 total)