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
Category: Uncategorized
Online index operations are fully logged in SQL Server 2008 and later!
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
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