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...

You stated "I was trained on SQL Server 2000 and pushed into Database Administrations..." as if it wasn't your choice to make. You also mention you're not having fun, the...

In my proc, I have the following two lines:

select @sql = 'insert into lookups (fieldname) select distinct '+QUOTENAME(@fieldname)+' from '+QUOTENAME(@tablename)+' where '+QUOTENAME(@fieldname)+' IS NOT NULL and ltrim(rtrim(convert(nvarchar(max),'+QUOTENAME(@fieldname)+'))) <>...

As an alternative to SQL Server Agent, you could use Windows Scheduler and PowerShell scripts.

http://www.eggheadcafe.com/software/aspnet/30631798/server-2003-task-schedule.aspx

10 GB could accomodate an inventory of several hundred thousand items and tens...

It sounds like you've got something working with SMO, but as a side note for anyone interested, the following will list all parameters of datatype 'smallint' for all user created...

Eric, you touched a raw nerve by suggesting Access over SQL Server, so expect a bit of hate. With that said...

Microsoft Access offers no real protection over SQL Server with...

Execute a "checkpoint", and then again confirm if the secondary file has increased in size.