Forum Replies Created

Viewing 15 posts - 1,426 through 1,440 (of 1,479 total)

  • RE: Query Execution Plans & Recompilation

    ggraber (10/15/2008)

    Do IF-THEN statements inside stored procedures cause the query execution plans for stored procedures to be recompiled?

    I have heard two different views on this:

    1. Yes. There is only one...

    October 15, 2008 at 11:18 pm

    #885637

  • RE: Can't make SQL Server Profiler work

    joselefou (10/15/2008)

    We use LINQ2sql and start to have performance issues.

    I would like to know exactly what SQL queries are received by SQL server during an amount of time.

    SQL Server Profiler...

    October 15, 2008 at 12:45 pm

    #885421

  • RE: Table Space not released

    CrazyMan (10/15/2008)

    Hi All

    I am having a table with 5 columns, with 2 big int columns, 1 int and 1...

    October 15, 2008 at 9:24 am

    #885307

  • RE: COPYING TABLE FROM ONE DATABASE TO ANOTHER DB

    Kishore.P (10/13/2008)

    If table structure already exist, use BCP or BULKINSERT command.

    Otherwise use select * into ]

    BCP and BULKINSERT are used to move data between SQL Server and...

    October 13, 2008 at 6:12 am

    #884107

  • RE: COPYING TABLE FROM ONE DATABASE TO ANOTHER DB

    sandhyarao49 (10/13/2008)

    Thanks to All.

    Suppose if i want to copy a table from one server to another server

    what is the best approach to do this task.

    Thanks,

    Sandhya

    You can use linked...

    October 13, 2008 at 6:05 am

    #884102

  • RE: COPYING TABLE FROM ONE DATABASE TO ANOTHER DB

    sandhyarao49 (10/12/2008)

    HI TO ALL,

    I WANT TO COPY SOME ROWS FROM ONE TABLE IN ONE DATABASE TO ANOTHER DATABASE.

    IS THERE ANY EASY APPROACH TO PERFORM THIS TASK

    THANKS,

    SANDHYA;)

    Something like this:

    INSERT INTO TargetDB.dbo.TargetTBName...

    October 12, 2008 at 4:14 am

    #883873

  • RE: SQL 2005 to SQL 2000

    Dugi (10/12/2008)

    GilaMonster (10/12/2008)

    The compatibility level just affects the parser and query processor and change the way that T-SQL is interpreted and what command are permitted.

    Ok I have experience from SQL...

    October 12, 2008 at 3:21 am

    #883871

  • RE: Change SQL Time

    jjssilva (10/10/2008)

    Hello,

    I did check the server and confirmed that the time is is correct with all the other machines, but SQL still has that time difference.

    I'm clueless here. I've checked...

    October 10, 2008 at 9:40 am

    #883505

  • RE: SQLServer 2000 and 2005 which enviroment I am in?

    yulichka (10/9/2008)

    I open my servers in 2005 and we have bunch of servers still in 2000 enviroment, how do I know which enviroment is I am inn? Thank you

    One of...

    October 9, 2008 at 10:07 am

    #883004

  • RE: add column between two column

    bang.prashant (10/9/2008)

    I have a table having column1,column2,column3,column4

    Now I have to modify the table and add two new column column A, ColumnB in between Column1 & Column2.

    So new columns list will...

    October 9, 2008 at 10:04 am

    #883000

  • RE: Change SQL Time

    jjssilva (10/9/2008)

    Adi,

    I'm comparing the time between this SQL Installation and all the servers in the Domain. This SQL Instance is the only one with this time difference. All the others...

    October 9, 2008 at 9:47 am

    #882990

  • RE: Change SQL Time

    jjssilva (10/9/2008)

    Hello,

    I've searched alot for this info but the only thing I can find is how to change the default Language for the users.

    What happens is that I have Microsoft...

    October 9, 2008 at 9:13 am

    #882967

  • RE: Problems with dynamic string in Openquery

    joey.burgett (10/9/2008)

    Thanks to you all for responding.

    I've tried the suggestions and upon further testing, it appears that using ANY quoted value inside the dynamically generated statement fails.

    I tried it against...

    October 9, 2008 at 8:44 am

    #882939

  • RE: Statistics for Newly Loaded Tables

    Dan Ellison (10/8/2008)

    We have a small data warehouse with tables being fully replaced. We load with the clustered index in place and add secondary indexes afterward.

    I don't want to...

    October 9, 2008 at 8:36 am

    #882937

  • RE: Select *

    Vincent Central (10/9/2008)

    Who said developers have full access to production? Doing a select * only takes read access.

    Thank you all for your replies. I have "coached" the offending developers and...

    October 9, 2008 at 6:55 am

    #882852

Viewing 15 posts - 1,426 through 1,440 (of 1,479 total)