Is The PASS Summit Worth It?
Steve Jones has attended the PASS Summit annually, and found value. But for this Friday's poll, did you find value this week? Or have you in the past? Let others know.
2009-11-06
788 reads
Articles
Troubleshooting Reporting Services Performance Issues
The conclusion of our coverage of the Reporting Services component available in SQL Server 2005 Express Edition discusses systematizing the troubleshooting approach by focusing specifically on performance problems (as opposed to those impacting functionality).
2009-11-06
2,804 reads
Using T-SQL CROSS APPLY and OUTER APPLY
That said, even though my personal focus is pretty much OO, I still miss stuff. SQL Server 2005 came out with the CROSS APPLY and OUTER APPLY operators and I have just started learning how to use APPLY in the last month or so. When I think I have it figured out, I am fortunate enough that some of you are interested in reading about my understanding of the technology.
2009-11-06
7,434 reads
The ADO.NET Managed Providers team wants to hear your opinion
Take this survey and help out the Managed Provider team at Microsoft.
2009-11-05
797 reads
SQL Server 2008 Diagnostic Information Queries
Here is the script that I used in my Dr. DMV presentation this afternoon at PASS. It is a set...
2009-11-05
1,355 reads
SQL Server Unique Constraints for Large Text Columns
We are storing large text and URLs that are over 900 bytes in some of our tables and have a requirement to enforce uniqueness in those columns. But SQL Server has a limitation that index size can't be over 900 bytes. How do I enforce uniqueness in these columns and is it possible to achieve this in SQL Server 2005 and above? What are my different options to solve this problem? I heard that we can use CHECKSUM to create a hash, but is it possible to avoid collisions in the hash value as we are storing millions of rows?
2009-11-05
3,006 reads
Tuning SQL Server 2005 Integration Services for EBCDIC Data Conversion
Loading EBCDIC data into SQL Server is not a well documented process - this article provides a very useful guide to optimizing the performance of this operation.
2009-11-05
2,019 reads
2009-11-04 (first published: 2009-10-16)
169 reads
Improving Cube Performance with Precalculated Aggregations
A step by step example of how to add pre-calculated closing balances through T-SQL and semi-additive measures from Johan Åhlén.
2009-11-04
7,048 reads
Suggested Max Memory Settings for SQL Server 2005/2008
It is pretty important to make sure you set the Max Server memory setting for SQL Server 2005/2008 to something...
2009-11-04
3,401 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