Expanding The Scope of Bridge Tables
Timothy Claason continues talking about database design in a new article. This one talks about expanding the functionality that Bridge Tables provide in your schema.
2010-03-23
7,947 reads
Timothy Claason
- Interests: Currently, my free time consists of spending time with my 2 beautiful kids, and working on a project/requirement/defect/test case management application, currently called TestAutomation...currently at https://sourceforge.net/projects/testautomation/
Denormalization Strategies
In building a database, typically we want a well normalized design. However there are cases for considering options for denormalization in complex systems. Timothy Claason gives you some thoughts on the subject.
2010-03-15
10,875 reads
Is Your Database Application DeadLock and Timeout Resistent?
Is your application scalable under increased activity? Timothy Claason brings us a methodology for testing how your application will deal with database load.
2010-03-10
12,605 reads
2010-03-02
9,163 reads
Blogs
Everyone Run a SQL Saturday in 2021
By Steve Jones
With SQL Saturdays being rebooted, and the SQLSaturday.com website live, it’s time for events....
Modern Data Warehouse & Reverse ETL
By James-Serra
An extension to the Modern Data Warehouse (MDW) that I have heard a bit...
Daily Coping 12 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Error installing SQL Server 2014 (both 32 & 64 bit versions)
During installation of SQL Express Server 2014 i have this error Title: Microsoft SQL...
Linked server to Access accdb database
Hi all We've got a linked server from SQL 2016 to an accdb...
performance tuning
Hi everyone, Any good suggestion to tune below query: --CREATE NONCLUSTERED INDEX nonclust_code...
Ask SSC