Forum Replies Created

Viewing 15 posts - 6,646 through 6,660 (of 18,926 total)

  • RE: Are the posted questions getting worse?

    Got a hard 1 for you all. Get me all the queries sent through sp_prepare and executed via sp_execute (not sp_executesql).

    http://www.sqlservercentral.com/Forums/Topic1099625-146-1.aspx

    April 27, 2011 at 5:05 pm

    #1316972

  • RE: Less Pay, More Convenience

    Peter Maloof (4/27/2011)

    Has anyone ever heard any explanation as to why they're not allowed to telecommute?

    I'd love it if a manager would post here, trying to justify their company's telecommuting...

    April 27, 2011 at 5:02 pm

    #1316971

  • RE: Less Pay, More Convenience

    Peter Maloof (4/27/2011)

    UMG Developer (4/27/2011)

    The official policy is B, but unofficially they want exempt employees to do A (still using sick time), and want non-exempt employees to do C.

    They expect...

    April 27, 2011 at 3:10 pm

    #1316929

  • RE: See the query in sp_execute

    While we're at it... is there any way (other than a trace) to see all the queries run by a session between 2 dates?

    Or plan A.2 Is there a way...

    April 27, 2011 at 2:55 pm

    #1316917

  • RE: See the query in sp_execute

    Looks right on the nose. I'll test it out when I'm back in the office.

    Tx.

    April 27, 2011 at 2:13 pm

    #1316890

  • RE: Less Pay, More Convenience

    GilaMonster (4/27/2011)

    Ninja's_RGR'us (4/27/2011)

    exec sp_update_resume

    exec sp_distribute_resume

    exec sp_bye_bye_<moronic>_boss(es)

    GO

    Select employment_type, payment_status, contract_prognosis FROM MoronicClient

    Contract Awaiting Feb payment Poor

    I don't call those a client. I call those a...

    April 27, 2011 at 1:54 pm

    #1316872

  • RE: Less Pay, More Convenience

    GilaMonster (4/27/2011)

    Peter Maloof (4/27/2011)

    GilaMonster (4/27/2011)

    Any wonder she doesn't let me work away from the office?

    If you were a little under the weather, would your manager expect you to:

    A. Telecommute, and...

    April 27, 2011 at 11:44 am

    #1316792

  • RE: Huge Database and there is no referential integrity maintained

    Grant Fritchey (4/27/2011)

    I had a system where we ran a basic query trace 24/7 for years. Other than dealing with the data that came out of, there was no real...

    April 27, 2011 at 11:41 am

    #1316791

  • RE: Less Pay, More Convenience

    Stefan Krzywicki (4/27/2011)

    Ninja's_RGR'us (4/27/2011)

    Stefan Krzywicki (4/27/2011)

    Steve Jones - SSC Editor (4/27/2011)

    Stefan Krzywicki (4/27/2011)

    Sure, these are all just my anecdotes, but they're what inform my perception of the state of management...

    April 27, 2011 at 11:32 am

    #1316785

  • RE: Less Pay, More Convenience

    Peter Maloof (4/27/2011)

    GilaMonster (4/27/2011)

    Any wonder she doesn't let me work away from the office?

    If you were a little under the weather, would your manager expect you to:

    A. Telecommute, and do...

    April 27, 2011 at 11:27 am

    #1316780

  • RE: How to get - just one, specific - line from multiple Joins

    CELKO (4/27/2011)

    In three decades of SQL, I have only seen one situation with a table that wide. It was a medical research project that exposed subjects to a ton of...

    April 27, 2011 at 11:24 am

    #1316776

  • RE: Less Pay, More Convenience

    Stefan Krzywicki (4/27/2011)

    Steve Jones - SSC Editor (4/27/2011)

    Stefan Krzywicki (4/27/2011)

    Sure, these are all just my anecdotes, but they're what inform my perception of the state of management today. I've also...

    April 27, 2011 at 11:16 am

    #1316771

  • RE: Huge Database and there is no referential integrity maintained

    Now that I think of it I actually like the trace idea better. It seems more accurate in my system.

    Start default trace and import into table...

    SELECT SUM(Reads) AS Reads,...

    April 27, 2011 at 11:12 am

    #1316768

  • RE: Less Pay, More Convenience

    GilaMonster (4/27/2011)

    Dan.Humphries (4/27/2011)

    Most managers hear of someone who did not actualy do much work from hom enad assumed that all work from home employees must not work more than a...

    April 27, 2011 at 10:46 am

    #1316750

  • RE: NEED HELP= Monthly SQL database growth calculation script

    hydbadrose (4/27/2011)

    Hi hydbadros,

    I'm not sure how you would like to calculate the growth from your table, but here is an example of how it can be done, where I have...

    April 27, 2011 at 10:05 am

    #1316727

Viewing 15 posts - 6,646 through 6,660 (of 18,926 total)