Project Phoenix: Late August Awards Announced
Two more eligible developers and deserving projects have been selected. Any proposals submitted but not selected this time will be...
2010-08-31
1,484 reads
Blog Posts
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,650 reads
Return top 20 queries by Average CPU
I’ve recently used this when troubleshooting some unexplained high CPU load on my server:
select top 20st.objectid, st.dbid, total_worker_time/execution_count AS AverageCPUTime,CASE statement_end_offsetWHEN -1...
2010-08-31
4,240 reads
SELECT, Deconstructed
Today let’s expand on the logical processing order of SELECT that I mentioned in last week’s N Things Worth Knowing...
2010-08-31
2,560 reads
SQL Saturday #48 - Columbia - Call for Speakers Ending
This is a reminder for those who might be considering submitting a session but haven't yet. The call for speakers...
2010-08-31
1,403 reads
SQLRally Pre-Con Selection Process – Draft for Comment
Hopefully you’ve heard by now that PASS is launching a new event format called SQLRally in May 2011 in Orlando....
2010-08-31
1,892 reads
Unique and non-unique non-clustered indexes on a unique clustered index
In the last weblog
post I have talked about the difference of unique and non-unique clustered indexes.
As you have seen SQL...
2010-08-31
9,795 reads
Convert Several Columns in SSIS With Fewer Clicks and Confusion
I've had this one in my toolbox for a while now, decided to publish it on CodePlex a while back,...
2010-08-30
700 reads
Defensive Db Programming Chapter 06
We are here again after another week and ready for another episode in this series. Today we get to talk...
2010-08-30
1,765 reads
Hardware Performance Research
I am trying to gather some information about some of the newer Intel and AMD processors as part of my...
2010-08-30
1,890 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers