I often install SQL Server Management Studio (SSMS) for a range of users – testers, developers etc. – who do not need to use a local database on their workstation. To reduce my own workload, I’ve generated a command-line script to install the required components. Using the resources at the MSDN site http://msdn.microsoft.com/en-us/library/ms144259.aspx it … Continue reading
these are the most common Solaris commande that I use: df –h (df = Disk Free) to show details of the disk space. I use this command to monitor disk space. The –h option returns output in human readable format. prtdiag Gives a summary of the processor version, CPUs etc. Useful when dealing with ORACLE … Continue reading
Running the extended stored procedure xp_fileexist returned a negative result enen though the file existed on disk. exec master..xp_fileexist ‘C:\SQLBackup\msdb.bak’ returns: File Exists File is a Directory Parent Directory Exists ———– ——————- ———————– 0 0 1 (1 row(s) affected) To fix 1 – confirm that the file name in the xp is valid … Continue reading
The SQL Server log is one of the major components of the database. This post explores what happens in the log during normal (and abnormal) operation. The tool that I use to explore the log is DBCC Loginfo. This is a tool to display information about the virtual log files (VLFs) within the physical log … Continue reading
This post describes how to configure the Distributed Transaction coordinator to allow distributed transactions. The issue arose developing an SSIS package. The SSIS package consisted of two Execute SQL tasks within the same container. Each task updates a different SQL Server. (fig 1 below). fig 1 – SSIS package Initially, when the container Transaction option … Continue reading