Se vc mora em Florianópolis pode participar do evento de lançamento mundial do SQL 2008 que realizamos através do www.dotnetfloripa.net o qual sou um dos coordenadores. As fotos estão disponíveis em http://www.dotnetfloripa.net/eventPhotos.aspx?id=46 . Agradeço muito a presença de todos no evento e a...

Next pet project is to move my blog on Community Server to the Cloud. I spend too long making sure my database size does not go over 500 MB, the size limit on my hoster. So once every 3 months I have to do some clean up of the database: DELETE FROM cs_statistics_Site DELETE FROM cs_Visits DELETE FROM...

I was getting the following error in a stored procedure that I had written. Nothing fancy in it as far as concern with using any new features of SQL 2005. Msg 321, Level 15, State 1, Line 5 "sql_handle" is not a recognized table hints option . If it is intended as a parameter to a table -valued function...

Normal 0 21 false false false ES-UY X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5...

Recently, in one project i need to get random records from sql server table and i found a good way to do same. SELECT TOP <n> <column list> FROM <table> WHERE <criteria> ORDER BY NEWID() The main function is NEWID() which return GUID. Ex. Select Top 10 * From Employees Order By...

I just found out something really weird about HTML comments. Apparently, according to standards, you can't do this: <!-- comment ------------------------ --> That is, you can't put two or more ‘-‘s inside a comment. It works as expected in IE7, but it breaks down horribly in FireFox. FireFox simply...

I was listening to the recent .NET rocks episode about the Entity Framework advisory council and it was interesting to hear the team's point of view and the problems they are trying to solve with the Entity Framework. They have nice goals, but there is a fundamental problem here that some of the original...

I always seem to struggle with a NOT IN clause when there are more than one column to compare.  This, of course, comes up when I am trying to get records from one set that are NOT IN another set and the comparison has to be done across multiple columns.  For instance, if I want to compare table...

I sometimes forget how to do an XML output formed in a tree when dealing with a single table parent/child relationship.  There is a great explanation on SQL Server Central on *how* to do this .  I am mainly capturing the link and the SQL I just generated to do this.  This query will drill...

When you schedule something to run in the Reporting Services and when the report gets emailed to the requestors, by default, in the email, you'll see http://servername/reportserver/report.... So what happens that if you are on the network (which is most likely if the reporting services is used for a...