Forum Replies Created

Viewing 15 posts - 45,211 through 45,225 (of 49,552 total)

  • RE: Stored procedure select permission without table access (using sp_executesql)

    Michael Lato (8/8/2008)

    If you are coming to PASS in Seattle this year I'll be sure to buy you a beer.

    Make it coffee and you're on.

    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 8, 2008 at 9:24 am

    #855308

  • RE: Simple NEWB question. When doing backup, TRANS_LOG & FILEGROUP greyed out

    Files and filegroup backups will not be allowed if you only have one file or filegroup.

    To enable log backups you'll have to switch to full recovery and take a...

    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 8, 2008 at 9:22 am

    #855306

  • RE: The Active DBA

    timothyawiseman (8/8/2008)

    Several people have mentioned martial arts, which is something I am interested in doing probably with my son when I have the time and money to do it. ...

    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 8, 2008 at 9:07 am

    #855286

  • RE: Error - The log cannot be rebuilt because the database was not cleanly shut down

    Run the alter database, then take that database offline, go to the file system, rename the file, bring the DB online. You don't have to restart the entire SQL...

    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 8, 2008 at 8:49 am

    #855263

  • RE: The Active DBA

    Steve Jones - Editor (8/8/2008)

    I'd have thought that Gail and Grant would just sit a bow in the corner of their cube and eliminate all complaints in person. Hard 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 8, 2008 at 8:43 am

    #855253

  • RE: The Active DBA

    Someguy (8/8/2008)

    skjoldtc (8/8/2008)

    Woodchopping with a nice sharp axe.

    Axes, martial arts practitioners-

    You forgot the archers.

    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 8, 2008 at 8:41 am

    #855248

  • RE: Stored procedure select permission without table access (using sp_executesql)

    If you create the procedure WITH EXECUTE AS, then you don't need to grant any impersonation permissions. Only the person creating the proc will need impersonation rights, not the person...

    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 8, 2008 at 8:37 am

    #855242

  • RE: Automatic Statistics Maintenance - Good or Bad

    Check sys.dm_db_index_physical_stats, or run DBCC SHOWCONTIG

    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 8, 2008 at 8:32 am

    #855236

  • RE: No More Katmai

    Loner (8/8/2008)

    Is there any advantage to migrate from SQL Server 2005 to 2008 if there are not much difference?

    Depends whether or not you need or want any of the new...

    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 8, 2008 at 8:31 am

    #855234

  • RE: Automatic Statistics Maintenance - Good or Bad

    Christopher Stobbs (8/8/2008)

    HI All,

    I just ran an index rebuild on a table and it still has a fragmentation of over 90%????

    How big is the table? It's not uncommon for very...

    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 8, 2008 at 8:24 am

    #855224

  • RE: Which index option is the best

    Look here - http://www.sqlservercentral.com/Forums/Topic540094-338-1.aspx

    Haven't I helped you with this query before? It looks awfully familiar.

    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 8, 2008 at 8:23 am

    #855221

  • RE: Automatic Statistics Maintenance - Good or Bad

    Grant Fritchey (8/8/2008)

    Page splits, rearranging the order of pages, becuase of updates or inserts. Also gaps left by deletes.

    Shrinking the database or the data file.

    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 8, 2008 at 8:22 am

    #855220

  • RE: Error - The log cannot be rebuilt because the database was not cleanly shut down

    Interesting, and unrelated to the file name issues.

    Got a network admin there? First thing you need to do is figure what's listening on port 2987.

    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 8, 2008 at 8:20 am

    #855217

  • RE: Which index option is the best

    I'll be blunt. There's little point in indexing that. The multiple constant comparisons and ORs confuse the optimiser, plus there is no one stable, optimal plan for it. It will...

    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 8, 2008 at 8:06 am

    #855197

  • RE: Error - The log cannot be rebuilt because the database was not cleanly shut down

    Did you move the ldf file? Alter database just changes the metadata, it doesn't move the physical file. You have to do that yourself.

    Shut SQL down, find the log file...

    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 8, 2008 at 7:55 am

    #855186

Viewing 15 posts - 45,211 through 45,225 (of 49,552 total)