Forum Replies Created

Viewing 15 posts - 1,381 through 1,395 (of 19,560 total)

  • RE: DMV to list package content

    SQL_Surfer (4/29/2015)

    Is there a DMV where I can go search for certain strings thats being used in the pacakge? I know I can open a package in BIDS and then...

    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

    April 29, 2015 at 3:58 pm

    #1794524

  • RE: DBCC Shrinkdatabase run every week?

    Steve Vassallo (4/29/2015)

    Our company was just acquired by another. They DBA team there added some jobs to our servers and one was a DBCC Shrinkdatabase command followed by 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

    April 29, 2015 at 3:49 pm

    #1794521

  • RE: Byte Me: Slave Drive

    sql Sarah (4/29/2015)

    The database is acting up like a dog would, so they have to take it to obedience school for training.

    The monitor is supposed to look like a dog,...

    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

    April 29, 2015 at 3:45 pm

    #1794520

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (4/28/2015)

    Had a funny one today. On the DLM webinar I did with Grant, we had a guy ask how to recover a master database and...

    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

    April 28, 2015 at 2:35 pm

    #1794116

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/28/2015)

    Lynn Pettis (4/28/2015)

    SQLRNNR (4/28/2015)

    Lynn Pettis (4/28/2015)

    Lynn Pettis (4/28/2015)

    Wow, what some people expect us volunteers.

    The OP just PMed me with all the info that had been posted on the...

    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

    April 28, 2015 at 1:50 pm

    #1794101

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/28/2015)

    Lynn Pettis (4/28/2015)

    Wow, what some people expect us volunteers.

    The OP just PMed me with all the info that had been posted on the forum thread. Apparently he...

    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

    April 28, 2015 at 1:21 pm

    #1794082

  • RE: Stored Procedure help needed please!

    I agree with Lynn, let's start by seeing what you have done so far and see if we can tell exactly where you are getting hung up.

    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

    April 28, 2015 at 1:16 pm

    #1794080

  • RE: script to find oneday old user

    And here is a more up to date version of the query (sql 2005 and newer).

    /*

    WINDOWS_GROUP eliminates the isntgroup

    WINDOWS_LOGIN eliminates the isntname

    */

    SELECT sp.name ,

    sp.principal_id,

    ...

    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

    April 28, 2015 at 1:08 pm

    #1794077

  • RE: script to find oneday old user

    charipg (4/28/2015)

    there are users created before 24hrs, but result is 0 rows .

    is the condition is correct ?

    createdate > DATEADD(hh,-24,GETDATE())

    Based on your statement that means you have users created that...

    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

    April 28, 2015 at 1:07 pm

    #1794076

  • RE: script to find oneday old user

    charipg (4/28/2015)

    I need to find the one day old(in last 24hrs) user details:

    Below script i am using , but its not working as expected.

    Any suggestions please.

    select name,createdate,*...

    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

    April 28, 2015 at 12:31 pm

    #1794063

  • RE: CTE Problem Redux

    rmechaber (4/28/2015)

    SQLRNNR (4/28/2015)

    Hey, so far it is improved in % correct. Only 53% got it correct when I asked a very similar question a few years back.

    http://www.sqlservercentral.com/questions/Subquery/75557/

    Well, I got today's...

    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

    April 28, 2015 at 10:00 am

    #1793997

  • RE: CTE Problem Redux

    Hey, so far it is improved in % correct. Only 53% got it correct when I asked a very similar question a few years back.

    http://www.sqlservercentral.com/questions/Subquery/75557/

    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

    April 28, 2015 at 8:03 am

    #1793942

  • RE: Today's Random Word!

    TomThomson (4/27/2015)

    SQLRNNR (4/27/2015)

    marlin

    spike

    hall

    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

    April 28, 2015 at 7:52 am

    #1793939

  • RE: Today's Random Word!

    Ed Wagner (4/27/2015)

    Eirikur Eiriksson (4/27/2015)

    eccentricDBA (4/27/2015)

    SQLRNNR (4/27/2015)

    marlin

    Brando (his fishy cousin)

    The horror

    The Pain

    the joy

    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

    April 27, 2015 at 3:52 pm

    #1793836

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/27/2015)

    Ed Wagner (4/27/2015)

    Grant Fritchey (4/27/2015)

    Hey Steve! Where did you get pictures of my cousin?

    I never thought of you as having a strong feline side. 😀

    How many people does...

    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

    April 27, 2015 at 1:10 pm

    #1793806

Viewing 15 posts - 1,381 through 1,395 (of 19,560 total)