Forum Replies Created

Viewing 15 posts - 5,296 through 5,310 (of 7,164 total)

  • RE: LIKE pattern is not Case Sensitive on CS/AS unicode-Column

    Thanks, but these are Estimated plans. We need the Actual plans 🙂

    Ctrl+M to turn on Actual, then execute the queries. Pipe the results into a temp table using SELECT...INTO to...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 29, 2011 at 10:29 am

    #1360930

  • RE: Database upgarde from SQL 2000 to SQL 2005

    Ninja's_RGR'us (7/29/2011)

    opc.three (7/29/2011)

    Sqlsavy (7/29/2011)

    Thanks SSCrazy

    Apparently different collations on SQL 2005 are of System Objects in User database.

    Apparently 🙂

    PS I have been called Crazy, but my nick is opc.three. SSCrazy is...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 29, 2011 at 10:26 am

    #1360926

  • RE: indexing a converted datetime column

    Jayanth_Kurup (7/29/2011)

    a clustered index on this column would result in slow inserts and updates coz the day comes first in the var char column and every time a day is...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 29, 2011 at 10:25 am

    #1360924

  • RE: Seeing which Cached plan has been chosen

    Philip Yale-193937 (7/29/2011)

    The most likely culprit is the SET ARITHABORT option.

    By default in SSMS, this is OFF. Most applications will run with ARITHABORT ON. You will...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 29, 2011 at 10:20 am

    #1360918

  • RE: Database upgarde from SQL 2000 to SQL 2005

    Sqlsavy (7/29/2011)

    Thanks SSCrazy

    Apparently different collations on SQL 2005 are of System Objects in User database.

    Apparently 🙂

    PS I have been called Crazy, but my nick is opc.three. SSCrazy is just my...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 29, 2011 at 10:11 am

    #1360912

  • RE: Using xp_cmdshell to copy files to a sql server on a different domain

    Jeff Moden (7/29/2011)

    Heh... and once you learn PowerShell, you can run that from xp_CmdShell in T-SQL. 😉

    This is me not taking the bait Jeff 😛

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 29, 2011 at 10:10 am

    #1360911

  • RE: SSIS For Each Container Failure, With no Error on Progress Tab

    zlthomps (7/29/2011)

    Koen Verbeeck (7/29/2011)

    What if you connect the first FELC with the second one using a precedence constraint? Does it work then?

    Yes, it does - But I would ideally be...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 29, 2011 at 10:08 am

    #1360909

  • RE: Using xp_cmdshell to copy files to a sql server on a different domain

    For the record, anything you can run from a CmdShell prompt you can run in a PowerShell session...so that can be your fallback. That said, there are better replacements for...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 29, 2011 at 10:04 am

    #1360906

  • RE: Restore Database by date?

    Elegant, thanks for posting back and sharing your PS experience :satisfied:

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 29, 2011 at 9:50 am

    #1360894

  • RE: indexing a converted datetime column

    I agree with Michael, any indexes on the datetime column will be negated by surrounding the column with a CONVERT function in a search predicate.

    I guess if it were in...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 28, 2011 at 4:07 pm

    #1360492

  • RE: Using xp_cmdshell to copy files to a sql server on a different domain

    xp_CmdShell is one way to do it from within T-SQL. Kicking off a SQL Agent job that contains a CmdExec step is another.

    Is "from T-SQL" a requirement?

    PowerShell is much better...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 28, 2011 at 3:59 pm

    #1360488

  • RE: Database upgarde from SQL 2000 to SQL 2005

    Hi again Sqlsavy 😛

    Take a look at this on 2005. You may have a different view after filtering out the ms-shipped tables:

    SELECT DISTINCT

    ...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 28, 2011 at 3:56 pm

    #1360487

  • RE: SQL Job is not executing

    Not much to go on DIB IN...see if this fits:

    http://www.sqlservercentral.com/Forums/FindPost490875.aspx

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 28, 2011 at 3:48 pm

    #1360483

  • RE: Restore SQL 2005 db and sys dbs from prod server to test

    tracmonali (7/28/2011)

    well it is a test server and not in use. So didn't take it offline nor put it in single user mode.

    My Q is that the weekly backup used...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 28, 2011 at 3:38 pm

    #1360481

  • RE: SSIS For Each Container Failure, With no Error on Progress Tab

    zlthomps (7/28/2011)

    opc.three (7/28/2011)

    Nice job posting your question 🙂

    The only thing I can come up with for this, and it is a guess, is that there is only one copy of...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 28, 2011 at 3:16 pm

    #1360472

Viewing 15 posts - 5,296 through 5,310 (of 7,164 total)