Cycle Error Logs
sp_cycle_errorlog
Force a database out of "Restoring..." Mode
RESTORE DATABASE WITH RECOVERY
Find duplicated column data
select
convert(varchar(20), a.[samaccountname]) as [user],
convert(varchar(20), a.[domainname]) as [domain],
from BTS_ActiveDirectoryReporting.dbo.Users as a
where a.[samaccountname] in
(select z.[samaccountname]
from BTS_ActiveDirectoryReporting.dbo.Users as z
group by z.[samaccountname]
having count(*) > 1)
Search for a column in a specific table
select COLUMN_NAME
from information_schema.columns
where TABLE_NAME='risk_map_extract' and
COLUMN_NAME like '%wc%'
Search for a specific table
select TABLE_NAME
from information_schema.tables
where table_name like '%company%'
Get SQL Server version information
Select @@version
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Update a column in one table with values from another table
update risk_map_extract
set risk_map_extract.t_rsk_adr=Corrections.[Corrected Address]
from Corrections
where risk_map_extract.t_rsk_adr=Corrections.t_rsk_adr