A sample T-SQL for determining uptime of a Microsoft SQL Server.
This content is 6 years old.I was working with a mail archive MySQL database today and was twiddling my thumbs waiting for simple queries to complete. The database has about 12 million rows and is on a 2x2GHz 2GB Linux Server x64. I wanted to try to optimize the database and found this little gem … Read moreMySQL Check For Fragmentation
This content is 7 years old.A quick method to find all the data and log file paths for all databases on a database server instance. SELECT name, physical_name AS current_file_location FROM sys.master_files Example Output: name current_file_location master C:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLDATAmaster.mdf mastlog C:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLDATAmastlog.ldf tempdev E:MSSQLData empDB.MDF templog C:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLDATA emplog.LDF … Read moreFind Current Location of Data and Log Files for SQL Server
This content is 8 years old.So I have an Informix Dynamic Server (7) and I want to setup a Microsoft Windows ODBC system profile and then connect to it using VBScript. I will go the easy route and install IConnect 2.90 Informix Driver for Windows. After installing the driver, I will configure the ODBC connection: … Read moreVBScript Informix DSN Test Script
This content is 10 years old.I’m sure you’ve seen results similar to this on a standard query: Now, if you use the \G option (Send command to mysql server, display result vertically.): That makes reading the output from command line really nice. One more tidbit that I’ve found I like to do is use the … Read moreMySQL CLI Output Formatting Tips