Service Packs and Support
More coming next week in editorials and already a note on the site, but support for both SQL Server 2000...
2007-07-07
633 reads
Blog Posts
Cursors to Increase Performance?
I recently had the chance to look over a friends shoulder at a query that needed some tuning work. In...
2007-07-06
704 reads
Latest Service Packs and Books Online
I was reading a new post at SQL Server Magazine titled The More Things Change(full version available to registered users...
2007-07-06
620 reads
Midlands PASS Chapter July Meeting with SQL Server MVP Wayne Snyder
SQL Server MVP Wayne Snyder Speaks on SQL Server Integration Services (SSIS)
Midlands PASS Chapter - July 12, 2007 Meeting
Sponsored by...
2007-07-06
777 reads
The Video World
I wonder what you think of this: video shorts. I've gottne the Lockergnome newsletters for years and they've proven interesting...
2007-07-06
601 reads
70-444 Exam Prep Book
I just got my author copies of the Sybex book for exam 70-444 and have to say the book looks...
2007-07-05
728 reads
Blogs
One of the suggestions I saw today was to add blogs to the user profile on the site and not...
2007-07-05
638 reads
The Journey to Katmai
I wrote an article recently on the Journey To Katmai, looking at some of the new features that are coming...
2007-07-04
656 reads
Breaking Up is Easy to Do
Breaking Up is Easy to DoHardIt's nice to be able to package a process into a single, tidy, elegant query,...
2007-07-03
595 reads
Who said that breaking up is hard to do?
Some of you younger DBA’s out there may not know who Neil Sedaka is or remember his poignant words "Breaking...
2007-07-03
602 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...