OK, What do you know about triggers? Did you know you can use them to run a bit of T-SQL on data changes? Those would be called Data Manipulation Language (DML) Triggers. You can set those up for tables so that a certain action occurs with each INSERT, UPDATE, or DELETE. You can build as…
Month: August 2008
Reindex All Tables in a Database
I just wanted to share a quick script that I used to help re-index all the tables in my database. If you have any questions about it, please let me know! USE GO DECLARE @TableName varchar(255) DECLARE TableCursor CURSOR FOR SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = ‘base table’ OPEN TableCursor FETCH NEXT FROM TableCursor…
SQL Session – Introducing SQL Server 2008 Performance Data Collector
If you’re not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the SQL Server community in Charlotte, NC. Their plan is to get together once a month and discuss a new and interesting topic on SQL Server….
Procedural, Transact SQL — Batches
When building solutions in T-SQL, you’ll often be asked to generate a change script. This change script is a batch of SQL statements that when executed sequentially (and completely) will make a change to the database for some business reason. When you build these, you can use every tool you’ve learned about SQL, but there…
Owego NY
Penny and Mark’s family was having a family reunion, and asked if I wanted to go. I’d never been to Owego, NY before, so I thought I’d go. I got to see the town, meet their extended family and pretty much relax! I also got to go to Spiedie fest. It’s a festival that surrounds…