(Pinal Dave) Recently one of my blog reader contacted me via mail and told that after upgrading from Enterprise Evaluation Edition to Standard Edition, the database was not accessible. To troubleshoot, I have asked them to share SQL Server ERRORLOG.

(Prashanth Jayaram) There are many different ways to accomplish this tasks.

(Kris Wenzel) This is the fourth in a series of articles about subqueries. In this article we discuss subqueries in the FROM clause. Other articles discuss their uses in other clauses.

(Daniel Farina) You have a SSIS package that includes one or more Script Tasks that take a considerable amount of time to finish. In this tip I will show you how to get progress information so you can monitor the SQL Server Integration Services Package execution for Script Tasks.

(Thomas LaRock) When you create a database in SQL Server and do not specify a file location for your data and log files SQL Server will rely on the default database file locations as defined in the server properties.

(dbafromthecold) There are a number of ways that you can identify blocking that is occurring in your SQL instance. You can run the undocumented sp_who2 stored procedure but that will only give you the session that is being blocked.

(Kenneth Fisher) Feb 16, 2015 Dear Diary, A few weeks back I introduced HAL002 to a database managed by some annoying devs. They were not just putting NOLOCK on almost every query but they had SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED at the beginning of the stored procedures.

(Pinal Dave) In the past couple of weeks, I have written few blogs that revolve around utilizing “readonly” databases. It was fun working on this special case scenario that I had stumbled upon an interesting set of questions from my blog readers.

(Tim Smith) We discovered that one of our SQL Server import processes (or loading process) hadn’t been importing data for over a month. After looking at it, the vendor changed the schedule without notifying us, so since the new data weren’t detected, the process was executing without sending a notif

(Pinal Dave) If you are a DBA, once in a while, you will have a situation where you end up with some tasks which will be boring and annoying. Trust me in my life, I often come across similar scenarios quite often. Here is one such tasks I came across a few days ago.