Here are my two cents:

We spent the last 4 months looking for a Business Analyst who would come with a strong SQL Server background. We came across a person who...

According to the best of my knowledge it is not possible to use these new features in SQL Server 2000: Microsoft has not released any patch yet to accomplish ...

Colin, thanks for the backup.

That was exactly my point: You can live without GO as far as creating Stored Procedures are concerned (this being...

I am having real trouble understanding where I would use this 'approach' in real-world scenarios. In my experience with SQL Server (almost 2 years now) I have not come across...

There are very strict rules, as I learned at the Univresity, about how to put references to your work. I once made the mistake of quoting some work in one...

Interesting article!

Is it fair to say that the new SQL keywords , like NTile, and RANK, are more geared towards statistical analysis of data, rather than just doing simple database...

I would be interested to know the set-based solutions without String parsing

Thanks

Great Article and very good idea to simulate ARRAY functionality. A for the CURSOR simulation that has already been discussed earlier and different users have had different experiences with the...

this is indeed information for me and little bit of Googling produced this

this

Many thanks for adding to my knowledge

Here I will post two pieces of codes which are doing exactly the same thing: insert records into a two-column table. The total number of records is 6275. My...

I see that there is at least one person who has accused me of plagiarism. I can assure you that this is not the case and that this is a...

As far as hungarian notation goes I have 2 points to make:

1) With SQL IDEs like Imceda's SQLIDE Pro there is no need to use any Hungarian notation because the...

This will only work with OPENQUERY. I spent a lot of time on it. Use OPENQUERY to get the results from your remote server

Hope that helps....