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...

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...

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...

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...

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

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...

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...

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...

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;...

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...

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...

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...

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...

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"...

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,...