Forum Replies Created

Viewing 15 posts - 13,186 through 13,200 (of 49,552 total)

  • RE: I would REALLY like some fast help with this problem!

    SQL 2000 isn't supported any longer, get SQL 2012 and use that.

    We're volunteers here, we post in our spare time. Asking for someone to remote into your machine is...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 12, 2013 at 2:57 am

    #1614431

  • RE: Trying to copy database from my laptop to my desktop pc

    AndrewSQLDBA (5/11/2013)

    pl-sql is different that t-sql pl is Oracle based, which is cursive based. SQL Server is set based and uses t-sql Much more advanced language than pl-sql

    pl/sql is set-based...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 12, 2013 at 2:55 am

    #1614430

  • RE: Trying to copy database from my laptop to my desktop pc

    This is a Microsoft SQL Server site, not a generic, any database engine site. Specifically this forum is for Microsoft SQL Server 2008. We're SQL Server people here, not Oracle...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 12, 2013 at 2:48 am

    #1614429

  • RE: Trying to copy database from my laptop to my desktop pc

    AndrewSQLDBA (5/11/2013)

    Simple create a database, you can name it the same name or not. It does not matter. Then follow the instructions that Gila sent on restoring a database.

    Err.. why...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 11, 2013 at 4:25 pm

    #1614411

  • RE: Trying to copy database from my laptop to my desktop pc

    nerd_buzz (5/11/2013)

    i am not using SQL Server Management Studio. I am using orcle sql developer verison 1.5.3 on my laptop and ver 3.2.20.09 on my desktop.

    Why would you use...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 11, 2013 at 4:23 pm

    #1614410

  • RE: What is a semicolon used for in SQL Server?

    To be honest, I doubt they'll be required everywhere anytime in the next 8-10 years. Required in more and more places around new features, yes. Required everywhere, well, we still...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 11, 2013 at 4:22 pm

    #1614409

  • RE: Trying to copy database from my laptop to my desktop pc

    A SQL Server database backup. So from SQL Server Management Studio, right click the database Tasks-> Backup. Copy the backup file that's created over to your other machine and restore...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 11, 2013 at 12:36 pm

    #1614397

  • RE: I m using MS-SQL server 2005, and i want to schedule job on the interval of 15 day

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 11, 2013 at 10:47 am

    #1614390

  • RE: I m using MS-SQL server 2005, and i want to schedule job on the interval of 15 day

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 11, 2013 at 8:14 am

    #1614383

  • RE: Index on a Column with NULLs

    No effect. As far as an index is concerned, null is just another value.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 11, 2013 at 7:37 am

    #1614382

  • RE: Increasing Performance of Database

    You need to tune the queries, perhaps add indexes (and btw, 500000 rows is tiny)

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 11, 2013 at 4:47 am

    #1614378

  • RE: Trigger effect

    With the IF UPDATE construct that Sean gave you. The trigger will still run, but the IF will return false and hence the code inside won't run.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 11, 2013 at 3:39 am

    #1614377

  • RE: restored database failed

    SQL should not generally run as local system, it should run under a minimal privileged domain account.

    You got the error because SQL did not have permission on the folder with...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 11, 2013 at 3:38 am

    #1614376

  • RE: What is a semicolon used for in SQL Server?

    Jeff Moden (5/10/2013)

    I understand what the semi-colon can do so far as ending a statement but it worked just fine before without it before.

    Increasing complexity of the language. SQL is...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 11, 2013 at 3:35 am

    #1614374

  • RE: Selectively delete items in a delete trigger

    Triggers (any triggers) aren't recursive. AFTER triggers can be made recursive by turning the database option on (though I haven't seen many cases where that's a good idea)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 10, 2013 at 3:14 pm

    #1614319

Viewing 15 posts - 13,186 through 13,200 (of 49,552 total)