Storing percentages starts with a declared unit. Fractional rates and percentage points require different conversions, even when both pass a range check. Use named columns, explicit boundaries and a guarded disposable fixture.
SQL SERVER – Attach mdf file without ldf file in Database
A friend sent me only his mdf file instead of a backup of the database. Here is how to attach mdf file without ldf file and let SQL Server build a new log.
Installing SQL Server Silently From the Command Line
Installing SQL Server silently takes a reviewed ConfigurationFile.ini, required setup switches, and a check of logs and active instance settings.
SQL SERVER – T-SQL Script to Take Database Offline – Take Database Online
A reader asked how to bring a database back online. This short T-SQL script will take database offline with ROLLBACK IMMEDIATE and then online again.
SQL SERVER – Create Primary Key with Specific Name when Creating Table
How do you create a primary key with specific name while creating the table itself? One CREATE TABLE statement can define and name the constraint.
SQL SERVER – Find Max Worker Count using DMV – 32 Bit and 64 Bit
Does doubling the CPUs double the worker threads? No. Use sys.dm_os_sys_info to find Max Worker Count, and see the formula for 32 bit and 64 bit.
SQL SERVER – Find Most Active Database in SQL Server – DMV dm_io_virtual_file_stats
Reader Sreedhar shared a query on sys.dm_io_virtual_file_stats that finds the most active database by reads, writes and IO stalls, with file sizes.