If you have multiple remote connections like VNC/ RDP/ SSH/ TELNET. There is a good software to manage multiple connections and save it for future use. It keeps all connections in a uniform tab-based format. Very powerful and useful tool. The best part : It is completely free and open source ! mRemote : full-featured, … Continue reading MRemote multi-tab remote connection manager
Uncategorized
Alternative to GREP in Windows
C:\Program Files\Windows Resource Kits\Tools>findstr /? Searches for strings in files. FINDSTR [/B] [/E] [/L] [/R] [/S] [/I] [/X] [/V] [/N] [/M] [/O] [/P] [/F:file] [/C:string] [/G:file] [/D:dir list] [/A:color attributes] [/OFF[LINE]] strings [[drive:][path]filename[ ...]] /B Matches pattern if at the beginning of a line. /E Matches pattern if at the end of a line. /L … Continue reading Alternative to GREP in Windows
SQL SERVER – Query to find number Rows, Columns, ByteSize for each table in the current database – Find Biggest Table in Database (via Journey to SQLAuthority)
USE DatabaseName GO CREATE TABLE #temp ( table_name sysname , row_count INT, reserved_size VARCHAR(50), data_size VARCHAR(50), index_size VARCHAR(50), unused_size VARCHAR(50)) SET NOCOUNT ON INSERT #temp EXEC sp_msforeachtable 'sp_spaceused ''?''' SELECT a.table_name, a.row_count, COUNT(*) AS col_count, a.data_size FROM #temp a INNER JOIN information_schema.columns b ON a.table_name collate database_default = b.table_name collate database_default … Read Morevia Journey to SQLAuthority
SQL Server for Oracle Professionals.
Download : SQLServer2008forOracleDba.docx
Restore SQL Server 2005 to a new server.
Download : Restore SQl Server 2005.docx
Create new table from old table and rebuild its indexes
osql -U sa password: ***** 1. Insert into already created table. use <name-of-database> insert into EQcust (*) select * from EQCUSTTemp; go 2. Insert into a new table ( replicate a table) use <name-of-database> SELECT * INTO EQtest FROM EQCUSTTemp 3. Rebuild index online use <name-of-database> ALTER INDEX ALL ON EQCUSTTemp REBUILD WITH(ONLINE = ON)
SimpleSQLDBA | Shadab Mohammad 