High insert rates depend on key choice, row width, index count, and retention design; learn a practical SQL Server table layout for sustained writes.
SQL SERVER – Difference Between UPDATE and UPDATE() in Triggers
UPDATE changes rows in a table or view, while UPDATE() in triggers tells you if a column was part of an INSERT or UPDATE. Here is the difference.
Querying Active Directory From SQL Server
Querying active directory through an ADSI linked server can answer narrow questions, but its limits favor staged data for repeatable work.
SQL SERVER – 2005 – List All The Constraint of Database – Find Primary Key and Foreign Key Constraint in Database
A simple script from my archive lists all constraints from sys.objects, so you can check each foreign key and primary key constraint in database tables.
Writing T-SQL Somebody Else Can Maintain
Write maintainable T-SQL with clear names, explicit results, focused procedures, and comments that explain the business reason behind the code.
Grouping Dates Into Buckets With DATE_BUCKET
DATE_BUCKET groups timestamps into hourly, weekly, and custom intervals, with an origin that determines where every boundary lands.
SQL SERVER – Difference Between EXEC and EXECUTE vs EXEC() – Use EXEC/EXECUTE for SP always
What is the difference between EXEC and EXECUTE? None. The real difference is EXEC vs EXEC(), and I show why EXEC belongs before every stored procedure call.
SQLAuthority News – Scrum: Agile Software Development for Project Management
What I learned as a project manager about Scrum, an Agile Software Development system: the Product Owner, ScrumMaster and Team roles, and how the process runs.
SQL SERVER – Frequency of SQL Server Reboot and Restart
How often should you do a SQL Server reboot? From my experience there is no need, though our network team reboots all our servers every 15 days.
SQLAuthority News – Book Review – SQL Server 2005 DBA Street Smarts: A Real World Guide to SQL Server 2005 Certification Skills
My review of SQL Server 2005 DBA Street Smarts by Joseph L. Jorden, built on exam 70-431 and useful as a reference for the daily tasks of a DBA.