Forum Replies Created

Viewing 15 posts - 15,406 through 15,420 (of 19,560 total)

  • RE: Foreign key constraints...WHY??

    Paul White NZ (4/3/2010)

    It simply isn't good enough to state that entity integrity must be enforced by the database layer, and anything else is somehow irresponsible or dangerous. 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 3, 2010 at 12:47 pm

    #1145371

  • RE: Speed up a database shrink

    Paul White NZ (4/3/2010)

    Jeffrey Williams-493691 (4/2/2010)

    Yeah - I have used both and can recommend either of them.

    Have used LiteSpeed quite extensively, but never HyperBac. The thing I don't like...

    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 3, 2010 at 2:20 am

    #1145251

  • RE: Foreign key constraints...WHY??

    sumit.joshij (4/2/2010)

    I am totally agree with your point that database should maintain its integrity itself. but if interface should have that much of control that it can handle and check...

    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 3, 2010 at 2:16 am

    #1145250

  • RE: The Missing Certification

    Jeff Moden (4/2/2010)

    Gosh... :blink: You would think that an MCM would be required to know how to distinguish between good code and bad code as part of some sort...

    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 3, 2010 at 2:10 am

    #1145249

  • RE: The Missing Certification

    Steve Jones - Editor (4/2/2010)

    I haven't gone through Brent's Blog on it, but I doubt they have a lot of T-SQL taught. I think it's more details on the SQL...

    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 3, 2010 at 2:07 am

    #1145248

  • RE: Removing duplicates and keeping 1 record with no PK

    olie480 (4/2/2010)

    lmu92 (4/2/2010)

    Btw: What do you mean by "query manager"?

    If you're using SQL Server 2000, the query shouldn't run at all since table variable as well as ROW_NUMBER function 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 3, 2010 at 2:03 am

    #1145246

  • RE: Are the posted questions getting worse?

    WayneS (4/2/2010)

    CirquedeSQLeil (4/2/2010)

    WayneS (4/2/2010)

    Paul White NZ (4/2/2010)

    Steve Jones - Editor (4/2/2010)

    Paul White NZ (4/2/2010)

    Yay! My apply articles have been scheduled!!! 12th & 19th April - excited :w00t:

    Thanks Steve!

    You...

    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 3, 2010 at 2:01 am

    #1145245

  • RE: Database with multiple companies

    Some of your query response time is going to depend on indexing strategies employed. Some of it will depend on the actual structure of the query (i.e. the use...

    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 3, 2010 at 1:58 am

    #1145244

  • RE: Default Index Fill Factor

    From the 6.5 servers I administered through the 2008 servers that I administer, the default for fill factor was 0. I don't know where your instructor got their information...

    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 3, 2010 at 1:54 am

    #1145242

  • RE: Speed up a database shrink

    George, I think you would be ok with RedGate Backup. It's not like most other backup tools for SQL server. It integrates nicely with SQL server and iirc...

    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 2, 2010 at 6:52 pm

    #1145185

  • RE: Improve Between performance

    It uses better search arguments and also limits the result set. The better search argument allows better index use. If you include your graphical execution plan - you...

    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 2, 2010 at 5:57 pm

    #1145173

  • RE: Improve Between performance

    cgreathouse (4/2/2010)

    Excellent! I'm now getting a duration of 1 ms and with only 3 reads!!

    Could you explain what's going on here to make it so much faster?

    Thanks!

    Which script?

    The original...

    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 2, 2010 at 5:43 pm

    #1145169

  • RE: Speed up a database shrink

    george sibbald (4/2/2010)

    TheSQLGuru (4/2/2010)

    1)

    3) consider getting Hyperbac. <....snip........>I even don't have to worry about promoting it here on SQLServerCentral any more since Red-Gate just bought them! :w00t:

    Disclaimer:...

    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 2, 2010 at 5:41 pm

    #1145167

  • RE: Improve Between performance

    That looks better.

    Thanks Lutz

    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 2, 2010 at 5:30 pm

    #1145164

  • RE: The Missing Certification

    I just found this comment from Joe Sack concerning the MCM.

    The next large update of MCM will be for the version after SQL Server 2008 R2. Those with SQL 2008...

    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 2, 2010 at 5:26 pm

    #1145162

Viewing 15 posts - 15,406 through 15,420 (of 19,560 total)