Setup a Database Snapshot
I have been tinkering lately with database snapshots and I thought the subject warranted a short post on the subject....
2010-02-23
739 reads
Gethyn Ellis
SQL Server 2005 CLR execution error after restore
I recently restored a SQL Server 2005 database to a testing environment. The database contained several CLR assemblies, when the...
2010-02-21
1,123 reads
sys.dm_os_wait_stats
This is a short note explaining he sys.dm_os_wait_stats DMV.
This DMV returns the following columns/values regarding waits encountered by executed...
2010-02-18
1,301 reads
SQL Server - Checkpoint
What is a SQL Server checkpoint?
A SQL Server checkpoint is the process of writing all dirty datafile pages out to...
2010-02-16
6,825 reads
SQL Server 2005 SP4!
Microsoft has recently announced the planned release dates for the next round of SQL Server service packs. SQL Server 2008...
2010-02-14
689 reads
Useful reading this week
This is a short post for a Sunday afternoon, I thought I’d share some useful reading from the week gone...
2010-02-14
859 reads
SQL Server Trace Events
I answered a forum post the other day over on SSC on the differences between the trace events stmtcompleted and...
2010-02-11
2,921 reads
SQL Server Useful Reading
I have been having an IO subsystem issue recently and I found the whitepapers very useful and wanted to post...
2010-02-09
772 reads
SQL Server Storage
This is a short post on SQL Server storage best practice and what i have learned over the years… Much...
2010-02-07
1,328 reads
SQL Server Waits and Queues
Useful link. This is a great best practice article/white paper from Tom Davidson and Danny Tambs.
The word document (880kb) can...
2010-02-07
583 reads
Blogs
Big Queries, Big Money
By Steve Jones
I had been meaning to post this, so as I finished a piece that...
A New Word: Fardle-dun
By Steve Jones
fardle-din – n. a long-overdue argument that shakes up a relationship, burning wildly through...
Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch
The post Lukáš Karlovský: I got the green light from management and built Fabric...
Forums
Which selection criteria is more efficient.
Is it more efficient to search on an int than a nullable DateTime? I...
Trigger After Update to Update the Updated Table
Okay I can easily see how to update a table field after an Insert...
The Pervasive Nature of Open Source
Comments posted to this topic are about the item The Pervasive Nature of Open...
Question of the Day
Subqueries II
What is wrong (if anything) with this code?
SELECT *
FROM Sales.SalesOrderHeader AS soh
WHERE customerid IN (SELECT soh.CustomerID
FROM Sales.Customer AS C
WHERE soh.CurrencyRateID = 1
ORDER BY c.ModifiedDate)
See possible answers