Can you restore database using corrupt datafiles when there is no full backup and both .mdf and .ldf are damaged? My honest answer and the one thing to try.
SQL SERVER – 15 Best Practices for Better Database Performance
Best practices for better Database Performance: keep only needed data, normalize tables, use lookup tables and small primary keys. I list 14; you suggest the 15th.
SQL SERVER – 2005 – Transferring Ownership of a Schema to a User
Transferring ownership of a schema to another user in SQL Server 2005 takes one ALTER AUTHORIZATION ON SCHEMA statement. A reader asked, so here it is.
SQL Server – Good Articles on Database Collation
Database Collation defines default character comparison rules for a database. I also inspect the columns and expressions involved.
A Self-Review Checklist for Stored Procedure Changes
Use a self-review checklist for stored procedure changes: realistic data, plans, IO, NULL inputs, clean rollback, and a ready recovery script.
SQL SERVER – Find Nth Highest Salary of Employee – Query to Retrieve the Nth Maximum value
How do you find the Nth Highest Salary of an employee? I link my earlier answers and share reader Pravin Phatangare’s simple TOP query for the 6th highest salary.
What to Alert On, and What to Let Sleep
Make SQL Server alerting actionable by tying thresholds to impact, checking missing work, reducing duplicates, and reviewing every overnight call.
DATEPART tzoffset: Read the Signed Offset in Minutes
DATEPART tzoffset extracts an offset in minutes. Preserve its sign, test sub-hour values and retain the source temporal type.
SQL SERVER – Introduction to Heap Structure – What is Heap?
What is Heap? When table data has no logical order and no clustered index, SQL Server stores it as a Heap Structure. I explain pages and extents too.
SQL SERVER – 2005 – List All Column With Identity Key In Specific Database
Question I received in Email : How to list all the columns in the database which are used as identity key in my database?