Forum Replies Created

Viewing 15 posts - 43,066 through 43,080 (of 49,552 total)

  • RE: Grant Create User permission

    What didn't you understand? What I posted is the syntax (as an example) of a grant statement that grants the permission to alter any user in the database Database1 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

    November 20, 2008 at 10:05 am

    #901168

  • RE: 2008 PASS Summit Blogging

    Likewise, and i know Grant is also - http://scarydba.wordpress.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

    November 19, 2008 at 4:43 pm

    #900789

  • RE: Rebuild Index and .mdf file growth.

    Very likely, because the index rebuild works by creating a complete new index before dropping the old one. So unless you have a fair amount of free space within 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

    November 19, 2008 at 4:20 pm

    #900787

  • RE: Using a variable WHERE clause in a stored procedure

    tom (11/19/2008)

    I was hoping to construct the WHERE clause in C# and send it as a single parameter and that does not appear to work.

    no, it won't. SQL won't allow...

    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

    November 19, 2008 at 4:12 pm

    #900781

  • RE: Error: 18456, Severity: 14, State: 16

    That means whoever configured the Quest tool configured it to use the sa account and specified an incorrect password. Not the fault of the tool

    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

    November 19, 2008 at 4:10 pm

    #900780

  • RE: Advice for a new DBA

    I feel that one of the best ways to find what you don't know is to study for a certification (or just check the MS site for the requirements) and...

    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

    November 19, 2008 at 2:22 pm

    #900735

  • RE: Using a variable WHERE clause in a stored procedure

    There's no direct way. You can use dynamic SQL and concatenate the where clause to the end of the string and execute that, but you open the system to 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

    November 19, 2008 at 2:00 pm

    #900729

  • RE: Are the posted questions getting worse?

    Jeff Moden (11/18/2008)

    consider the answer that one wiz kid gave...

    "You should be using derived column transformation, and use substring or available string functions. This would help." ... and that's...

    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

    November 19, 2008 at 1:55 pm

    #900726

  • RE: Reporting Bugs In Business Intelligence Development Studio

    mikebally888 (11/19/2008)

    Hi,

    Maybe you can try removed here too 😉 ,it is better than Crystal Report in many aspects

    Where does anyone mention crystal reports, or any reporting tool for...

    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

    November 19, 2008 at 1:43 pm

    #900718

  • RE: nvarchar vs int :(

    arluna (11/19/2008)

    I want to know if I use this nvarchar column in sql queries, to identify the rows, has performance problems

    Shouldn't, as long as it's indexed

    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

    November 19, 2008 at 1:42 pm

    #900717

  • RE: Fatal error 824

    mobile (11/18/2008)

    - hacer new query en master.

    - alter database dbname set emergency

    - ALTER DATABASE DBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    - dbcc checkdb ('dbname', repair_allow_data_loss)

    - alter database dbname set multi_user

    saludos

    Repair should...

    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

    November 18, 2008 at 7:12 pm

    #900251

  • RE: SQL 2005 Log File Question - Brute force attack using sa

    I'd suggest disabling the sa account

    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

    November 18, 2008 at 7:11 pm

    #900248

  • RE: CHECKDB and REINDEX

    Log truncate job?

    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

    November 18, 2008 at 7:09 pm

    #900247

  • RE: SQL Injection Prevention

    J (11/17/2008)

    Gail,

    I have always found your writings very interesting.

    Regarding your solution, it is not immediately clear how your suggestion works in terms of being less susceptible to attack. Would...

    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

    November 18, 2008 at 7:06 pm

    #900245

  • RE: SQL 2000 DB to 2008

    How about

    SELECT * FROM sysusers where name = 'sys'

    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

    November 18, 2008 at 6:52 pm

    #900241

Viewing 15 posts - 43,066 through 43,080 (of 49,552 total)