Forum Replies Created

Viewing 15 posts - 241 through 255 (of 1,221 total)

  • RE: How to easily test SQL Codes online and share them with others ?

    Have you considered downloading SQL Server Express (free) or buying SQL Server Developer Edition (about $50)? You'd have your own full-blown copy to play with then.

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Commercial Software with All Tables as Heaps and Terrible Performance

    Matt Miller (#4) (9/14/2015)


    Eirikur Eiriksson (9/14/2015)


    Jeff Moden (9/14/2015)


    Eirikur Eiriksson (9/13/2015)


    Using heap to speed the inserts is like a very bad Credit Card deal, no transaction fees but X000% Annual interest...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: MS-Jet Engine 4.x ODBC enabled databases to 1 Terabyte/5 billion rows (or) SQL SERVER?

    erichansen1836 (9/11/2015)


    I think it is important to ask questions such as whether it is more prudent to use:

    MS-Access, MS-Jet Engine(w/o MS-Access), SQL Server Express, or SQL Server for any particular...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Annual Security Compliance Training

    Eric JOATMON (9/8/2015)


    Most of our training seems to be common sense type things. Depending on the topic, I will skim the materials (for unfamiliar things) or just click NEXT...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Save query results directly using variables and date/time

    SpeedSkaterFan (9/2/2015)


    I will dive into Powershell

    In fact I have looked on Youtube, but these films take longer than I had time today.

    The learning never ends 😀

    Hein

    A couple more sources. ...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: STUFF

    Very interesting. And if you change the second line to SET @TrueValue = ' '; then you get 123 as the output.

    Definitely worth knowing.

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Registered server documenter

    This is REALLY weird. I'm running '14 Developer's Edition on my desktop and I can't do a select * from sys.configurations. The system comes up and says "Incorrect...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Object Relational Modeling (ORM) Examples

    Shortcuts taken early in the project can have significant costs in the later stages, so is it really a savings? For me the takeaway is that developers need to...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: The Problem Solver

    Eric M Russell (8/28/2015)


    ... I spend my days in an office working with other IT professionals, not hanging out at a coffee shop with friends or watching episodes of Oprah...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: A Clock With Benefits

    Wow, a 35,000 word article? That's a short story! It took me pretty much a full day to read it! (don't tell my boss)

    It had a lot of...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: What is the timestamp data type for?

    Happy to help, Rod! Either your developer knew to apply them or the upsizing wizard might have added them. You might want to keep the new fields rowversion...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: The Tally Table

    Ed Wagner (8/26/2015)


    Jeff Moden (8/26/2015)


    Wayne West (8/26/2015)


    Jeff Moden (8/26/2015)


    dwain.c (8/25/2015)


    Thank the Buddha for whoever came up with the idea of a Tally table in the first place! I just...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: What is the timestamp data type for?

    Rod, if your database's front end is Microsoft Access, or if people are using Access against it, you might want to keep it. Access likes rowversion to see if...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Strange Filtered Index Problem

    Very interesting, I need to remember to keep an eye out for that @.

    Thanks for the good article, Mike!

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: A Clock With Benefits

    ZZartin (8/26/2015)


    I like how xkcd explained it, http://xkcd.com/1425/

    I think the most telling part of that comic is what the cursor hovertext describes. I've learned to ALWAYS read the hovertext,...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

Viewing 15 posts - 241 through 255 (of 1,221 total)