Forum Replies Created

Viewing 15 posts - 7,501 through 7,515 (of 39,902 total)

  • 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

  • RE: Go Code

    skeleton567 (11/10/2016)

    Sure, and more people should drive 18-wheelers on the interstates. I think I'll go over the airport and volunteer to fly a load of folks to Chicago today,...

    November 10, 2016 at 10:00 am

    #1911702

  • RE: Go Code

    roger.plowman (11/10/2016)

    Having been a developer for 30 years now I hate to rain of Steve's parade, but perhaps I have a different view of what he means by coding than...

    November 10, 2016 at 9:53 am

    #1911699

  • RE: estimate the t-log grow

    I would tend to use Gail's advice. However, if index rebuilds are your largest operation, and you can size the log for that, then it's not a bad way to...

    November 9, 2016 at 4:19 pm

    #1911513

Viewing 15 posts - 7,501 through 7,515 (of 39,902 total)