(Lester Knutsen) In my previous column, I discussed five useful new tables in the Informix Dynamic Server (IDS) 11 Sysmaster database. In this column, I’ll continue that list.
Other News
SharePoint, SQL Server and More
[Watch] SelectViews SQL Server Show Here Build Dashboards More Easily Dashboards are the heart of understanding what information needs to be investigated further, how things are going and more – all at a glance. Building those dashboards can be really challenging, but you can make it a whole lot easier with the right tools. Check out Visual Mining’s NetCharts – […]
Do You Have a SQL Server Security (or Data Security) Position?
Featured Article(s) Tips for using indexes in SQL Server 2005 (Part 2) Here are some helpful tips to performance tune and optimize SQL Server 2005 indexes. Password problems? Imagine forgetting all your passwords… Now you can. Manage and share your organization’s critical passwords with Secret Server, a highly secure web-based password management system With our Active Directory integration system, all […]
Rebuilding Indexes
(Hemant K Chitale) Conventional “modern” (“modern” meaning “developed between 5 and 10 years ago ?) wisdom is that indexes in Oracle, generally, do not need to be rebuilt. This sometimes takes more strident expressions as “indexes never need to be rebuilt” . At times this position is expressed with
XML and Modeling
(Kurt Cagle) Data modeling is a big thing at Burton Group – a significant amount of the airtime expended in the ether around the virtual water cooler is devoted to teasing out the way that models interact, the best language for expressing such models and what characteristics best define a good model
Store Indexes In a Larger Block Tablespace: Some Thoughts (Big Brother)
(Richard Foote) A suggestion that seems to pop up on a routine basis on various forums and discussion boards is that we should be storing our Indexes in a larger block-size tablespace. For example, if our database block size is set to 8K, we should be creating separate (say) 16K block tablespaces sp
Tip of the Day — ACID Compliance
When working with databases that allow for transactions you will often see the term ACID compliant.
Partner TechTip: A Best-of-Breed Business Intelligence Solution Can Solve a Lot of Business Issues
(Tom Huntington) Is your BI solution meeting your needs? It might not be if you have any of the following symptoms: Your data is out of date; your report backlog is still a backlog; your BI technical department is larger than two people; your team spends time redefining your data to make the solutio
Understanding Optimistic Locking
Readers and writers can get along. All it takes is a positive outlook–and an optimistic approach to locking. Columnist Bonnie Baker explains why pessimism rarely pays. (R)
Formatting Numbers
(Jim Mischel) The IFormattable interface implemented by the .NET basic types allows you to format numbers in many different ways, including adding commas, specifying the number of digits after the decimal point, currency, scientific notation, and others. In the .NET CLR, all of those number formatti