SQL Server has introduced a functionality to pass a table data form into stored procedures and functions. This feature greatly simplifies the process of developing. The reason being, we need not worry about forming and parsing XML data. With the help of the table Input parameter to Stored Procedure we can save many round trips. Any SQL training will vouch for the fact that SQL is capable of accepting large, complex data in the form of parameters in a stored procedure.
SQL SERVER – Autocomplete and Code Formatting Tool – SQL in Sixty Seconds #041 – Video
I love to write code, and I love well-written code. When I am working with clients, and I find people whose code have not been written properly, I feel a little uncomfortable. It is difficult to deal with code that is in the wrong case, with no line breaks, no white spaces, improper indents, and no text wrapping. The worst thing to encounter is code that goes all the way to the right side, and you have to scroll a million times because there are no breaks or indents. Let us see blog post about Code Formatting Tool.
SQL SERVER – Contest to Win Amazon Card – Experience Cloud Data Management System (CDMS) and NuoDB
The world of database is changing. The traditional client server installation on premises still has a place in many organizations but many of these organizations are facing challenges with this setup setup as their data is growing exponentially every day. Well, as time changes the innovation is required. If you…
Read MoreSQL SERVER – Basic Explanation of SET LOCK_TIMEOUT – How to Not Wait on Locked Query
In earlier blog post SQL SERVER – Basic Explanation of Query Hint NOWAIT – How to Not Wait on Locked Query, we learned how we can use NOWAIT query hint to not wait on any locked query and return error. The Query Hint works on query and table level. There is…
Read MoreSQLAuthority News – Developing Multi-tenant Applications for the Cloud, 3rd Edition – Book Download
Cloud is changing the way how IT world is evolving. Honestly, just like every product and service, there are always the best practices to follow for optimal outcome. Let us learn about Developing Multi-tenant Applications for the Cloud.
SQL SERVER – Weekly Series – Memory Lane – #013
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 – Basic Explanation of Query Hint NOWAIT – How to Not Wait on Locked Query
Everybody knows about NOLOCK Â but not everyone knows about NOWAIT. They are different and they have an entire different purpose. In this blog post we will not talk about NOLOCK but we will see how NOWAIT will work. The idea of writing about blog post is based on the question…
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.