Eric Forkrud, Author at Eric Forkrud Blog

MS SQL Functions within the WHERE Clause, the knife in the back to SQL!

09/05/2017 by Eric Forkrud·14 Comments

While speaking with an Old School programmer, we were discussing how to do an SQL search for a date value from a Date/Time value, and I mentioned that SQL Functions within the WHERE Clause of an SQL Statement will bring the SQL Server to a screeching crawl as it scans every single record, bypassing every single index and shortcut it already knows, inserting the values into the function to see if it will satisfy the condition. The other programmer had never heard of that, so I figured, lets dig into it a bit…

Variables and Location, Location Location

09/04/2017 by Eric Forkrud·13 Comments

While taking a review class on PHP, I heard the most ridiculous thing imaginable about variables… All the variables should be declared at the top of the first PHP tag or at the top of the page… Lets dig into this and see….

GUIDs, What can they be for?

08/21/2017 by Eric Forkrud·19 Comments

In my last post, I talked about GUIDs and if they were good or bad items to use for Primary Keys, today, lets talk about when we would want to use a GUID.

MS SQL GUIDs, Curse or Benefit?

08/20/2017 by Eric Forkrud·14 Comments

What are the benefits and detriments of having a GUIDs within your database? Can you rely upon them to be truly unique? Are there any hidden “gotcha’s” associated with GUIDs? Today, lets dig into that and find out.

Functional Layouts, the best layout for functions

08/11/2017 by Eric Forkrud·15 Comments

Let’s talk about Functions again, when I am looking through code, I find it extremely frustrating that I have to roam all throughout the class or file for every couple of minutes and that there is no logical flow or position of the position of the different functions.

Functional Naming Conventions

08/09/2017 by Eric Forkrud·15 Comments

Writing a function has it’s own challenges, today lets look at one of them I like to call “Who are you” and see if we can come up with an easy way to name our functions so that they are not only memorable but also expressive and self-documenting.

Functional Layouts, the best number of functions

08/07/2017 by Eric Forkrud·22 Comments

Today, we are going to be talking about some best cases for functional layout and some ways to optimize those functions.

The Unsung Heros of Rich Text Editors II

08/06/2017 by Eric Forkrud·12 Comments

In my last post I talked about how to make a document or element editable and mentioned about Document.execCommand. Now, I am going to continue the conversation.