Daily Archives: March 20, 2013

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

Posted in Tools and Tricks, Unix | Tagged | 1 Comment

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

Posted in SQL, Tools and Tricks | Tagged | Leave a comment

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

Posted in SQL, Tools and Tricks | Tagged | Leave a comment

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

Posted in SQL, Tools and Tricks | Tagged | Leave a comment

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

Posted in SQL, Tools and Tricks | Tagged | Leave a comment