Index Operations Showdown: Drop & Create vs. Create With Drop_Existing vs. Rebuild
Every now and then you may have had to move nonclustered indexes between filegroups. There are two ways it can...
2010-09-29
4,525 reads
Kendal Van Dyke
Presenting At Sarasota SQL Server Users Group On Sept. 21
On Tuesday, September 21, I'll be at the Sarasota SQL Server Users Group to present Paging DR Availability, You're Wanted...
2010-09-15
415 reads
PASS Summit Logo Design Contest
It appears our success with the SQLRally Logo Design Contest has struck a chord with PASS HQ. This morning Rick...
2010-09-10
808 reads
More On Overlapping Statistics
In my last post I provided a script to identify overlapping statistics but realized afterwards that I left out a...
2010-09-09
882 reads
Tuning Tip: Identifying Overlapping Statistics
Statistics are used by SQL Server's query optimizer to help determine the most efficient execution plan for a query. When...
2010-09-08
1,999 reads
Replication Gotcha - Including An Article In Multiple Publications
When administering replication topologies it's common to group articles into publications based on roles that subscribers fulfill. Often you'll have...
2010-08-31
10,518 reads
Replication Gotcha: Blank XML
Transactional replication in SQL Server 2005\2008 can handle the XML datatype just fine with few exceptions - one in particular being...
2010-08-24
641 reads
Thoughts On The 2010 PASS BoD Elections Candidate List
Yesterday PASS published the list of candidates on the ballot for the 2010 Board of Directors election. Much to my...
2010-08-19
604 reads
The PASS SQLRally Logo Winner Is…
With 63% of the total votes our winner is Speedometer! Congratulations to azzam on 99designs and thank you to everyone...
2010-08-10
541 reads
Vote For The PASS SQLRally Logo
We received over 100 submissions for our 99designs contest to design the SQLRally logo. The SQLRally planning team, with help...
2010-08-04
791 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
Unknown Token Received From SQL Server
I have an issue when a stored procedure is executed from the SQL Server...
SSRS error on sign in ERR_UNEXPECTED
Hi All, I have an error coming up when anyone tries signing into our...
Hash Joins IV
Comments posted to this topic are about the item Hash Joins IV