(Darla Ferrara) Resource Description Framework (RDF) is a standard for describing web resources. Right now you are probably shaking your head and saying “What is a web resource?” The term “resource” is sort of old school.
Other News
Automatic Statistics Update Slows Down SQL Server 2005
(Tibor Nagy) I have a database which has several tables that have very heavy write operations. These table are very large and some are over a hundred gigabytes. I noticed performance of this database is getting slower and after some investigation we suspect that the Auto Update Statistics function
OTLT – One True Lookup Table
SelecTViews (Free video show!) So much data, so many databases…to the moon! Cloud exit strategies, cloud security considerations, wireless access to data… Jeopardy!(tm) ….and the SSWUG Virtual Conference, Bus. Intelligence Upgrade hesitations and much more. [Watch the Show] Featured Article(s) Troubleshooting SQL Server 2008 Database Mail Problems In this article, Alexander Chigrik explains some problems that you can have when […]
Hardware Based Failover
Last Day to Register for SQL Server – Microsoft Management Console Stephen Wynkoop’s Webinar begins tomorrow morning. Today is your last chance to register to attend this presentation on more fully utilizing Microsoft Management Console to maintain and document your databases. Learn how to learn from the tools shipping with SQL Server. $$SWYNK$$ Featured Article(s) Top Ten Database Blunders (Part […]
My Biggest ASP.NET Programming Mistake
(Peter Vogel) I recognize now that I was being dumb, but at the time I thought I was being damn clever. This was in the days of ASP.NET 1.0/1.1 and I had this brilliant idea for how I could structure an application for one of my clients. Well, it seemed brilliant at the time.
Using the ASP.NET Repeater Control 6retweet
(Mark Kendall) Programming in today’s world requires you to have many talents in many different areas, if you are going to be able to solve even the smallest business requirement. But we cannot know everything about anything, so that’s why we a programmers favorite friend is Google. You know I’m rig
ASP.NET File Manager – Data Bind using Data Source
(Mehul Harry) Check out this upcoming feature of our ASP.NET File Manager that allows you to data bind to a database using a DataSource.
Cardinality Estimates in Dynamic Partition Pruning
(Hemant K Chitale) Dynamic Partition Pruning occurs when the Optimizer cannot determine which Partition(s) of a table will a query have to execute against, although the query does not need to do a Full Table Scan of all the Partitions.
Common errors seen when using OUTER JOIN: Join Against a Constant
(Iggy Fernandez) Tom Kyte published an interesting OUTER JOIN example in the March/April 2011 issue of Oracle Magazine in which a three-way join (including one outer join) was equivalent to querying a single table.
Scoping rules in DB2
(Serge Rielau) Years ago name resolution for so called identifiers was an easy thing to do.