In this article we will examine what the SQL Server Transaction Log is, why do we need one and how it works.
SQL Authority News – Save USD 600 for SQL Live! 360 in November
I love talking about performance tuning and I love teaching about performance tuning. I think this is one subject, which everyone would like to discuss about, as this subject never gets old. I stay in India so I often deliver conference sessions on this subject over here. However, if you are in the USA, this is your opportunity to join me to discuss about SQL Server Performance. I’ll be speaking at Live! 360, November 17 – 21 in Orlando, FL. Live! 360 brings together five conferences, and the brightest minds in IT and Dev, to explore leading edge technologies and conquer current ones. More info:
SQL SERVER – What is the Difference Between An INNER JOIN and WHERE Clause
Just received a question in email: “What is the Difference Between An INNER JOIN and WHERE Clause?” Well, the answer can be quite long but I will try to answer in few words and a very simple one. If you are talking about resultset – there will be not much…
Read MoreSQL SERVER – SQL Server 2008 Service Pack 4 – Download
It has been a long time since SQL Server 2008 got Service Pack Update. Microsoft has finally released SQL Server 2008 service pack 4 and its feature pack. SQL Server 2008 SP4 contains fixes to issues reported as well as Hotfix solutions have provided since SQL Server 2008 Service Pack…
Read MoreSQL SERVER – Add Auto Incremental Identity Column to Table After Creating Table
Question: Is it possible to add an auto incremental identity column to any table in SQL Server after creating a table. Answer: There are two answers – No and Yes. Let us see them one by one. Answer No – If you have an integer column in your table and…
Read MoreSQL SERVER – Row Offset in SQL Server For Different Version
A very common question is how to find row offset in SQL Server. Here are a few examples based on different version of SQL Server. I have included SQL Server 2000 event, though it is almost 15 years old product and I encounter is less and less every day on…
Read MoreSQL SERVER – ​Tuning Queries is Sometimes Waste of Time – Notes from the Field #049
[Note from Pinal]: This is a 49th episode of Notes from the Field series. Every day I get few emails where I am asked how to tune queries so the entire server run faster. I always end up writing long answer this question. The reason is simple – query tuning…
Read More![MYSQL - Could not Drop Object [Content] ('Cannot delete or update a parent row: a foreign key constraint fails', 1217) DROP DATABASE DatabaseName spotlight2-4-619x262](https://blog.sqlauthority.com/wp-content/uploads/2014/01/spotlight2-4-619x262.jpg "MYSQL - Could not Drop Object [Content] ('Cannot delete or update a parent row: a foreign key constraint fails', 1217) DROP DATABASE DatabaseName spotlight2-4-619x262")
![MYSQL - Could not Drop Object [Content] ('Cannot delete or update a parent row: a foreign key constraint fails', 1217) DROP DATABASE DatabaseName bandandlogo-800x303](https://blog.sqlauthority.com/wp-content/uploads/2014/01/bandandlogo-800x303.jpg "MYSQL - Could not Drop Object [Content] ('Cannot delete or update a parent row: a foreign key constraint fails', 1217) DROP DATABASE DatabaseName bandandlogo-800x303")
![MYSQL - Could not Drop Object [Content] ('Cannot delete or update a parent row: a foreign key constraint fails', 1217) DROP DATABASE DatabaseName apex5-1-619x500](https://blog.sqlauthority.com/wp-content/uploads/2014/01/apex5-1-619x500.jpg "MYSQL - Could not Drop Object [Content] ('Cannot delete or update a parent row: a foreign key constraint fails', 1217) DROP DATABASE DatabaseName apex5-1-619x500")
![MYSQL - Could not Drop Object [Content] ('Cannot delete or update a parent row: a foreign key constraint fails', 1217) DROP DATABASE DatabaseName virtualsql-619x245](https://blog.sqlauthority.com/wp-content/uploads/2014/01/virtualsql-619x245.jpg "MYSQL - Could not Drop Object [Content] ('Cannot delete or update a parent row: a foreign key constraint fails', 1217) DROP DATABASE DatabaseName virtualsql-619x245")
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.