In this blog post we will see 5 SQL Server Best Practices.
Backup Master. I am going to have a backup of the database using script; however, the backup script has not been updated for a long time now.
SQL SERVER – Check Advanced Server Configuration
I was recently asked following question about how to Check Advanced Server Configuration.
SQLAuthority News – 2 Sessions at TechInsight 2010 – June 29 – July 1, 2010
Earlier this month, I got the opportunity to visit Malaysia for community sessions on June 29 – July 1, 2010 at Kuala Lumpur, Malaysia, which I would consider as valuable experience. I presented two different sessions at the event. The event was extremely popular in local community, and I had…
Read More
SQL SERVER – Computed Column – PERSISTED and Storage
This is the list of the all the articles in the series of computed column.
SQL SERVER – FIX: ERROR: 8170 Insufficient result space to convert uniqueidentifier value to char
I just came across very simple error and the solution was even simpler. While concatenating NEWID to another varchar string, I had to CONVERT/CAST it to VARCHAR and I accidentally put length of VARCHAR to 10 instead of 36. It displayed following error.
Msg 8170, Level 16, State 2, Line 1
Insufficient result space to convert uniqueidentifier value to char.
SQLAuthority News – Last 2 Day to Win MSDN Subscription – Total 2 to Win
Today is the last day to win MSDN subscription on this blog. SQL Server MVP Madhivanan is known name. As there are more than 150 comments, I had requested him to help me out with deciding the winner. After looking at the quality responses, he has for sure accepted to…
Read MoreSQLAuthority News – The story of the world – Spatial Data types – July 24, 2010
Today I will be speaking on the subject of Spatial Database at Community Tech Days at Ahmedabad. The event is absolutely FREE. We have so far received 500+ RSVP but there are only limited 250 seats are available. We are doing our best to inform everybody about their registration status. If you have received confirmation email, I suggest that you come in early enough to reserve the place.
SQL SERVER – Find Queries using Parallelism from Cached Plan
I recently came across wonderful blog post of Feodor Georgiev. He is one fine developer and like to dwell in the subject of performance tuning and query optimizations. He is one real genius and original blogger. Recently I came across his wonderful script, which I was in fact writing myself…
Read More
SQLAuthority News – Funny Technology Quotes – Humor
I am including a few of the interesting quotes today. Let us see Funny Technology Quotes. Here are few interesting new lessons.
SQLAuthority News – SolidQ Journal Released – A Must Read for All
SQL Server is one of the most popular products of Microsoft and a large amount of quality content is available online. Solid Quality Mentors have together built a superior quality journal, which contains the best of the best authentic articles from renowned experts of SQL Server. When I downloaded SolidQ…
Read More