Most of us know what it is, or do we? Chris works on a good definition and along with that, gets into a good look at the problems denormalization creates and talks about a pretty common form of it - the indexed view.
2003-12-02
12,286 reads
Andy wrote up some notes about the recent PASS Community Summit, plans for next year, people we met, and much more.
2003-12-01
2,650 reads
Views dont parameters, but sometimes you need them to act as if they do. Andy discusses views and how they encapsulate code and then offers an idea about how to alter the behavior of views on the fly. Controversial? Probably!
2003-12-01
8,502 reads
Chris Kempster brings us a basic look at the database design topic of denormalization.
2003-12-01
17,799 reads
The name has changed, but the owner and the upgrade policies remain the same! Follow the link to see the press release that explains the name change.
2003-12-01
672 reads
Part two in the Introduction to ADO series, this beginner level article shows how to open a recordset, how to add and edit records, and touches lightly on how to select the best cursor type and locking mode. Good code samples help you get started fast!
2003-11-28
16,696 reads
One of our favorite authors is back with a great how-to on log shipping. This isn't the baked in log shipping, this is a code your own solution that gives you a starting point for your situation. Even if you don't need it now, it's worth looking at to gain a better understanding of how shipping works.
2003-11-26
26,190 reads
This articles covers a variety of techniques to let you bypass or conditionally execute code in a trigger based on criteria outside of the inserted/deleted tables. It also includes a contest that gives you a chance to win a copy of our book The Best of SQLServerCentral.com 2002!
2003-11-24
12,570 reads
New Author! The author tries to port a solution from Oracle and runs into a problem. Agree with the solution?
2003-11-21
11,559 reads
New product designed to help you move from one database platform to another. (Not Reviewed)
2003-11-21
1,260 reads
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
By Steve Jones
This image is from 2010, and it goes along with my last post of...
All week we've had issues with the site being up and down. There's been...
I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers