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
Category: Uncategorized
Is truncate logged or non-logged in SQL Server?
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?
Fix orphaned users in SQL Server 2005 – not
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
DTS package runs from command line, but fails from SQL Server Agent
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
How can I tell if my restore process is actually doing something
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
Is the primary key always clustered in SQL Server?
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?
How to Disable NetBIOS on the SQL Server Box
Today I'll post a quick one, since a simple Google search (yeah, Bing, sorry) did not yield too many useful results. Just as a quick note, make sure you have a chat with your sys admins; they can tell you whether the protocols are needed or not anymore. Okay, on with the tip: Go to … Continue reading How to Disable NetBIOS on the SQL Server Box
To 32 or not to 32 on Windows 7
Finally I got 8 GB of RAM on my laptop. That's a great thing, especially that I have free licenses to pretty much whatever Microsoft has as x64, except that I'm married and this is not quite my laptop, but my wife's. If you ask anyone on the planet, you are to find out that … Continue reading To 32 or not to 32 on Windows 7
SQL Server installation tips… NOT
I have to admit that I shamelessly "steal" any info available on the net when it comes to SQL Server. Just to give you a quick example: Brent Ozar and Jonathan Kehayas both have some neat articles about installing SQL Server. Of course, I use the Next > Next > Finish feature, just as anybody … Continue reading SQL Server installation tips… NOT
Strange error in SQL Server 2005… when aplying SP3
Before going any further, let's get this straight: I'm not sure whether it's a bug or not, whether can be reproduced or not, but I care to have this documented.A machine was re-installed (Win 2003, SQL 2005), having 3 named instances (no default, just named instances). SP3 was applied... and nothing was like before:-). You … Continue reading Strange error in SQL Server 2005… when aplying SP3