Forum Replies Created

Viewing 14 posts - 106 through 120 (of 120 total)

  • RE: Alter schema of the table which is part of replication

    hey Raj

    getting same error.Got any solution

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 17, 2012 at 2:50 am

    #1513455

  • RE: Need help SET CONCAT_NULL_YIELDS_NULL Issue

    Any one of the values that you are concatenating might be null.

    put a isnull check of that value.

    isnull(null_value,'')

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    January 19, 2011 at 7:47 am

    #1275317

  • RE: UNION Causing Sorting - Query Optimization

    Not much option of overcoming the sort operation unitll order by is removed,,,

    one way you can try creating indexed view,,,,

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    January 18, 2011 at 6:05 am

    #1274645

  • RE: shrink report server_log file in sql server 2008

    have you tried

    dbcc shrinkfile(<'logfilename'>)

    works better in simple recovery mode

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    January 17, 2011 at 5:05 am

    #1274193

  • RE: Performance tune SS SP

    check for following things:

    tuning HaversineDistanceKm fn

    check for missing or non used indexes

    check for statistics

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    January 17, 2011 at 4:53 am

    #1274192

  • RE: using

    The use of isnull function should avoid the use if indexes..

    use of functions on the query predicates avoids the use of indexes

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    January 13, 2011 at 4:06 am

    #1272931

  • RE: Performance tuning a self Join

    also put rowlock on the table from which data is deleted

    put nolock on the tableB (referenced table)

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    January 13, 2011 at 3:53 am

    #1272920

  • RE: Update to 0 if NULL

    facticatech (1/12/2011)

    I have set of columns (more than 10) and need to update them to 0 if it is null.

    for eg: update table set column1=0 where column1 is null

    update...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    January 13, 2011 at 3:51 am

    #1272918

  • RE: Update with Row Lock -How to Optimize this

    Rowlock will help till some extent (till threshold reached)....

    After the threshold number of locks gets acquired the rowlock gets escalated to table level lock to optimally use the resources.....

    As per...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    January 13, 2011 at 3:47 am

    #1272914

  • RE: what is select 'X'?

    yes

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    January 6, 2011 at 3:22 am

    #1269963

  • RE: what is select 'X'?

    in topic you have specified select 'x'

    so i think you wanted to know for select 'x' from tablename

    the above query will return char x for all the records in the...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    January 6, 2011 at 3:17 am

    #1269959

  • RE: Add A Row to Count the Occurrence of Duplicates

    photonicman (1/5/2011)

    Okay, how about adding a column to this data to count the first, second, third, etc occurrence of duplicate PA_EnterpriseID's in column 1 - Placing the count in a...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    January 6, 2011 at 2:49 am

    #1269946

  • RE: is null check in where clause

    As Specified by the Gila,,the two queries won't fetch the same results,,,

    In general checking for nullablilty for parameter would be better than checking for nullablilty for the column.

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    January 5, 2011 at 3:24 am

    #1269379

  • RE: SQL to find duplicates

    Try out this on as well..

    SELECT name,

    address

    FROM tab tab1

    WHERE EXISTS(SELECT tab2.address

    ...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    January 5, 2011 at 2:53 am

    #1269365

Viewing 14 posts - 106 through 120 (of 120 total)