SQL Server Code,Tips and Tricks, Performance Tuning

Check out the new Books On Line search provided by live.com. The link below provides a scoped search of Books Online. It will only return en...

When upgrading to SQL server 2005 you already know that you have to rebuild your indexes and update the statistics. In addition to that, cre...

Kimberly Tripp compiled a nice list of all the top whitepapers available for SQL Server 2000 and SQL server 2005. Some of them are written ...

Just ask Alex Chiu. This is what he wrote: " Google controls 50% of the world's searches. This famous website is so controversial t...

SQL Server 2005 SP2 has an important enhancement to the OBJECT_NAME metadata function and a new OBJECT_SCHEMA_NAME metadata function. Becaus...

This makeuseof site has some cool Gmail hacks and tools. There are FireFox Extensions, GreaseMonkey scripts,Desktop APPS & Web TOOLS and...

Codeplex is the project hosting site for Microsoft SQL Server Samples and Community Projects. This portal page for SQL Server on Codeplex ca...

I have been participating in newsgroups/forums for about five years now and lately I have noticed that at least 60% of the questions are the...

Saw this error while running a job Error Code: 4860 Cannot bulk load. The file "%ls" does not exist. Massenladen ist nicht möglich...

OpenAjax Alliance, an open industry collaboration dedicated to developing and expanding Ajax, today announced that its membership has grown ...

Got this pic in the mail today. I have been working with a dual-monitor setup since 2001 but this is unquestionably better. Here is how I wo...

An Irish daughter had not been home for over 5 years. Upon her return her father cussed her. "Where have ye been all this time? Why did...

If you work with data and are trying to visualize this data then you will appreciate Google's latest purchase Gapminder . Gapminder and ...

So you have these boring meetings and you want to say stuff that sound smart but no one will understand what you talking about. What do you ...

Okay we all know what Amazon Simple Storage Service ( Amazon S3 ) is. Now there is a new service from Amazon called Amazon Elastic Compute C...

TechNet has made availabe a whitepaper that deals with Online Indexing Operations in SQL Server 2005. Introduced in SQL Server 2005 Enterpri...

March 14th is Pi Day as the date 3/14 corresponds to the mathematical number pi. The mathematical constant π is a transcendental (and theref...

Gmail's quota will continue to increase in the following years. What to expect in the future: 2835 MB on April 1st 2007 2980 MB on April...

It is all here: http://apple.slashdot.org/comments.pl?sid=44091&cid=4592270 Enough said.

This question pops up frequent enough so here are 4 ways to return the database name for the current user process First up is the fastest me...