Forum Replies Created

Viewing 15 posts - 12,856 through 12,870 (of 39,936 total)

  • RE: tempdb files on SSD

    If you run out of space, then yes, the query fails. You don't have to restrict sizes, though as Jason mentioned, this is recommended in some cases. Not sure how...

    January 22, 2013 at 9:37 am

    #1579710

  • RE: tempdb files on SSD

    MyDoggieJessie (1/22/2013)

    It's a good rule of thumb to place it on multiple drives (especially in RAID configuration). Have you taken steps to monitor your tempdb usage and do you...

    January 22, 2013 at 9:36 am

    #1579707

  • RE: tempdb files on SSD

    Tara-1044200 (1/22/2013)

    but i am planning to put them on a single SSD drive which i asusme would be 8 files each of 100gb. so i think any file would be...

    January 22, 2013 at 9:24 am

    #1579700

  • RE: tempdb files on SSD

    MyDoggieJessie (1/17/2013)

    I don't think you can even buy 1TB SSD???

    http://www.newegg.com/Product/Product.aspx?Item=N82E16820227724

    A 2TB SSD was announced last week as well.

    January 22, 2013 at 9:22 am

    #1579698

  • RE: Encryption Not Restriction

    No idea, but I'll ask around.

    January 22, 2013 at 8:53 am

    #1579678

  • RE: SQLServerCentral Runs sp_Blitz - Performance Part 1

    Great explanation from Brent and sorry for the delay in responding. I wouldn't change fill factor without looking at my RAM (target v actual) and the page splits. I'd have...

    January 22, 2013 at 8:28 am

    #1579661

  • RE: Talking baseball

    roryp 96873 (1/18/2013)

    Anyone ever been to Chase Field in Phoenix? I am going to be down there in April and try to catch a game, just wondering if anyone...

    January 18, 2013 at 4:33 pm

    #1578906

  • RE: Are the posted questions getting worse?

    Lowell (1/18/2013)

    Brandie Tarvin (1/18/2013)

    All we need is an actual Go Faster flag for the database, and everything will be FINE.

    got your fix right here:

    to paraphrase Roger Rabbit, pppppppppppplllllllllleeeeeeeeeaaaaaasssseeeeeeee

    Use this technique:...

    January 18, 2013 at 12:55 pm

    #1578857

  • RE: Message Queues in Software

    Miles Neale (1/17/2013)

    Steve Jones - SSC Editor (1/17/2013)

    I'm not advocating Service Broker over other queue mechanisms.

    Steve,

    From the article and the discussion I took away that you are in favor...

    January 18, 2013 at 12:29 pm

    #1578847

  • RE: Are the posted questions getting worse?

    wolfkillj (1/18/2013)

    Evil Kraig F (1/17/2013)

    Was ill for a week, miss anything of import?

    MS announced that SQL Server 2012R2 will be released in late 2014 and will officially support both DBCC...

    January 18, 2013 at 10:15 am

    #1578797

  • RE: The Growth of Storage

    nycdotnet (1/18/2013)

    ...

    Full HD video is something like 10GB/hr - Let's say in the future we have Quad HD (2160p) 60 FPS 3D movies, that's 160 GB per hour or 320...

    January 18, 2013 at 10:01 am

    #1578787

  • RE: The Growth of Storage

    William Vach (1/18/2013)

    I think that before we get there storage/RAM on a laptop will become a moot point. We will have virtual machines in a cloud that we will...

    January 18, 2013 at 9:57 am

    #1578784

  • RE: The Growth of Storage

    -=JLK=- (1/18/2013)

    I have no idea when we'll get there, but I have no doubt we will, though I truely suspect we will see a return to dumb terminals and huge...

    January 18, 2013 at 9:54 am

    #1578782

  • RE: The Growth of Storage

    aberman 63872 (1/18/2013)

    My first computer (apple 2) had 64K of memory.

    Hardware specs for mobile devices will mean less and less as move computing moves to the cloud. My 6...

    January 18, 2013 at 9:52 am

    #1578781

  • RE: Message Queues in Software

    David.Poole (1/17/2013)

    I'm another one who agrees with JimBob.

    I got excited about external activiation but this is service broker talking to an external app, not an external app talking to service...

    January 17, 2013 at 8:14 am

    #1578333

Viewing 15 posts - 12,856 through 12,870 (of 39,936 total)