Forum Replies Created

Viewing 15 posts - 2,206 through 2,220 (of 19,560 total)

  • RE: SQL DBA high ended question (5+ years’ experience)

    quackhandle1975 (8/18/2014)

    Brandie Tarvin (8/16/2014)

    Those are good answers, though I would be looking for you to ask the business user what he means by "doesn't work' and does he have a...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 18, 2014 at 8:18 am

    #1738877

  • RE: Tables on seperate filegroups.

    GilaMonster (8/18/2014)

    senthil kumar d (8/18/2014)

    And the reason for simple recovery model is that the transaction logs are really huge and they do not want to have a back up of...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 18, 2014 at 7:51 am

    #1738865

  • RE: Virtual Machines

    TomThomson (8/18/2014)

    Oh dear! "all Hardware"???

    Soundcard? Joystick? USB devices?

    Or am I answering the wrong question?

    See this MSDN library page.

    Or am I just a couple of years...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 18, 2014 at 7:44 am

    #1738863

  • RE: Is partitioning good option for OLTP?

    It seems that you are in a position where you are looking to architect a solution that may be out of your breadth.

    I'd recommend taking a step back and looking...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 15, 2014 at 4:57 pm

    #1738595

  • RE: Is partitioning good option for OLTP?

    curious_sqldba (8/15/2014)

    GilaMonster (8/15/2014)

    curious_sqldba (8/15/2014)

    Ok, i have a application generating about 10,000 transactions read/write per hour. we have 50 + clients, should i partition per client ( data has to be...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 15, 2014 at 4:39 pm

    #1738590

  • RE: Is partitioning good option for OLTP?

    curious_sqldba (8/15/2014)

    Ok. What about scalability, as i add more partitions activity also goes up so i can only scale-up so much on sql server, but if i have multiple databases...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 15, 2014 at 4:13 pm

    #1738582

  • RE: Is partitioning good option for OLTP?

    curious_sqldba (8/15/2014)

    Lets say you have database partitioned, all the transactions need to commit to same log file. In total there will be 10,000 commits per hour on the same log...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 15, 2014 at 3:58 pm

    #1738574

  • RE: Is partitioning good option for OLTP?

    curious_sqldba (8/15/2014)

    Assuming i have enterprise edition, is partitioning recommended for OLTP? My thought is it is good for OLAP and might not suite for OLTP ( 1000 read/writes per hour):

    i)...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 15, 2014 at 3:46 pm

    #1738567

  • RE: Today's Random Word!

    verse

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 15, 2014 at 1:39 pm

    #1738532

  • RE: Receiving Error 1944 when Rebuilding an index

    Woohoo - good to hear.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 15, 2014 at 12:19 pm

    #1738501

  • RE: Prevent RENAME of a database

    Igor Micev (8/15/2014)

    Hi

    I'd like to implement something to prevent renaming some of the databases on the instance.

    Is it possible in sql server?

    Not entirely possible.

    Policy Based Management won't prevent the name...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 15, 2014 at 11:54 am

    #1738487

  • RE: Job search through portals- Need some help to figure out an exact match to get a job

    dan-572483 (8/15/2014)

    I've also posted my resume on portals and have been contacted by many recruiters for jobs I am not qualified for, over-qualified for, or are out of my area....

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 15, 2014 at 11:04 am

    #1738475

  • RE: 1MB datafile growth size?

    I wouldn't leave filegrowth set at 1mb. There isn't much use for a growth that low. With Instant file initialization, data file growths in the GB range are...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 15, 2014 at 11:00 am

    #1738472

  • RE: How do I get part of URL?

    halifaxdal (8/15/2014)

    SQLRNNR (8/15/2014)

    Try the following type of query

    SELECT PARSENAME('asdf.domain.com',2) + '.' + PARSENAME('asdf.domain.com',1) AS url

    Thank you so much for your quick and simple solution

    You're welcome.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 15, 2014 at 10:37 am

    #1738465

  • RE: How do I get part of URL?

    Try the following type of query

    SELECT PARSENAME('asdf.domain.com',2) + '.' + PARSENAME('asdf.domain.com',1) AS url

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    August 15, 2014 at 10:02 am

    #1738444

Viewing 15 posts - 2,206 through 2,220 (of 19,560 total)