Julian-kuiters - julian-kuiters.id.au - Julian Kuiters - SQL Server Thoughts...
General Information:
Latest News:
ASP.Net - Server operation is not available in this context - Using Server.MapPath in Global.asax 8 Apr 2013 | 07:39 am
If you try to use the Server.MapPath() function in your global.asax file for ASP.Net you are likely to encounter this error: Server operation is not available in this context To use Server.MapPath()...
ASP.Net Tools to Test High CPU Load, High Memory and High Disk Usage 27 Oct 2012 | 12:53 pm
Often when testing the performance of a ASP.Net website you need to see how the site will perform under extreme conditions. This is easy to do in a virtual environment where you can reduce the number ...
How to disable Flash in Google Chrome Browser 27 Oct 2012 | 12:31 pm
I use Google's Chrome browser a lot. Its fast, websites display correctly and there's usually less problems. But this week I started getting problems with webpages hanging in Google Chrome. I tested ...
Microsoft revokes trust in 28 of is own security certificates. Remember to run Windows Update today! 11 Jul 2012 | 07:20 am
Microsoft has revoked 28 of its security certificates via Windows Update today as part of their security advisory 278973. The certificates have been revoked following the Flame malware attack that in...
How to fix: User, group, or role '*' already exists in the current database. (Microsoft SQL Server, Error: 15023) 26 Feb 2012 | 10:53 pm
If you've restored a database onto another server, you may get the following error message when adding user logins to the database: Create failed for User 'TMS'. (Microsoft.SqlServer.Smo) User, gro...
SQL Server Table Function Performance 18 Nov 2011 | 11:34 pm
Rob Farley has a great post on when is a SQL function not a function? Read the two below functions - they return the same thing, but one is more effecient than the other. If you can't see why, head o...
ANSWER: UPDATE failed because the following SET options have incorrect settings: 'ANSI_NULLS, QUOTED_IDENTIFIER' 20 Oct 2011 | 09:25 am
I came across an interesting problem last night - a stored procedure that had been created years ago was suddenly coming up with this error message: UPDATE failed because the following SET options ha...
Finding changed rows in SQL Server using INTERSECT, ISNULL or COALESCE and performance 1 Jul 2011 | 09:51 am
If you are trying to determine which rows are different between two sets, the usual method is to create a query comparing table1.Column1 != table2.Column1 but this doesn't check for rows where one of ...
Microsoft SQL Server Books 21 May 2011 | 07:34 pm
...
Why are my Covering Indexes not working in SQL Server? 19 May 2011 | 11:31 pm
Rob Farely has posted a great article on why your covering indexes in SQL Server may not be getting the perfomance you are expecting. Covering, schmuvvering – when a covering index is actually rubbis...
