Forum Replies Created

Viewing 15 posts - 46 through 60 (of 197 total)

  • RE: ALTER TABLE advise

    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 to confirm that...

    November 14, 2012 at 3:28 pm

    #1559157

  • RE: PREEMPTIVE_OS_WRITEFILEGATHER & LOGBUFFER

    Ratheesh.K.Nair (11/14/2012)

    Hi Experts,

    I am getting the wait_type as PREEMPTIVE_OS_WRITEFILEGATHER & LOGBUFFER when executing a particular job.

    The job finds data older than 3 years and then move them to another table....

    November 14, 2012 at 12:57 pm

    #1559090

  • RE: Unable to Rebuild or Reorganize an Index

    Our index maintenance process includes a "SET LOCK_TIMEOUT" statement so that if any one index rebuild is blocked longer than the duration, it times out and moves on to the...

    November 14, 2012 at 12:33 pm

    #1559081

  • RE: splitting tempdb to multiple files - max size?

    sqldba_newbie (11/10/2012)

    i have noticed tempdb contention on our tempdb, so i want to split the data file to multiple files.We have 24 cores, i know that i shouldn't be splitting...

    November 11, 2012 at 9:10 am

    #1557960

  • RE: Tlog Shipping

    GilaMonster (11/9/2012)

    George M Parker (11/9/2012)

    Standby actually brings the database online and makes it read only.

    Not quite. The DB is not brought online, if it was, further log backups would...

    November 10, 2012 at 8:00 am

    #1557912

  • RE: Tlog Shipping

    sdvandeslunt (11/9/2012)

    Hi guys, I have an issue I hope you can help with. I'm hoping I don't know the answer already...

    I have a SQL 2005 database (SP3) and a...

    November 9, 2012 at 12:06 pm

    #1557769

  • RE: How to pass a Microsoft certification [70-432]

    Passing a SQL Server exam takes a lot of hard work and a willingness to put in the effort to actually learn the material. The best way to do that...

    November 9, 2012 at 9:40 am

    #1557687

  • RE: What is the Safest and Fastest Way to Move Data Between Two MSSQL Installations?

    aaronjameswalters (11/9/2012)

    Thanks for the input everyone. Please keep the votes coming. It seems that import/export is avoided by most of you. is there a reason for this?

    Import/Export are problematic when...

    November 9, 2012 at 9:36 am

    #1557686

  • RE: SQL Database moved under System Databases by mistake

    Just curious, were you able to resolve this issue?

    November 8, 2012 at 4:39 pm

    #1557403

  • RE: SQL Monitoring Software

    Jon.Morisi (11/8/2012)

    Hi,

    I'm preparing to investigate several monitoring software products. Some of the key features I'm looking for are:

    1. Ability to scrape Windows Application log for MSSQL Errors and...

    November 8, 2012 at 2:13 pm

    #1557357

  • RE: Large fixed width to sql help please!

    Agree, SQL Server Integration Services is the way to go, that's what it was built to do and it does it very well. :w00t:

    November 8, 2012 at 2:06 pm

    #1557354

  • RE: DB backup single user mode

    sqlfriends (11/8/2012)

    We would like to migrate databases from one server to another production server.

    Before I do a backup on the old server, we would like no one connect to...

    November 8, 2012 at 1:50 pm

    #1557349

  • RE: Smart Index Rebuild - All Databases

    You've modified the code to use the ALTER INDEX instead of the DBCC DBREINDEX, but you're still using the legacy DBCC SHOWCONTIG to determine fragmentation. Also, I don't see anything...

    November 8, 2012 at 12:46 pm

    #1557335

  • RE: how to keep away from identity as primary key

    I know that if my primary key is identity it slows down the system

    Where did you hear that from? First, are you concerned about an identity column being used as...

    November 8, 2012 at 10:53 am

    #1557292

  • RE: User SP on Master DB

    Ratheesh.K.Nair (11/8/2012)

    The procedure is used to take CPU statistics,backups,update statistics,shrink ,fragmentation etc.

    These procedures i think created by DBAs but extensively used by developers.

    In that case, I would typically create a...

    November 8, 2012 at 8:18 am

    #1557206

Viewing 15 posts - 46 through 60 (of 197 total)