• 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
 

In-Memory Tables with Natively Compiled T-SQL: Blazing Speed for OLTP and More

by andrew novick | Dec 1, 2016 | SQL coding, SQL Performance, Talks and Seminars

in-memory-tables-with-natively-compiled-t-sql-blazing-speed-for-oltp-and-more The SQL Server 2014 and 2016 Hekaton project brings us In-Memory tables and Natively Compiled T-SQL objects that run at amazing speed.  What you can accomplish is astounding. This...

Natively Compiled T-SQL: The Fastest SQL Ever!

by andrew novick | Sep 18, 2016 | SQL coding, SQL Performance, Talks and Seminars

Download the Presentation .Natively-Compiled-T-SQL-Andrew-Novck-presentation Demo files: Natively-Compiled-T-SQL-Andrew-Novck-demo-sql SQL Server’s In-Memory tables are accompanied by Natively Compiled Stored Procedures and Functions that run at amazing speed. ...

Writing Faster T-SQL Stored Procedures and Functions: Lessons Learned

by nsadmin | Apr 28, 2015 | Past Events, SQL coding, Talks and Seminars

PDF From Seacoast SQL 2015-04-27 Improving SQL Server Performance by Writing Faster T-SQL Code SeaCoast SQL UG 2015-04-27 Download file with Examples: Writing-Faster-T-SQL-Andy_Novick-Examples-2015-04-27 Recorded Webinar September 2014: Video Stored procedures and...

Video – Improving SQL Server Performance by writing faster T-SQL Code- Sept 11, 2014

by andrew novick | Aug 31, 2014 | Past Events, Presentations, SQL Performance, Talks and Seminars, Videos, Webinars

This webinar is now available for viewing online at any time. (About 60 Minutes) http://www.mssqltips.com/sql-server-video/332/proving-sql-server-performance-by-writing-faster-tsql-code/ Some of the concepts we will cover include: Ways to find code that’s slow:...
“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.

Developer Resources

UDF (1) SQL Profiler (1) Natively Compiled (1) Hekaton (1) performance (3) in-Memory (3) etl (1) SQL Server (4) Partitioning (1) storage (1) error codes (1)

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