Forum Replies Created

Viewing 15 posts - 44,791 through 44,805 (of 49,552 total)

  • RE: Error conecting because of Login Trigger

    Does sql_login have rights on the blacklist table?

    What you can do to debug is something like this (untested):

    CREATE TRIGGER connection_limit_trigger

    ON ALL SERVER WITH EXECUTE AS 'sql_login'

    FOR LOGON

    AS

    BEGIN

    BEGIN TRY

    IF ORIGINAL_LOGIN()= 'sql_login'...

    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

    August 29, 2008 at 8:02 am

    #865022

  • RE: 2005 vs 2000 use of tempdb

    Have you done a full stats update on all tables after the 2005 upgrade? If not, that could result in non-optimal query plans.

    Run profiler for a while and capture the...

    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

    August 29, 2008 at 2:28 am

    #864879

  • RE: Problem when upgrading to SQL 2008 with a renamed 'sa' account

    Could you post this as a bug on Connect please?

    http://connect.microsoft.com

    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

    August 29, 2008 at 1:50 am

    #864865

  • RE: What Happened?

    Clustered SQL installation?

    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

    August 29, 2008 at 1:49 am

    #864863

  • RE: SQL Server 2003 ???????

    That's probably what happened. The owner of the site said that page hasn't been changed in years.

    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

    August 29, 2008 at 1:34 am

    #864858

  • RE: Best Practice for backups - include master, model, etc. db's?

    Master contains all the information on the logins on the SQL server, as well as the database references, the linked servers, server-level triggers and server settings.

    Model is used to...

    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

    August 29, 2008 at 1:33 am

    #864857

  • RE: What exactly can user do with public role

    Denise McMillan (8/28/2008)

    Thank you, that's what I thought. But our vendor is trying to say that all rights to all databases come with public role.

    Tell then to stop talking...

    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

    August 28, 2008 at 4:01 pm

    #864748

  • RE: What exactly can user do with public role

    Depends on what permissions have been granted to the public role. If no permissions have been granted to it, then users with just public will have no rights to do...

    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

    August 28, 2008 at 2:48 pm

    #864708

  • RE: performance errors

    It's teling you that there are slow IOs occuring. The typical range for a single IO operation should be 10-50 ms at the most. The warning is saying that in...

    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

    August 28, 2008 at 12:25 pm

    #864626

  • RE: FULL BACKUPs vs TRANSACTION LOG BACKUPs

    Maybe these two blog posts will help?

    http://www.sqlskills.com/blogs/paul/2007/10/25/DebunkingACoupleOfMythsAroundFullDatabaseBackups.aspx

    http://www.sqlskills.com/blogs/paul/2008/01/31/MoreOnHowMuchTransactionLogAFullBackupIncludes.aspx

    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

    August 28, 2008 at 11:39 am

    #864602

  • RE: Age old Frag vs Index

    DBCC DBREINDEX will do a stats update with full scan as it rebuilds the index.

    DBCC INDEXDEFRAG will not update the statistics at all.

    I would suggest that you do different stats...

    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

    August 28, 2008 at 10:57 am

    #864581

  • RE: SQL Server 2003 ???????

    I mailed them, seeing as they're in my neck of the woods.

    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

    August 28, 2008 at 10:54 am

    #864578

  • RE: Covering index

    GSquared (8/28/2008)

    I got asked this same question as an interview question. I was able to describe a covering index, but I've never heard of a "covering query" before. ...

    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

    August 28, 2008 at 10:45 am

    #864572

  • RE: Age old Frag vs Index

    If you can't do a full scan with update stats, use the RESAMPLE option. It means that the DB engine will adapt the % sampled to ensure it gets enough...

    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

    August 28, 2008 at 5:56 am

    #864271

  • RE: Unable to create table Dynamically

    Sanaullah (8/28/2008)

    Ok but while concatenate we need to add this CREATE TABLE TableName with that, but my main problem is

    iPhotoGalId INT Primary KEY IDENTITY(1,1) NOT NULL ,vPhotoGalTitle VARCHAR(50),dModifiedDate DATETIME(8),iOrder...

    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

    August 28, 2008 at 5:51 am

    #864268

Viewing 15 posts - 44,791 through 44,805 (of 49,552 total)