When you register, you will get a ticket for the party if you originally filled in the SSC code.  The party is Tuesday night at 7:30. 

This post actually should have gone in another section, this one is for suggestions about the web site. 

The problem is most likely due to data in the foreign key table...

I am counting the days!  Last year was really run since I knew so many people from working on the committee and from SSC.  Can't wait to meet more new...

Again, I would double-check the parameters that get passed to that report.

Is this actually a sub-report or is it actually a report you are clicking through to?   Make sure your parameters are correct.   If you can, use SQL Profiler to see...

Inside your trigger, you will have two tables: inserted and deleted.  The deleted table has the old values and the inserted has the new values.  So, you can evaluate the...

You can have multiple log files.  If I remember correctly, if the first log file fills up, then the second one will be used. 

I think you should look at using a backup compression program that will shorten the time and compress your backup file.  Several vendors have them, including Quest, Idera and RedGate. In...

This is similar, but I have broken it down into an insert and separate updates.  For me, this is easier to understand.

create

table TableA...

If you don't want to open BIDS, you can run this by right-clicking on a database name in SQL Server Management Studio, then choose "Tasks" then "Import Data" or "Export Data".

Great article!  Answering posts can be pretty tough, especially when the poster refuses to answer any questions posed by the person trying to help. 

Steve,

I can't believe you featured this article again, what were you thinking? 

Thanks for the kind words.

One thing that is disappointing is that some people will put bad reviews on Amazon because the book didn't explain the exact problem they were trying...

I didn't need your real tables, this example is fine.  I think that even though you have to create dummy fields, a UNION isn't too bad.  Here is an example...

I am not using the Express edition, but maybe the steps are similar:

1) come up with a brand new login and password

2) Expand the security section, right-click on Logins and choose...