Ron Porter (12/14/2010)

---

By accepting it and bringing it into the open, you have the chance to provide skill-appropriate guidance, reduce the duplication of effort, and identify prime candidates for more...

Heard Tim Legler on Mike and Mike say that most of the time this doesn't work. 97 Marlins, '09 Yankees were able to buy a championship. Most other times it...

For the most part I agree with GSquared. The performance issues can grow as you layer and nest things. UDFs and Views, while abstracting and reusing code, often mask issues....

What is the primary key on bookingactivity?

You can find duplicates by using a GROUP BY on the pK and a having count(*) > 1. What you first need to do...

You cannot do this. You would either need to create the tables with the proper database name as I've done with dynamic SQL, or run a pre-written script. If the...

/3GB allows a 32 bit application in Windows to use up to 3GB of space (leaving 1GB for the OS). However SQL Server Standard (2000) has a limitation of 2GB.

For me, email is really the way I hear about things. I have a smartphone, iPad, and multiple machines. On one of those, I'll get a note. It could be...

As far as the conversion, you need a valid date, no matter what the format. If there is '00000', this isn't remotely valid.

What you can do is look for...

Only for convention. These are just file names and extensions, no relation to how SQL Server uses the files.

Your description is not clear about what you are looking for. What dependencies? What are you expecting the stored procedure to do?

What does filter mean? Are you looking to return this in a report or delete the data?

If duplicates, the distinct keyword can help you in a query to only show...

I believe the limited information for these is sysobjects in SQL 2000. There were many fewer system views in SQL 2000.

Moved to SQL 2000

I would use two roles here. One to read only from old tables, one to allow DDL activities.

If someone can create tables, they will be able to read/write from...

I believe that you would need to use dynamic SQL, to create the database.

declare @cmd varchar(max)

select @cmd = ' create table ' + @newdb + '.dbo.mytable (myid int)'

exec (@cmd)

Here's the bigint doc. You'd need to compare it to the Oracle documentation

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