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
5,074 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
428 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
817 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
914 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
2,098 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,712 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
659 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
613 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
551 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
801 reads
Blogs
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers