Compare 2 sql tables

A simple SQL compare is realy easy: select * from dbtest02.dbo.article except select * from dbtest01.dbo.article Source: https://www.mssqltips.com/sqlservertip/2779/ways-to-compare-and-find-differences-for-sql-server-tables-and-data/

May 15, 2018 · 1 min · thomasf
viewer

How to truncate Mirrored Database Log File

First backup your transaction logging: Tasks > Backup Select transactionlog backup en select a disk where to backup Now check the status with DBCC LOGINFO(DATABASENAME) Check if the last status record is 0 (zero) When the status is 2 make another backup When the status is 0 you can run: DBCC SHRINKFILE(2) You can use this script also: Backup LOG DBNAME TO DISK = 'C:\SQL_TMP\transactionlog.trn' WITH STATS GO DBCC LOGINFO(DBNAME) DBCC SHRINKFILE(2)

September 28, 2017 · 1 min · thomasf
overheating_computer

Windows IOPS and MB/s benchmarking

You have bought een new system and the first thing what you want to do is check the disk performance (ehhh that’s always the first thing I want to know :P ) There is one tool I always use: ATTO Disk Benchmark This is a very nice tool to quickly see how fast your troughput is of your new system. But sometimes you want to check your IOPS. Then you can use another nice microsoft commandline benchmark tool DiskSpd ...

September 11, 2016 · 2 min · thomasf

Remote connect SQL Express

Start SQL Server Surface Area Configuration > Remote connections Select “using both TCP/IP and named pipes” Start “SQL Server Configuration Manager” Find out the dynamic port Now connect to the SQL server from a remote server: HOSTNAMESERVER\MSSQL$SQLEXP_VIM,49382

August 12, 2013 · 1 min · thomasf

Error 29528 When Installing SQL Service Pack 4

Today I had this problem for the second time. Last time it cost me 3 hours to find the solution. Now I find your article and I fixed it in 30 minutes :) My Exact error was (summary.txt): MSP Error: 29528 The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation. The workaround resolution involves the following steps: ...

August 1, 2012 · 1 min · thomasf

SQL Reporting Services slow with Internet Explorer

When you access the reporting services over SSL you can have the problem that the reporting services GUI under IE is very slow. The solution is quite simple: Login with the servername or domain name. E.g: SERVERNAME\username This problem exist under IE 8 and IE9 under Server 2008, 2008r2, Vista and Windows 7.

April 11, 2012 · 1 min · thomasf

How to identify your SQL Server version and edition

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

April 22, 2011 · 1 min · thomasf

Check SQL Log space use

DBCC SQLPERF(LOGSPACE); GO

October 19, 2010 · 1 min · thomasf

mysql restore (under Windows)

Hi, If you want to use mysqldump to back up the database, you can enter the full path when typing the command, or add the path c:\wamp\bin\mysql\mysql5.0.51b\bin to the System variable PATH in Control Panel - System - Advanced - Environment Variables - System variables. You can make a backup from the command line or a scheduled task in Windows like this, assuming that myusername and mypassword have access to the database mydatabase: ...

January 14, 2009 · 1 min · thomasf

How to shrink a SQL Transaction Log

For 2005: --\* you can get the logical log file name usingthe following command in Query Analizer: exec "databaseName".dbo.sp_helpfile Now execute the following command to shrink the database log to 200MB: DBCC SHRINKFILE ("logicalLogFileName", 200) BACKUP LOG "databaseName" WITH TRUNCATE_ONLY DBCC SHRINKFILE ("logicalLogFileName", 200) –if it doesn’t work, run the two commands again. –When done with that, do a full backup of your db as you will have broken your tlog backup chain. For 2008+ ...

February 20, 2008 · 1 min · thomasf