Forum Replies Created

Viewing 15 posts - 106 through 120 (of 147 total)

  • RE: REPLACE() and NULL

    [font="Verdana"]Goodish! simple and informative!

    [/font]

    July 12, 2010 at 1:23 am

    #1191335

  • RE: Performance Impacts Related to Different Function Types

    dmoldovan (7/1/2010)

    Will any recording be available?

    ++ one more Ticket !!

    .... 🙁

    July 6, 2010 at 8:05 am

    #1189112

  • RE: Foreign Key Constraints and Performace!

    PaulB-TheOneAndOnly (7/5/2010)

    FKs certainly add overhead but I would refrain myself of saying that FK implementation is fatal in terms of performance.

    Having said that I have seen critical, high end systems...

    July 6, 2010 at 3:00 am

    #1188978

  • RE: uncommitted transactions

    Matt Miller (#4) (11/7/2007)

    Two things to check. One is that you might have the "implicit transaction" setting turned on, which means EVERYTHING it wrapped in a transaction. Check...

    July 1, 2010 at 12:49 am

    #1187472

  • RE: ORing or ANDing with INNER and OUTER joins

    [font="Verdana"]

    GSquared (8/8/2008)

    You can put anything you'd put in a Where clause, into a join clause. Some things might be a bad idea, but you can technically do it.

    but if...

    June 16, 2010 at 4:08 am

    #1180846

  • RE: Sub Query VS Left Outer Join

    [font="Verdana"]

    calvo (6/8/2010)

    Ensuring your tables are properly indexed and using inner joins where possible would help performance.

    Yes, i appreciate it, but please let exclude proper indexing (including Clustered) or assume...

    June 8, 2010 at 7:18 am

    #1177455

  • RE: cursor row count

    [font="Verdana"]

    Chad Crawford (1/30/2008)

    @@ROWCOUNT returns the number of rows impacted by the last statement, which in this case is the OPEN. The OPEN didn't impact any results, and that...

    May 27, 2010 at 4:44 am

    #1173230

  • RE: Writing Portable SQL

    [font="Verdana"]

    Gianluca Sartori (5/24/2010)

    I have worked for a sofware company .......

    As I promised, just my two cents.

    I haven't thought that before about the worth of two cents. :w00t:

    Thank you.[/font]

    May 24, 2010 at 11:33 pm

    #1171850

  • RE: Table won't release unused space

    [font="Verdana"]

    danchard (2/24/2009)

    Hi.

    Thanks for the suggestion but I'd tried running dbcc cleantable already and it didn't have any affect.

    I've now been asked to shift my focus from freeing up the excess...

    May 21, 2010 at 9:03 am

    #1170899

  • RE: Use Dynamic SQL to Improve Query Performance

    [font="Verdana"]

    mohd.nizamuddin (5/20/2010)

    Vladimir Basanovic (5/20/2010)

    Maybe you should consider rewriting original function with coalesce on every parameter. That's how you would avoid table scan if the parameter is null.

    BR,

    Vladimir

    Is it Vladmir... 😎

    Thanks...

    May 20, 2010 at 1:38 am

    #1169906

  • RE: Database Developer VS DBA

    Steve Jones - Editor (5/10/2010)

    The best method for me, has been to have me review all SQL code, but work with and train developers to write some of the code....

    May 10, 2010 at 11:22 pm

    #1165342

  • RE: Database Developer VS DBA

    [font="Verdana"]

    GilaMonster (5/10/2010)

    Abrar Ahmad_ (5/10/2010)

    1. In which the there is no DB Team at all, except a White Elephant named as DBA.

    Wow. How can you ask for a discussion when your...

    May 10, 2010 at 7:39 am

    #1164978

  • RE: Database Developer VS DBA

    [font="Verdana"]

    Grant Fritchey (5/10/2010)

    Sorry, but there is no rule or formula that can be derived here. There are too many variables.

    Fine, but what my past experience suggests me that the product,...

    May 10, 2010 at 7:05 am

    #1164952

  • RE: Convert nvarchar to datetime

    Chris Morris-439714 (5/7/2010)

    Abrar Ahmad_ (5/7/2010)

    [font="Verdana"]Yep

    I have a nvarchar field with a value '20100407132212' every database practitioner knows this format very well, but un-fortunately implicit conversion from this nvarchar data column...

    May 7, 2010 at 8:16 am

    #1164125

  • RE: Convert nvarchar to datetime

    [font="Verdana"]Yep

    I have a nvarchar field with a value '20100407132212' every database practitioner knows this format very well, but un-fortunately implicit conversion from this nvarchar data column to DATETIME format is...

    May 7, 2010 at 7:01 am

    #1164051

Viewing 15 posts - 106 through 120 (of 147 total)