Forum Replies Created

Viewing 15 posts - 1,006 through 1,020 (of 1,170 total)

  • RE: Execute scripts from directory by desired order

    Thank you guys!

    Your suggestions helped me

    Regards

    IgorMi

    Igor Micev

    November 22, 2012 at 2:52 pm

    #1561716

  • RE: How do I get database space used

    anthony.green (11/20/2012)

    IgorMi (11/20/2012)

    sql-lover (11/19/2012)

    Use COLLATION clause in one of the joins .. 😉

    If you have a database with a different collation like me, you'll get that error.

    Except the collation, your...

    Igor Micev

    November 20, 2012 at 3:41 am

    #1560704

  • RE: How do I get database space used

    sql-lover (11/19/2012)

    Use COLLATION clause in one of the joins .. 😉

    If you have a database with a different collation like me, you'll get that error.

    Except the collation, your code does...

    Igor Micev

    November 20, 2012 at 1:42 am

    #1560637

  • RE: Data Transfer from Table B to Table A - Timeout Error

    Hi,

    You could use MERGE statement in this case, but you have to create indexes on the joining columns. The following link can help you: http://technet.microsoft.com/en-us/library/cc879317.aspx

    Regards

    IgorMi

    Igor Micev

    November 19, 2012 at 3:45 pm

    #1560557

  • RE: Adding missing column to another table

    Sean Lange (11/19/2012)

    IgorMi (11/19/2012)

    Select * INTO TargetTable from ... is not a good practice.

    Use queries like last one:

    insert into TargetTable(A,B,C)

    select A,B,C FROM #TempTable;

    Where did you hear this? There is nothing...

    Igor Micev

    November 19, 2012 at 3:09 pm

    #1560536

  • RE: Performance Issue

    sqlnaive (11/19/2012)

    We have a procedure which performs _NO_ update or delete operation but only read. This procedure runs daily without any issue and gets completed within 1-2 minutes but one...

    Igor Micev

    November 19, 2012 at 3:04 pm

    #1560532

  • RE: Adding missing column to another table

    haiao2000 (11/19/2012)

    I just thought of a solution after posting:

    --dump existing data from target table into a temp table

    select * INTO #TempTable from TargetTable;

    --drop the TargetTable

    drop targetTable;

    --recreate TargetTable with additional fields...

    Igor Micev

    November 19, 2012 at 2:40 pm

    #1560524

  • RE: How do I get database space used

    Hi,

    Your code gives me an error:

    Msg 468, Level 16, State 9, Line 8

    Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.

    Use this simple code:

    select db_name(database_id)...

    Igor Micev

    November 19, 2012 at 2:31 pm

    #1560521

  • RE: ALTER TABLE advise

    George M Parker (11/14/2012)

    The difference is the "NOT NULL" constraint between the two statements.

    The following statement converts the column to a nullable column (I ran it in a test scenario...

    Igor Micev

    November 14, 2012 at 3:37 pm

    #1559163

  • RE: ALTER TABLE advise

    No it is not. It is a varchar column only.

    Igor Micev

    November 14, 2012 at 3:02 pm

    #1559149

  • RE: Request for migration advice

    Yeah, I always appreciate more experienced members answers, especially Gail's

    Thanks

    IgorMi

    Igor Micev

    November 13, 2012 at 3:59 pm

    #1558690

  • RE: Request for migration advice

    Hi All,

    My answer was just one sentence, having in mind that I just started a migration process. So it matters what kind of migration you have. For example the above...

    Igor Micev

    November 13, 2012 at 3:45 pm

    #1558687

  • RE: Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

    Hi Jeff,

    Simply brilliant!

    Thanks

    IgorMi

    Igor Micev

    November 13, 2012 at 2:31 pm

    #1558659

  • RE: T-SQL Cursors

    computergirl (10/16/2012)

    Okay I am kind of new to this and I am trying to create a table and if the user doesn't fill all the fields I need the empty...

    Igor Micev

    November 13, 2012 at 2:13 pm

    #1558654

  • RE: Unable to Rebuild or Reorganize an Index

    Hi,

    You may have space issues for your tempdb, or generally space issues, and then it is slow.

    Are you rebuilding online or offline?

    Regards

    IgorMi

    Igor Micev

    November 13, 2012 at 1:51 pm

    #1558643

Viewing 15 posts - 1,006 through 1,020 (of 1,170 total)