Forum Replies Created

Viewing 15 posts - 1 through 15 (of 423 total)

  • Reply To: Fuzzy Search

    This adds a parameter to the function for the string length to compare.  I get the feeling though that ngrams of length 2 are probably the most "intelligent".  Please let...

  • Reply To: Fuzzy Search

    Depending on your situation the length of the search string vs. the length of the target string may be important so you should implement scoring for closer length matches.  Your...

  • RE: Help with SQL memory pressure investigation

    From the graphs I see high CPU, low PageLifeExpectancy, and high Compilations.  All these happen when doing a table Rebuild or REINDEX or Auto Update Statistics.

    I  would do...

  • RE: is there a way to auto-gen crud sprocs in ssms 2017?

    I've got a dozen scripts and functions to generate CRUDs and Change Scripts that I've been perfecting for 10 years and just rewrote them to be even cleaner and more...

  • RE: Singular or Plural

    I read five database design books last year.  They all firmly said to use singular nouns as table names.

  • RE: Bones of SQL - Practical Calendar Queries

    Calendar tables are extremely useful for manufacturing companies and also for accounting departments that have their own tax calendar that could be added into this Julian calendar for easy cross...

  • RE: Table Design

    It is pretty simple to see that sequential IDs are predictable.

    DECLARE @t table (nsid uniqueidentifier not NULL DEFAULT newsequentialid(), name varchar(20) NOT null)
    INSERT into @t...

  • RE: Table Design

    I forgot to mention the most important point of all, a point that I've been seeing in many systems books over and over again the past few years...

    Do...

  • RE: Table Design

    Primary keys should be non-human readable like a guid...at least in pure theory.  I love them.  Never use a natural key like an SSN because your life will become miserable;...

  • RE: Does anyone use views in this way?

    If you want to store data in a vendor's database, do it.  My recommendation would be to create your own schema in their database and put all your objects in...

  • RE: "Cannot open user default database. Login failed"

    I get the list of domain groups for a domain user by opening a cmd window and executing:
    net user /domain theirname

    Also, I generally create a Startup database...

  • RE: Column Length declaration

    Error slightly on the short side.  It is safer to loosen rather than tighten constraints in the future - and length is a constraint.  Screen and report layout widths are...

  • RE: What else can take up space in a database besides tables

    I've had problems finding where space was used and having it add up to the full amounts plenty of times.  If you are using ServiceBroker and people aren't ending their...

  • RE: Server isn't reachable

    Usually, a second instance (not the default) can be set to get a dynamic port at restart or can be forced to use a static port.  SQL Browser will "publish"...

  • RE: Curious Case of SUM Function

    Yes, my post about "significant digits to the left" should not be confused with the non-intuitive way we have to define Decimal(Precision,Scale).  Had Microsoft chosen to implement it as Decimal(Left,...

Viewing 15 posts - 1 through 15 (of 423 total)