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
800 reads
Articles
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)
170 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,059 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
T-SQL Best Practices – Don’t Use Scalar Value Functions in Column List or WHERE Clauses
Query performance can be affected by many different factors. This article introduces another best practice of how and how not to use a function within your T-SQL statements.
2009-11-04
8,725 reads
Updating a Database from WinForms Controls, Old School
Of all of the reader email I get, just these two things alone reminded me that of course I don't know everything, and many of you are working at a widening level of experience. To that end, this article is an old school article that shows new-to-WinForms programmers how to read data from controls and contrive SQL that updates a database.
2009-11-04
2,572 reads
Come and Get it! Making Business Intelligence More Consumable
This, the first in a series of three articles, describes the history of information workers and discusses their characteristics. The next article will describe how to leverage the latest BI technologies, and the final article will address how to improve information consumability.
2009-11-03
2,375 reads
Blogs
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
Forums
ALAMAT KONTAK BCA KCP Pecatu Telp:08218154393
WA:08218154393 nomor 275 Blok 4, Jl. Raya Uluwatu dan 5 No.99, Ungasan, Kec. Kuta...
ALAMAT KONTAK BCA KCP Ubud Telp:08218154393
WA:08218154393 Jl. Raya Ubud No.10, Petulu, Kecamatan Ubud, Kabupaten Gianyar, Bali 80571
ALAMAT KONTAK BCA KCP Benoa Telp:08218154393
WA:08218154393 Jl. Suwung Batan Kendal No.2, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80222
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers