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…
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….
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.
Today, we are going to be talking about some best cases for functional layout and some ways to optimize those functions.