Category: Uncategorized

Another quick one for today: When you encounter such an error (see the title and the print screen below), you might want to check this first: http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/b0665753-6bb6-48bb-a938-febc6e942d58 For the really lazy ones: it's a clear sign of memory pressure. I hope this helps. Best regards,io

Hopefully this will help someone out there. There is a command, BACKUP DATBASE <db_name> TO DISK = N'NUL' and apparently people either don't know that is there, or are using it for all the wrong purposes. We use this particular command to find out our "golden point", so to speak, which means that we can … Continue reading BACKUP DATABASE TO DISK = N‘NUL’ – and misconceptions →

We currently do have a process in place that takes a full backup, creates some zip files, sends the over to another server, and whatever else is left. Obviously, it is prone to errors. Therefore I was more than interested to see this tool in action (as recommended by Pinal Dave). Also, I will not … Continue reading Tool review – SQL Backup and FTP →

The title is self-explanatory, but I had no idea until I recently saw my transaction log size skyrocketing; and here's the article: http://support.microsoft.com/kb/2407439 best regards, io  

Okay, second blog post in one day – slowly trying to recoverJ. Below is an excerpt from a stored procedure from BizTalk server: --If you are doing this we assume it is because you have a huge, old db so it is just faster for us to     --find things which are not done and hold … Continue reading Is truncate logged or non-logged in SQL Server? →

A quick one, again (haven't been blogging for a while, I have like a ton of blogs on my mind, lack the time, though): I think most of the DBAs have stumbled upon "how to fix orphaned users in SQL Server", right? Well, a quick overview of the script: SET NOCOUNT ON SET QUOTED_IDENTIFIER OFF … Continue reading Fix orphaned users in SQL Server 2005 – not →

Yet another quick one for you. One of my colleagues was trying to set up a job to run a DTS package (yeap, I know, a bit of a last century stuff). Whenever he ran the package from the command line, everything was running fine. However, when he ran the same package from within a … Continue reading DTS package runs from command line, but fails from SQL Server Agent →

Just stumbled into this: if you have a large DB to be restored, it might take forever to actually see the progress moving to 10%, 20%, and so on. Yeah, I know, you should never do a restore from the SSMS, but don't try to tell me thatJ. Anyway, coming back to our scenario: if … Continue reading How can I tell if my restore process is actually doing something →

As I was playing in SSMS (SQL Server Management Studio), I created a table using the plain-old T-SQL, and then I decided to create a primary key, the "wizard" way, so to speak. Let's have a repro here: CREATE TABLE [dbo].[Employees] ( [empID] [int] NOT NULL , [firstname] [varchar](30) NOT NULL , [lastname] [varchar](30) NOT … Continue reading Is the primary key always clustered in SQL Server? →