11/1/2011 : Lyncin Log
Lyncin Log

---

9/28/2011 : Change SQL Server 2005 Replication Agent Profiles
Change SQL Server 2005 Transactional Replication Polling Interval

---

8/25/2011 : Server Setup Basics - Considerations and Good Practices
Don't forget too......

---

6/2/2011 : Cross apply and a quick date split function
Cross apply example using a UDF for dateparts in a query (used for adoc pivot tables)

---

2/17/2011 : Restore Duration ("Don how much longer till stage is refreshed?")
Problem: How long is it going to take for my restore to finish? Hell, any query I'm concerned with.

---

2/10/2011 : Lightweight trace for finding offensive and expensive queries (Hourly Trace for Offenders)
Lightweight trace for finding offensive and expensive queries (server side, hourly cycle, 12 hour window)

---

2/10/2011 : Useful Profiler T-SQL functions
Useful Profiler T-SQL functions (start, file to table, getinfo)

---

2/8/2011 : Defrag me please........
Defrag me please......

---

2/8/2011 : Quick database defragmentation at a given threshold. SQL 2k5 and 2K8
Quick database defragmentation at a given threshold. SQL 2k5 and 2K8

---

2/8/2011 : Quick database defragmentation at a given threshold. SQL 2k
Quick database defragmentation at a given threshold. SQL 2k

---

 1 of 3 Next