Old classic movies utter this famous phrase “Gentlemen, this is off the record”. In movies this is used when talking to the press and letting them know a certain comment or two will be said, however it is not meant for publication in the media. Sometimes, we want to use words or phrases within a query window that we want SQL Server to ignore when executing the code. Fortunately, SQL Server allows us to write words or phrases that are “off the record”, with a coding technique called a commenting. Let us understand why we code comments.
SQL SERVER – Cumulative Update Released in February 2013 for SQL Server Editions
I keep eyes on cumulative updates. I keep a watch that which one released and what they are impacting. If you are facing issues with SQL Server – Comulative Updates may have a solution for you. I suggest to install CU on Development Server first and later roll out the…
Read MoreSQL SERVER – Weekly Series – Memory Lane – #017
Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…
Read MoreSQL SERVER – T-SQL Script to Keep CPU Busy
Never run this on your production server – you can just lose your job and can damage your organization. Now I am done with the disclaimer here is the subject I would like to discuss. How to keep your CPU busy? Well, actually there should not be any need of…
Read MoreSQL SERVER – Shortcut to SELECT only 1 Row from Table
If you watch any SQL Server Developer, you will notice one particular task them doing every day frequently. It is they select the row from the table to see what are the various kinds of data it contains. Most of the tables are very big so it is always advisable…
Read MoreSQLAuthority News – Introduction to ColdFusion – Video Tutorial on Pluralsight
I recently released a Introduction to ColdFusion video course on Pluralsight. The course is very well received and I have received a quite a lot of good feedback about it. However, one of the questions keeps on showing up in my email box is that users had no idea that…
Read More
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.