2005-08-16
1,298 reads
SQL Server 2005
2005-08-11
1,307 reads
2005-08-08
1,245 reads
2005-07-25
1,145 reads
2005-07-13
1,261 reads
2005-07-05
1,286 reads
2005-06-21
1,134 reads
2005-05-18
1,143 reads
2005-05-04
1,435 reads
XML Indexing In SQL Server 2005
Intrested in how to index XML documents? Here's a 12 page PDF on how this works.
2005-05-04
4,221 reads
Blogs
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Forums
WHERE condition using ='value' returns different results that using IN('value')
Have an interesting scenario - user found a discrepancy with rows returned when running...
Complex Query (Multiple Tables & Joins) - Need to Restrict to Max Date
I am using the query listed below. USE GAGETRAK_26237 SELECT G.Gage_ID 'ID', G.Model_No 'Model',...
Unknown Token Received From SQL Server
I have an issue when a stored procedure is executed from the SQL Server...