Forum Replies Created

Viewing 15 posts - 46 through 60 (of 82 total)

  • RE: Unable to shrink primary data file after splitting to multiple secondary data files

    Take a backup and then shrink file, hope this might work for you.

    Nag

    Nag
    ------------------------------------------------
    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

    May 20, 2010 at 6:15 am

    #1170043

  • RE: How to get schemaname, tablename, identity column, foreign key constraints

    Nagesh S-432384 (5/20/2010)

    Query is looking good.

    Nag

    you just miss spelled the table_name as tabnle_name 🙂 nothing else is the problem.

    Nag

    Nag
    ------------------------------------------------
    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

    May 20, 2010 at 6:14 am

    #1170042

  • RE: How to get schemaname, tablename, identity column, foreign key constraints

    Query is looking good.

    Nag

    Nag
    ------------------------------------------------
    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

    May 20, 2010 at 6:11 am

    #1170040

  • RE: RowLock not working properly

    Can you please post your quires with some dummy names?

    Thanks,

    Nagesh S

    Nag
    ------------------------------------------------
    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

    May 20, 2010 at 6:03 am

    #1170036

  • RE: Export Maintenance plans form SQL 2005 to 2008

    Hay Jeff thanks for the response, I was bit sad that no one responded to my request.

    once again thanks for responding.

    Nag.

    Nag
    ------------------------------------------------
    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

    May 19, 2010 at 12:36 am

    #1169243

  • RE: Update to a large table is taking time

    you can update stats using sp_updatestats procedure, if you still have same problem please post execution plan.

    Nag

    Nag
    ------------------------------------------------
    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

    May 18, 2010 at 5:51 am

    #1168732

  • RE: Group by clause query

    I think your results from both quires are very clear and your answer is right there, if you look at the out put 1st query (without grouping fright) grouped by...

    Nag
    ------------------------------------------------
    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

    May 18, 2010 at 5:48 am

    #1168728

  • RE: Update to a large table is taking time

    What about the statistics and log file size?

    Nag

    Nag
    ------------------------------------------------
    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

    May 18, 2010 at 5:37 am

    #1168722

  • RE: Shared database and Separate schema

    A question from what i have understood from your question. 🙂

    When both users can access each others data then why do you need different sachems?

    Nag.

    Nag
    ------------------------------------------------
    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

    May 18, 2010 at 5:34 am

    #1168721

  • RE: Solution-level variable in SQL RS

    I dont think there is a global parameter in SSRS, one alternative way is to use report model where you can define your own data source with all the fields...

    Nag
    ------------------------------------------------
    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

    May 18, 2010 at 5:29 am

    #1168719

  • RE: using "use database" and openrowset

    instead of using use dbname command use database name as prefix in select query like dbname.sys.dm_db_index_physical_stats, hope this will help you.

    Nag

    Nag
    ------------------------------------------------
    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

    May 18, 2010 at 5:21 am

    #1168714

  • RE: Help needed in setting collation for the SQL Server

    Have default collation at Sever level and change the collation of particular column as per your requirement.

    Nag.

    Nag
    ------------------------------------------------
    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

    May 18, 2010 at 2:29 am

    #1168648

  • RE: Return the resultSet in XMl format

    Using FOR XML you can get it done.

    Providing the DDL scripts for the tables, and INSERT statements to put some test data into those tables and some sample result will...

    Nag
    ------------------------------------------------
    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

    May 18, 2010 at 2:26 am

    #1168646

  • RE: Daily Backup Job

    Use INIT option in the WITH clause of backup statement, it will overwrite the existing backup file. for more info try this link

    http://msdn.microsoft.com/en-us/library/ms186865.aspx

    Nag.

    Nag
    ------------------------------------------------
    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

    May 16, 2010 at 11:56 pm

    #1168110

  • RE: Restricting SQL sysadmin from access

    If you restrict permissions to DBA then he should not be called DBA :(.

    Nag

    Nag
    ------------------------------------------------
    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

    May 14, 2010 at 4:46 am

    #1167421

Viewing 15 posts - 46 through 60 (of 82 total)