Forum Replies Created

Viewing 15 posts - 41,371 through 41,385 (of 49,558 total)

  • RE: Check db command

    shivayogigouda.patil (1/27/2009)

    How to execute DBCC CheckDb command to remove the consistency errors found in msdb database.

    Do we suppose to get the database in single user mode?

    The preferred way to fix...

    January 27, 2009 at 11:33 pm

    #933637

  • RE: Using EXECUTE (@sqlvar) in function

    smeet.sinha (1/27/2009)

    Can't we use execute statement in functions?????

    No, you can't.

    My second question is : How can i store a value returned from execute(tsql) in a variable.

    Look up sp_executesql. It...

    January 27, 2009 at 11:30 pm

    #933636

  • RE: Newbie:Why is select doing a table scan?

    ScottPletcher (1/27/2009)

    It looks to me like SQL is using the non-clus index on the lookup table.

    If you look at the exec plan, you'll notice it's a table scan on the...

    January 27, 2009 at 4:39 pm

    #933558

  • RE: Query question

    Just a note for the future. Please post SQL 2000-related questions in the SQL 2000 forums

    January 27, 2009 at 4:37 pm

    #933557

  • RE: Backup and Restore affect indexes or free space?

    kevinsql7 (1/27/2009)

    When you back up a sql server database and then restore it, is the restored database more efficient (as far as querying)?

    No.

    Does a simple backup (without any options...

    January 27, 2009 at 1:20 pm

    #933472

  • RE: sys.allocation_units corrupted

    James Zhang (1/27/2009)

    Anybody knows what could be the possible reasons for this to happen? Also, is it possible that an application could have caused this (by doing SQL) or is...

    January 27, 2009 at 1:16 pm

    #933471

  • RE: What are the Party Plans?

    Steve Jones - Editor (1/27/2009)

    I believe it is. There's a company that lets you donate for purchases. I'll get the URL and put it up here

    So you're buying from 2...

    January 27, 2009 at 12:48 pm

    #933462

  • RE: Adding non-c index to large table

    noeld (1/27/2009)

    So you advice still holds, do it at "off-peak" hours.

    Absolutely. A former colleague of mine recently took down a business-critical system by deciding to create an index during peak...

    January 27, 2009 at 12:46 pm

    #933459

  • RE: What are the Party Plans?

    Steve Jones - Editor (1/27/2009)

    We're donating some rainforest, purchasing 1mm sq ft of rainforest as a celebration. That's a nice charitable act I agree with.

    We'll also give away 100 or...

    January 27, 2009 at 10:46 am

    #933377

  • RE: Backup Database and Log options "question"

    Something like that.

    One folder per database, and both database and log backups get time stamps. So, for 2 databases, I'd have something like this:

    DB1\DB1_Full_20090101.bak

    DB1\DB1_200901010800.trn

    DB1\DB1_200901010815.trn

    DB1\DB1_200901010830.trn

    DB1\DB1_200901010845.trn

    DB1\DB1_200901010900.trn

    DB1\DB1_200901010915.trn

    DB1\DB1_200901010930.trn

    DB2\DB2_Full_20080101.bak

    DB2\DB2_200901010800.trn

    DB2\DB2_200901010815.trn

    DB2\DB2_200901010830.trn

    DB2\DB2_200901010845.trn

    DB2\DB2_200901010900.trn

    DB2\DB2_200901010915.trn

    DB2\DB2_200901010930.trn

    Now the maintenance plan can do that...

    January 27, 2009 at 10:34 am

    #933367

  • RE: Adding non-c index to large table

    noeld (1/27/2009)

    It is not the same to try on a desktop without user interaction than on an actively used server 😉

    True, but I'd hope most servers are more powerful than...

    January 27, 2009 at 10:30 am

    #933363

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (1/27/2009)

    I don't mind cut and paste, but if you have me create a table(s), include a drop table(s) at the bottom.

    That's why I use tempDB for...

    January 27, 2009 at 10:20 am

    #933349

  • RE: Urgent HELP ME¡¡¡¡¡¡ Some one

    clperez271172 (1/27/2009)

    , I have a hardship because now I need to know where is the last functional execution of my DTS in my system, but, this I execute myself via...

    January 27, 2009 at 10:14 am

    #933339

  • RE: How to manage mdf and lfd files 4 performance

    John Reid (1/27/2009)

    Nevertheless, just looking at the issue of how to split an existing database into several data files, am I right in thinking that this can only be done...

    January 27, 2009 at 9:59 am

    #933325

  • RE: Are the posted questions getting worse?

    Bob Hovious (1/27/2009)

    One more post towards 1000.... and close to the original topic here. How many people get annoyed by people who cut and paste data rather than...

    January 27, 2009 at 9:50 am

    #933317

Viewing 15 posts - 41,371 through 41,385 (of 49,558 total)