Forum Replies Created

Viewing 15 posts - 1,726 through 1,740 (of 2,008 total)

  • RE: join on 1=1

    sqlfriends (11/9/2011)

    so if I change the join to cross join and take off 1=1, it will be the same, correct?

    But I read somewhere if a cross join have a where...

    November 10, 2011 at 12:35 am

    #1405552

  • RE: join on 1=1

    It's basically doing a cross join. Maybe the author didn't know about that option.

    I haven't seen any instance when people use 1=1 by mistake. It's deliberate CROSS JOIN (just to...

    November 10, 2011 at 12:29 am

    #1405551

  • RE: execute stored procedure with order by

    daveriya (11/9/2011)

    thanks a lot DEV,that's what i was looking ,u solve my problem.

    I would love to accept Thanks but as Sean & Paul pointed out (in later posts) it’s...

    November 10, 2011 at 12:26 am

    #1405550

  • RE: Restore Never Finishes

    patrick-511016 (11/10/2011)

    yes I have tried it again and it is stuck

    Is there anything else running on server (for the said database) in parallel to restore?

    November 10, 2011 at 12:16 am

    #1405543

  • RE: SET BASED QUERY

    NO, you have garbage; Tables have keys and you do not. Tables ought to in at east First Normal Form and the garbage is not.

    It may be a fact...

    November 10, 2011 at 12:11 am

    #1405541

  • RE: Restore Never Finishes

    patrick-511016 (11/9/2011)

    4 gig mdf and 4 gig ldf. I have upgraded to SP4 on SQL 2000 and SP1 on 2008 R2, and tried to restore again. This time...

    November 10, 2011 at 12:01 am

    #1405537

  • RE: Trim sql 2008 Analysis Service Memory use....

    Most Welcome. 🙂

    November 9, 2011 at 11:57 pm

    #1405533

  • RE: Soft numa, is this MS article incorrect

    It's Correct.

    CPUs 1 2 3 4 5 6 7 8

    Soft-NUMA <-N0--><-N1-><----N2---->

    SQL Server...

    November 9, 2011 at 11:55 pm

    #1405532

  • RE: Restore Never Finishes

    patrick-511016 (11/9/2011)

    no full text....just sits at 100%

    The last two entries in the log are:

    (Last Entry)-Recovery is writing a checkpointin database 'MyDB' (9). This is an informational message only....

    November 9, 2011 at 11:43 pm

    #1405527

  • RE: Trim sql 2008 Analysis Service Memory use....

    Barkingdog (11/9/2011)

    We have a single server with Sql 2008 installed. We have trimmed its memeory to free up RAM for the OS. Now they want to install sql 2008 Analysis...

    November 9, 2011 at 11:38 pm

    #1405525

  • RE: Managment Studio. Different PC's give different result for same query.

    Scott Levy (11/9/2011)

    Just a last update on this if anyone is interested as I think I may have found the source of the inconsistency.

    I believe that it was the local...

    November 9, 2011 at 11:25 pm

    #1405520

  • RE: SQL Server 2012 CTP

    Ali Tailor (11/9/2011)

    SQLRNNR (11/8/2011)

    Denali has been renamed to SQL 2012

    Means Microsoft Not releasing SQL server 2011, They are releasing Denali as SQl server2012?

    THanks

    Believe it or not, I had an intuition...

    November 9, 2011 at 11:19 pm

    #1405517

  • RE: Restore Never Finishes

    patrick-511016 (11/9/2011)

    wanted to know if others have had issues restore a sql 2000 x86 database to a sql 2008 r2 x64 instance?

    Per MSDN there shouldn't be any issues, if:

    The database...

    November 9, 2011 at 11:08 pm

    #1405515

  • RE: alter index rebuild or reorganize?

    Also note that some are not MVPs even if they help tremendously (like myself).

    I have no doubt in this. You are a helpful person indeed. Thank You! 😀

    November 9, 2011 at 8:44 am

    #1405273

  • RE: alter index rebuild or reorganize?

    Actually I don’t want it to happen that I get an opportunity to talk or have lunch with an MVP & I couldn’t recognize him / her. 😀

    My intensions are...

    November 9, 2011 at 8:37 am

    #1405264

Viewing 15 posts - 1,726 through 1,740 (of 2,008 total)