• Home
  • Consulting
    • About Andrew
    • Consulting Projects
    • SQL Performance Review
  • Developer Resources
    • SQL Performance Tips
    • SQL Storage Management
    • SQL Coding Examples
    • SQL Security
    • Problems Solved
    • Downloads
    • User Groups
    • Hardware Links
  • Presentations
    • Presentations
    • Talks and Seminars
    • Webinars
    • Videos
  • Contact
 

Entity-Attribute-Value (EAV): The Antipattern to Great to Give Up

by andrew novick | Sep 19, 2016 | Past Events, Presentations, SQL coding, Uncategorized

Download the presentation: entity-attribute-value-eav-the-antipattern-too-great-to-give-up-andy-novick The Entity-Attribute-Value (EAV) is a design pattern for relational databases that uses an extreme form of normalization to achieve flexibility and the ability to...

SQL Server In-Memory Tables

by andrew novick | Apr 21, 2015 | Past Events, Presentations, SQL Performance, Uncategorized

SQL Server In-Memory Tables(Hekaton) Andy Novick April 2015 SQL Server 2014 aimed to improve OLTP performance by adding In-Memory tables and native compilation of the stored procedures that use them.  In-Memory tables bring incredible speed for the right workload so...

SQL Coding Tip – stored procedures

by nsadmin | Jul 6, 2014 | Uncategorized

This is a great tip.

The Problem with User-Defined Functions (UDF) and a Solution

by andrew novick | May 22, 2014 | Problems Solved, SQL coding, Uncategorized, Videos

Download the sample script: Problem-Scalar-UDF-and-solution-andy-novick   and a PDF of the slides: The Problem with scalar UDFs and a solution – Andy Novick Or watch the video on Youtube:   User-Defined functions (UDF) have been around SQL Server since the...
“Software performance was our single biggest problem. We did everything we could do in-house to get the database running like it should and really needed some help. You quickly pinpointed problem areas and your setup, index and query recommendations greatly improved the software’s performance.”
Daniel J. Mc Intyre, Vice President
Management Computer Services, Inc.

Upcoming Events

> See All Events

Latest SQL Tips:

Loading SQL Profiler trace (.trc) files into a table

Server traces can produce a large amount of trace data that is stored in multiple trace (.trc) files.

read more

Problem Solved:

Level 16 Errors Can’t always be handled by User Code

Although books-OnLine says that user code can handle errors with Level 16 and below, they sometimes end the connection.

read more
  • Home
  • About Andrew
  • Consulting
  • Developer Resources
  • Contact

ANDREW NOVICK | [email protected] | (978) 440-8126

Copyright © 2022 Novick Software