Let's assume that there are several (or a hundred) tables which partition client data, and they are all prefixed with the name 'client_data_%', and you need to create on each...

A long time ago, I was asked to write some custom reporting SQL queries against a 3rd party database containing 100+ tables. It had one unique key on most tables,...

I believe that referential integrity constraints are important in a database. If you have data models for two or three tightly integrated applications with overlapping foreign keys and sharing of...

Linking Servers:

http://msdn.microsoft.com/en-us/library/ms188279.aspx

Once you have created a linked server object for the remote server, there are several options for returning a resulset and joining it with local tables.

For...

PaulB-TheOneAndOnly (5/7/2010)

Can the original developer...

I think we need a new podcast series on MSDN or somewhere, and base it on the TV series 'Trading Spaces'. It could be called perhaps 'Trading Schemas'. Two developers...

Since ClientID is not unqiue, then I assume the purpose of this ClientNum is to create a composite primary key. You can persist a calculated column using the PERSISTED clause,...

Code that is basically functional, something good enough for internal users, but not good enough for release to the public, is "not ready for prime time".

This discussion just underscores why it's imporatant to always have at least 2 admins and 2 developers who know your database, just in case someone steps in front of a...

How appropriate my previous query is depends on how someone intends to use the information. I wouldn't use this info exclusively to decide which stored procedures can be identified as...

Well, if being a SQL Server 2008 DBA has become a bore, you could always spend the next 100 years attempting to master Oracle database administration on the Linux platform....

The following query returns the name, execution count, min/max execution time, etc. for all stored procedures. It can also be extended to include CPU utilization and also performance metrics simply...

Getting involved with business intelligence tools like SSIS, SSAS, and SSRS will give your job some variety while leveraging your existing SQL Server knowledge. It will also get you out...

If there are well defined logical relationships between types of users, then you definately need to enforce this with foreign key constraints, or else referential integrity and performance issues will...

You said that both companies and individuals are basically 'users', which I assume means that they both login to the application with a profile and perform similar tasks. There could...