Notes about PASS 2003 and Other Stuff
Andy wrote up some notes about the recent PASS Community Summit, plans for next year, people we met, and much more.
Andy wrote up some notes about the recent PASS Community Summit, plans for next year, people we met, and much more.
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!
Chris Kempster brings us a basic look at the database design topic of denormalization.
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.
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!
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.
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!
New Author! The author tries to port a solution from Oracle and runs into a problem. Agree with the solution?
New product designed to help you move from one database platform to another. (Not Reviewed)
New Author! Jeff had some questions about fill factors - but no answers! He did some work and came up with a set of recommendations for how and when to set your fill factors to something other than the default.
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers