Forum Replies Created

Viewing 15 posts - 3,136 through 3,150 (of 3,406 total)

  • RE: text -> ntext causes massive size increase...

    Is it purely your text fields or have you converted varchar to nvarchar, char to nchar etc?

    If you used nchar and nvarchar then not only does the base data take...

  • RE: Backup cannot be performed on this DB

    I got caught on this one as well.

    If a database is in "simple" recovery mode then the transaction log backup portion of the maintenance plan will fail.

    Coming from SQL 6.5...

  • RE: add new user with rights using TSQL

    Assuming that you have set up your logins set up then to add them into the database you would use:

    exec sp_grantdbaccess 'the login','the username in the db'

    exec sp_addrolemember 'db_datareader','the username...

  • RE: Stored procedure help needed.

    When I was doing Access/SQL work I set up a passthrough query to SQL that ran my record aggregate stored procedure.

    I then set up a cross-tab query that used the...

  • RE: Is Windows 2003 Really Faster?

    Are there any updates on this?

    The article left off where you were about to upgrade an IIS/SQL box. Has this been done yet and what were the results?

    He was...

  • RE: Make Sql server as secure as possible

    We tend to keep our IIS Servers on separate boxes to SQL Server.

    We remove PUBLIC permissions to virtually all the stored procedures in the MASTER database because by default any...

  • RE: QOD 11/25

    I wouldn't have put it at 3 points and yes and extent was/is 8 contigious pages in SQL.

    When I moved from SQL6.5 through 7 to 2000 I must admit that...

  • RE: OT: Sybase Equivelant to MS SQL TOP?

    You have to do

    SET ROWOCOUNT 5

    SELECT ...etc

    Primitive

    There is a hell of a lot that Sybase doesn't seem to do. DBCC SHOWCONTIG, DBCC DBREINDEX etc.

    I've been trying to find out...

  • RE: QOD 11/25

    I got it wrong because I assumed that an extent was still 2K as it was in SQL 6.5. Yee Gods I hate it when a unit of measure...

  • RE: Adversarial Vendors

    Documentation is key if the supplier goes back on an agreement.

    I had a situation where a product contains faults that need to be fixed. In my case it was...

  • RE: Should DBAs attend Development Meetings

    I am just completing a 3 week task rescuing a bad database design on a poor performing application.

    This has cost a 6 figure sum in terms of man power and...

  • RE: QOD 11/20

    quote:


    Drop the primary key clustered index and create a new one on LAST_ORDER_DT


    This...

  • RE: A Methodology for Determining Fill Factors

    I liked this one although CreateDBREINDEX.sql does not work.

    It creates the temporary tables but doesn't populate them.

  • RE: DataBase Owner

    Your best bet is to set up a database role and grant permissions to that role.

    Then make your users members of that role.

    Don't be tempted to grant permissions to the...

  • RE: QOD 17th Nov

    Question of the Day for 30th February

    Q. Why?

    A. Because!

Viewing 15 posts - 3,136 through 3,150 (of 3,406 total)