January 2021 M T W T F S S 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Tags
-
Recent Posts
Categories
Category Archives: Tools and Tricks
Unix – beginnings
Today, we covered in class – basic commands for unix. Log into the system, run id and pwd to discover location and who you are connected as. users need to belong to at least one group id -a id -a … Continue reading
Check existing databases then create
— CHECK existing databases for existence. if exists (select * from master..sysdatabases where name = ‘dbName’ ) drop database dbName GO create database dbName on primary (name = ‘dbName’, filename = ‘C:\data\dbName.mdf’), log on (name = ‘dbNameLOG’, filename = ‘C:\data\dbName.ldf’) … Continue reading
Objects Query
/* Select ALL table names and column names from a given table. */ select o.name as [TableName], c.name as [ColumnName] from sys.objects o inner join sys.columns c ON o.object_id = c.object_id where 0=0 and type = ‘U’ — and c.name … Continue reading
Data and log file iteration
——————————————————————– — This will generate a list of databases to iterate through and pull — data and log file locations, plus size, etc. — There are 2 parts. 1 generates the list and 2 creates the output. ——————————————————————– /* PART … Continue reading
Check Space
—————————————————- — WORK IN PROGRESS — xp_fixeddrives joined with sys.masterfiles view — Looking at space, judging db size, growth and — free space on the server. — use sp_helpfile for SQL 2000 —————————————————- set nocount on declare @fixeddrives table — … Continue reading
Checking Active Partition – Windows 7
Recently, I messed up the installation on my son’s machine. I removed the first partition and did not adjust the boot loader. This left Windows 7 (2nd partition) unbootable. I spent some time running through tests and trying to figure … Continue reading
Windows 7 Startup Repair Disc
The bad news is that this is not readily available in most cases, as the operating system is pre-installed, and (in most cases) the operating system disc is not included when you purchase a desktop/PC. What this means is that … Continue reading