Forum Replies Created

Viewing 15 posts - 44,296 through 44,310 (of 49,552 total)

  • RE: Datatype conversion

    Pleasure.

    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

    September 22, 2008 at 4:24 pm

    #875319

  • RE: SQL Server Black Book on Indexes & Statistics, Got One?

    colin Leversuch-Roberts (9/22/2008)

    kalen Delaney wrote some of the best consise books on indexing prior to sql 2005. From sql2005 onwards you seem to need more and more books just 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

    September 22, 2008 at 4:21 pm

    #875316

  • RE: Datatype conversion

    Precision is the total number of digits in the number (to the left and right of the decimal place). Scale is the number of digits to the right of 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

    September 22, 2008 at 4:11 pm

    #875312

  • RE: Uniformkey

    There's no such data type in SQL Server.

    Can you get some clarification from the person who requested this as to what they mean?

    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

    September 22, 2008 at 4:06 pm

    #875309

  • RE: SQL Server 2005 This machine does not have a package that matches this installation package

    Please run the following and post the results

    SELECT @@Version

    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

    September 22, 2008 at 4:04 pm

    #875307

  • RE: SQL Server Black Book on Indexes & Statistics, Got One?

    YSLGuru (9/22/2008)

    The system uses Statistics to determine fragmentation and when you rebuild an index there is no need to rebuild the statistics as SQL Server handles that for you. ...

    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

    September 22, 2008 at 4:03 pm

    #875305

  • RE: Datatype conversion

    It fits into a numeric (15,1). Any numeric (or decimal, they're equivalent) with a precision of 15 or higher and a scale of 1 will work.

    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

    September 22, 2008 at 3:57 pm

    #875302

  • RE: Datatype conversion

    Please don't cross post. It just wastes people's time and fragments replies.

    No replies to this thread please. Direct replies to:

    http://www.sqlservercentral.com/Forums/Topic573869-1291-1.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

    September 22, 2008 at 3:54 pm

    #875300

  • RE: Split and move data from one file to multiple files

    There's no option to split a DB as part of a restore.

    You'll have to create two new files, place them into two new filegroups and then move tables over into...

    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

    September 22, 2008 at 3:52 pm

    #875299

  • RE: Users: Are they active?

    There's no way to tell unless you've had some form of custom auditing logging when users log 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

    September 22, 2008 at 3:51 pm

    #875297

  • RE: Reading Transaction Logs

    Redgate's one works only for SQL 2000. From what I've heard there's no log reader yet that can understand all the entries that SQL 2008 can make.

    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

    September 22, 2008 at 2:06 pm

    #875264

  • RE: restore issue in sql 2000

    The DB doesn't have to be in single user mode, but there must be no connections using that database, sleeping or otherwise.

    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

    September 22, 2008 at 2:05 pm

    #875263

  • RE: Shrink File Operation can cause Index Fragmentation

    You get inden fragmentation from shrinking the data file. If you repeatedly shrink and grow the log though, you'll get fragmentation within the log.

    The transaction log consists of a number...

    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

    September 22, 2008 at 1:54 pm

    #875254

  • RE: Transaction Log and Recovery Model

    Are the log backups succeeding?

    Maintenance plan of custom job?

    What's the pattern of log growth? Is it stable in size during the day and growing at night? Is it constantly growing?

    If...

    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

    September 22, 2008 at 10:27 am

    #875137

  • RE: When is a Database truly a SQL Server 2005 Database?

    YSLGuru (9/22/2008)

    2) Are there features and or changes in T-SQL as of SQL 2005 that are not applicable to use against a database on SQL 2005 with a compatability level...

    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

    September 22, 2008 at 10:23 am

    #875134

Viewing 15 posts - 44,296 through 44,310 (of 49,552 total)