Forum Replies Created

Viewing 15 posts - 16 through 30 (of 235 total)

  • RE: It''s been a long ride.

    Yea Steve, the 2311 was a clear cover.  You could see it spin, the arm also move straight in and out.

    One of the links indicated the platter assembly, removable, weighed...

  • RE: It''s been a long ride.

    Well I don't have the details, or the time to find all of them.  That is some great work Steve.

    I've been in this industry 35+ years, not bad for an...

  • RE: Aye Yi Yi

    Well I agree the snail spam is as bad as the espam.  And I realize that recycling paper is a good thing.

    BUT IDENTITY THEFT IS A PROBLEM.

    And dumpster diving is...

  • RE: Aye Yi Yi

    And they had it one the news recently, Gates get 1 million a day !!

  • RE: Windows defragmentation

    If you have the opurtunity, I can't see where it would hurt.

    But, make a backup first, and you have to stop SQL Server, at least close the DB. But if...

  • RE: Server Crash

    Look up SP_CHANGE_USERS_LOGIN 'Auto_Fix', 'user'

    I think if you add it as a SERVER login, then run the above inside the db in ? it should fix it.

  • RE: Linked Server Problems from changed table

    Query Cache had something in it until SQL Server decided to recompile the Query.

    I know there is a way to flush the whole cache, but that wouldn't seem to be...

  • RE: Server Crash

    First make a copy of the MDF AND LDF to somewhere safe.

    Then look at Attach, either via EM or SP_Attach.  Check BOL for details.

     

  • RE: Determine Database Activity

    Give this a try, it is an addon to the DBHistory process I wrote a while back.  It collects IO history(Logical), by DB.  You need to schedule it to run...

  • RE: # of Connections to the database

    Try this, if you don't want by s specific DB, jsut rip that part out.

    SET NOCOUNT ON

    DECLARE @DBName AS VarChar(50)

    SET @DBName = '?????'

    SELECT

    'Distinct Users - ' + CAST(COUNT(Distinct(loginame))...

  • RE: How many platforms Do You Run at Home

    Too many computers, although technically all MS

    SBS2003 as the Domain, Exchange, Proxy, SUS ..

    Win2KEE with SQL Server 2000, and UDB, will add Oracle when I get a break. 2gig ram,...

  • RE: Multiple Instances of SQL on the same server? - Opinions Please

    Brian, that was a relatively recent ( 6 to 12 mth) change in licensing. I'm glad you found the specifics, I had only heard comments from MS.

    Multiple instances run just...

  • RE: MSDE tool recommendations

    Just a note though.

    I don't think that approach is legal, you have to OWN a copy of the full SQL product to use EM etc against MSDE. Or whatever the...

  • RE: Formatting numbers (commas and decimal)

     

     

    LEFT(CONVERT(Char(12), CAST(MyNumber AS Money), 1) , 10)

    By manipulating the LEFT and the CAST you can control size and # of decimals

  • RE: Either Easy or Tough Join

    Thanks Herb that did it.

    I was close, I think I was just thinking too hard.

Viewing 15 posts - 16 through 30 (of 235 total)