Forum Replies Created

Viewing 15 posts - 7,351 through 7,365 (of 39,758 total)

  • RE: A New Recovery Tool for Your Toolbelt

    Eric M Russell (11/15/2016)

    ...Have you ever updated every row of a table to the same value because of a poorly written query? I have. A temporal table would have been...

    November 15, 2016 at 8:45 am

    #1912555

  • RE: Fantasy Football 2016

    It was a mixed bag for me. As a Cowboys fan, I was glad to see them get the win, but didn't need Elliot to rumble for that last TD....

    November 15, 2016 at 8:35 am

    #1912548

  • RE: Are the posted questions getting worse?

    GilaMonster (11/14/2016)

    Steve Jones - SSC Editor (11/14/2016)

    I would be happy to make you a moderator, but it consumes lots of bandwidth. The #$%#$@# way the forums are setup is you'll...

    November 14, 2016 at 10:56 am

    #1912321

  • RE: SSMS 2016 Default Open + Save Path for Scripts

    gavin.porter (11/14/2016)

    Hi Thom~,

    thanks again, i found it meanwhile. There is a registry entry called DefaultFileOpenLocation under HKCU. I wonder why you could not set up those settings in the application.

    I...

    November 14, 2016 at 10:55 am

    #1912320

  • RE: Using the DAC

    Ed Wagner (11/14/2016)

    Good question because I learned something new. I just hope I remember it when we get to use SQL 2016, which will probably be around 2020 or...

    November 14, 2016 at 9:06 am

    #1912292

  • RE: THE Database Engine

    Michael J. Babcock (11/14/2016)

    Corrected url: https://www.oreilly.com/ideas/in-search-of-database-nirvana

    did the link not work for you? Appears to be working.

    November 14, 2016 at 7:30 am

    #1912254

  • RE: Are the posted questions getting worse?

    GilaMonster (11/14/2016)

    Jeff Moden (11/13/2016)

    GilaMonster (11/13/2016)

    Ed Wagner (11/12/2016)

    I just hid a bunch

    How???

    I'm sick of just reporting them and having the spam hang around for hours afterwards

    Ask Steve to give you the...

    November 14, 2016 at 7:27 am

    #1912253

  • RE: Are the posted questions getting worse?

    Thanks, Jeff, and we do appreciate the efforts.

    Our forum software is old, and it has issues with SPAM. There are developers looking to upgrade things to a more modern architecture...

    November 13, 2016 at 8:41 pm

    #1912140

  • RE: SSMS 2016 Default Open + Save Path for Scripts

    If you go into Tools - Options, you will see import/export. That's the file to change. Mine is in VS 2015/Settings/SSMS. Change the ProjectsLocation key.

    However, do this when SSMS is...

    November 13, 2016 at 6:31 pm

    #1912135

  • RE: Information on SQL clustered environment

    +1 to what John noted.

    November 12, 2016 at 6:29 pm

    #1912096

  • RE: INSERTing datetimeoffsets

    Arrgghhh, I officially hate this question.

    I must have forgotten to hit save.

    Question:

    I have a simple table:

    CREATE TABLE TimeZoneOffsetTest

    ( mytime DATETIMEOFFSET)

    GO

    Which of these is invalid for inserting a row?

    Answers:

    a)...

    November 11, 2016 at 1:00 pm

    #1911998

  • RE: INSERTing datetimeoffsets

    Corrected now. checked the wrong box.

    November 11, 2016 at 10:51 am

    #1911963

  • RE: The Google Solution

    Perhaps one way to make restores easier is to generate the restore script at backup time for any particular full backup.

    That could be a great way to improve the restore...

    November 11, 2016 at 10:17 am

    #1911949

  • RE: Go Code

    djackson 22568 (11/10/2016)

    Let's face it, there are people who are extremely intelligent, all the way through dumb as a rock. IQ tests are built to measure this very concept....

    November 10, 2016 at 10:04 am

    #1911708

  • RE: Go Code

    mjh 45389 (11/10/2016)

    I can only see it being of use if it is done well. Over the last thirty years the bane of my life has been people who have...

    November 10, 2016 at 10:03 am

    #1911707

Viewing 15 posts - 7,351 through 7,365 (of 39,758 total)