In this blog post we are going to learn how to fix XML Data Type related error.
SQL SERVER – Spatial Database Definition and Research Documents
Recently I was asked in meeting of SQL SERVER user group, what my opinion about spatial database. I answered from my basic knowledge. Spatial database is like database of space (not the star wars or star trek kind space). SQL Server database can understand the numeric and string values. If…
Read MoreSQL SERVER – UDF – Function to Display Current Week Date and Day – Weekly Calendar
In analytics section of our product I frequently have to display the current week dates with days. Week starts from Sunday. We display the data considering days as column and date and other values in column. If today is Friday June 8, 2007. We need script which can provides days…
Read MoreSQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL
Update: For SQL Server 2008 there is even better method of Row Construction, please read it here : SQL SERVER – 2008 – Insert Multiple Records Using One Insert Statement – Use of Row Constructor
This is very interesting question I have received from new developer. How can I insert multiple values in table using only one insert? Now this is interesting question. When there are multiple records are to be inserted in the table following is the common way using T-SQL.
SQL SERVER – 2005 Download New Updated Book On Line (BOL)
Book On Line the primary source for help for many developers has been updated. It now includes the updates till SP2 release. I use book on line for accuracy for my definition and information on this blog. Download Book On Line (Update June 4th, 2007) Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQL SERVER – 2008 (Katmai) June CTP Released – Improvement Pillars – Diagram
I received quite a few emails in last three days for not mentioning on my blog about SQL Server 2008 (Katmai) CPT June is released. The reason I did not mentioned because I was busy with my mini series SQL SERVER – Database Coding Standards and Guidelines Complete List Download.…
Read MoreSQL SERVER – Fix : Error : Error 15401: Windows NT user or group ‘username’ not found. Check the name again.
Fix : Error : Error 15401: Windows NT user or group ‘username’ not found. Check the name again. This is quite a famous error and I was asked to write about it by couple of readers. The reason I was not writing about this as the solution of this error…
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.