Back in the day, of course, we would never use 8 bits where 1 would do, but today we've got the space so we use it to make things easier...

I think it must be the QotD, because today's newsletter is the same width. I don't normally pull down images in e-mail. That is the default in all the mail...

I have 2 monitors at work, both 1280 x 1024. The screen shot spans both of them; you can see pretty clearly the dividing line between them and that to...

I think this subject needs a bump. I've noticed a number of times lately that the newsletters were running a little wide in my e-mail client, but today's issue [VBscript...

Cute car... I'd really hate to have to open that front door to get in or out in when it's raining, though. 🙂

I don't know that realtime updates are that critical. I work for a university, and in our case we are already receiving nightly feeds from the official student system. It's...

Well, the job froze again last night just before I went home. Looking at the profile, the job ended after completing a TRUNCATE TABLE command on one of the files,...

Thanks for the suggestions. I'm not sure what you have in mind for basis logging, but the rest makes sense. Results from sp_who2 shows the process as sleeping and AWAITING...

I guess I am still unclear about the definition of PK here, not the fact of how PKs are implemented (or may be wrongly implemented) in real database systems.

My understanding...

Agreed. 🙂

Table_1 is defined with 4 columns, but your select only includes 3. You need to either explicitly state which columns you are inserting into or make sure the number of...

Well, I applied the latest update for my filter list and it seems to work now. I see that they have added an exception for the Google custom search site.

You're probably right. I built some DTS packages a couple weeks ago that use a Dynamic Properties Task to read a configuration table that contains the path to some import...

How about this:

SELECT SERVERPROPERTY('LicenseType'), SERVERPROPERTY('NumLicenses')

Details on the SERVERPROPERTY function can be found in BOL.

Why would you try to put an empty string into an INT column? An empty string is not NULL.