by pinaldave
Avoid Using Keywords as an Object
by pinaldave
First of all Merry Christmas and Happy Holidays to everybody. I wish you best holiday season. In today’s blog post – I am sharing very small question received by one of the reader. Though simple sometime a small question make people think. He sent me very similar to following image and a
by Rob Kraft
Use a SQL script to generate well formatted stored procedures in SQL Server
by pinaldave
Some kinds of confusion never go away. Here is one of the ancient confusing things in SQL. The precision of the SmallDateTime is one concept that confuses a lot of people, proven by the many messages I receive everyday relating to this subject. Let me start with the question: What is the precision o
by Rohitmssqlfun
How to save deadlock graph events as .xdl file ? On the File menu, click New Trace, and then connect to an instance of SQL Server. In the Trace Properties dialog box, type a name for the trace in the Trace name box. In the Use the template list, select a trace template on which [...]
by aasim abdullah
It’s a common practice by database developers to use local variables in stored procedures and scripts to place filter on basis of these local variables. YES, these local variables can slowdown your queries. Let’s prove it. Create a new table and insert dummy rows. USEAdventureWorksGO CREATE TA
by pinaldave
How to find column used in a stored procedure.
by pinaldave
Some kinds of confusion never go away. Here is one of the ancient confusing things in SQL. The precision of the SmallDateTime is one concept that confuses a lot of people, proven by the many messages I receive everyday relating to this subject. Let me start with the question: What is the precision o
Submit an article or tip
Post your Blog