Re: Red Gate will be charging $35 for .NET Reflector

2011-02-03 Thread tonywr
Actually, I look at Reflector as a tool that helped advance the cause of dot net. Anyone who was interested had a chance to delve deeply into the framework to get a true understanding of how the technology worked. It was effectively an Open System. Once you put a price on it, the system

[Job] ASP.Net one stop shop role in Torquay, VIC

2011-01-26 Thread tonywr
Hi people, A friend of mine is looking for an intermediate person to help run the IT side of his events management business in Torquay. It's pretty much a lifestyle job. Details below. Please reply to me directly if you are interested, or know anyone that might be interested. Regards, Tony

SQL Server Deadlock on Insert

2010-08-08 Thread tonywr
Hi all, I am currently trying to improve the template code in our stored proc generator. In the insert stored proc, there seems to be a lot of code with references to deadlock detection, and attempts to re-run the insert if it fails due to a deadlock. But the insert statement itself has a

SQL Server SCOPE_IDENTITY() has a bug

2010-08-08 Thread tonywr
Hi all, According to: https://connect.microsoft.com/SQLServer/feedback/details/328811/scope-identity-sometimes- returns-incorrect-value SCOPE_IDENTITY() has a bug that causes it to fail whenever parallelism kicks in (a more common occurence these days with the proliferation of multiprocessor

I don't like Linq to Entities

2010-08-08 Thread tonywr
Hi all, I have my archidev hat on at the moment (given my last few emails I'm betting that doesn't surprise people) One task I have been looking at is figuring out how to convert our applications from Linq to SQL over to Linq to Entities. The reasons are that Linq to Entities is installed

Re: [OT] Friday - Recruiters

2010-07-29 Thread tonywr
hahaha, and we all know what a mistake he made, hey Corneliu? Obviously missed asking the right questions and missed an exceptional candidate. My experience a few years ago with recruiters was seeing a whole lot of ads on seek asking for developers, and then having the exact same recruiters

Visual 2010 XAML Design View delays

2010-07-28 Thread tonywr
Hi all, One of my gripes regarding Visual Studio 2010 is just how long it takes for that XAML Design view to load. It takes ages. On my machine it can take 20 seconds to load. On one of my colleagues I've seen it take between 40 seconds and a minute to load. It's an absolute pain. So when

Re: [OT] Friday - Conway (or.. Labor govt) once againdelaysInternet Filter

2010-07-11 Thread tonywr
Actually, a friend of mine's wife is an anti-Gambling campaigner who produced a report with Tim Costello. According to the report, for every $1 million spent to jobs created in various industries, the Food industry produced 20 jobs, the Gift industry produced 10 jobs, but the Gambling industry

Re: Embedding SQL index hints into SQL commands for SQL SERVER.

2010-06-21 Thread tonywr
Hi Peter, Databases that only have a relatively small amount of data and are unusually large are often caused by having transaction logs that have blown out in size. The usual way to reduce the size of the transaction log is simply to back it up properly (depending on the recovery model).

RE: Embedding SQL index hints into SQL commands for SQL SERVER.

2010-06-21 Thread tonywr
Can you not submit a request to run a delete query to remove all the old data? I'd try to submit a patch script that does that. Try to sell it as a win-win scenario - your win is obvious and they win because it looks like they're doing their job! That query looks like it's scanning 2 Bit

Re: VS2010 Professional Pricing

2010-04-15 Thread tonywr
Before the Parallel Import Act was passed in 2003, Allan Fels gave a speech on Parallel Importation, found here: http://www.accc.gov.au/content/item.phtml? itemId=179183nodeId=5466d384ea376830f3007417eef6cb72fn=PARALLEL%20IMPORTING.pdf This explains the main reasons that it was ultimately

Sql Server Nested Transactions

2010-03-26 Thread tonywr
Hi all, I have a stored procedure with nested transactions. A rollback transaction occurs in the inner transaction, but I don't want that to cause the outer transaction to rollback. Is that possible? It seems that the rollback always rolls back both transactions. Regards, Tony

Re: [OT] Visual Studio 2010 RC

2010-03-25 Thread tonywr
Well, I guess we'll give it a try again once the product is released, but if it gives us any trouble, it won't be worth the effort and we'll pull back until service pack 1. That said, Microsoft often have extra RCs internally before RTM anyway, so hopefully that has resolved most of the