MINUS Keyword in SQL Server - Alternatives(www.sqlservercurry.com)

submitted by SuprotimAgarwal(715) 1 year, 4 months ago

MINUS operator (in oracle) is used to subtract the rows which are available in the second result, from the first result set. SQL Server does not have a built-in MINUS keyword, but in SQL Server, it’s equivalent is the EXCEPT operator or using NOT EXISTS read more...

add a comment |category: Database |Views: 137

tags: Database another

Stored Procedure Optimization Tips – Best Practices(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 3 months ago

Key Points discussed in the articles are : 1. Include SET NOCOUNT ON statement 2. Use schema name with object name 3. Do not use the prefix “sp_” in the stored procedure name 4. Use IF EXISTS (SELECT 1) instead of (SELECT *) 5. Try to avoid using SQL Server cursors whenever possible 6. Keep the Transaction as short as possible 7. Use TRY-Catch for error handling read more...

2 comments |category: Database |Views: 779

tags: SQLAuthority pinaldave SQLServer Database SQL another

Reducing Code Coupling - Inversion of Control(grantpalin.com)

submitted by grantpalin(376) 2 years, 4 months ago

This is the conclusion to my series on reducing code coupling. This installment follows from the previous ones, building on them by introducing the Inversion of Control pattern. read more...

2 comments |category: Patterns |Views: 677

tags: IoC Patterns another

Fun with Func<T,TResult> Delegates, Events and Async Operations(west-wind.com)

submitted by rstrahl(7226) 2 years, 7 months ago

Delegates are powerful for event handling, highly useful in LINQ and a core requirement for async operations. Func<T> makes using delegate based logic a lot easier by providing a generic implemenation that in many cases allows you to skip creation of a separate delegate and instead just point at the Func<T> definition which can be a big timesaver and a nice way to remove delegate defintions from your namespaces. read more...

add a comment |category: C# |Views: 343

tags: C# another

12 Must Have Web Developer Bookmarklets(elijahmanor.com)

submitted by elijahmanor(1448) 2 years, 9 months ago

Here is a great set of 12 bookmarklets that are useful for any web developer on any web browser! read more...

1 comment |category: ASP.NET |Views: 886

tags: jQuery ASP.NET another

Life After Loops(codethinked.com)

submitted by markheath(1485) 2 years, 11 months ago

Eliminating cumbersome looping code using Linq read more...

1 comment |category: C# |Views: 684

tags: C# another

I Spose I’ll Just Say It: You Should Learn MVC(blog.wekeroad.com)

submitted by crpietschmann(11.3k) 3 years, 1 month ago

I’m never shy about my opinion – why start now? I’ve been reading a lot of posts flying about on whether you should learn MVC, Summing up the differences so you can decide when to use it, I even found a post that offers a scorecard approach! I remember reading the latter post thinking to myself “how can you possibly put a number next to Testability? And why it is only 2 more points than “using a RAD designer”? Isn’t this missing the entire point? read more...

add a comment |category: MVC |Views: 370

tags: ASPNETMVC MVC ASP.NET another

5 blogs every asp.net programmer should know analyzed with 31-DBBB day(development.tobiasopdenbrouw.nl)

submitted by tobiasopdenbrouw(140) 3 years, 1 month ago

31-DBBB day 4 task is to analyze leader blogs in your niche. I do so here with some recommendation I hope you'll enjoy read more...

1 comment |category: ASP.NET |Views: 569

tags: ASP.NET another

Top Visual Studio Add-ins(web2asp.net)

submitted by sedgey(1728) 3 years, 3 months ago

I am often asked what my favourite development tools are, so I thought I’d write down a few that I use and why. I have split this list in 2 as some of these are add-ons for visual studio and others are just standalone applications here are the VS Add-ins. read more...

add a comment |category: Visual Studio |Views: 1402

tags: VisualStudio another

Mark a C# class data member as readonly when it’s read only(developer-corner.com)

submitted by jeden(90) 3 years, 4 months ago

Explaining why and where to use the readonly C# modifier read more...

add a comment |category: C# |Views: 459

tags: C# another

Visual Studio 2010 == Visual Studio 2008 + ReSharper(codebetter.com)

submitted by Lord(3737) 3 years, 4 months ago

o you want the next gen of next-gen applications? Get the Visual Studio 2010 CTP! Which is – according to Microsoft itself – really just Visual Studio 2008 with ReSharper installed. read more...

7 comments |category: Other |Views: 931

tags: another

jQuery for Absolute Beginners: Video Series(nettuts.com)

submitted by sharplife(4570) 3 years, 5 months ago

This is a 9 parts video series for beginners to learn jQuery. read more...

add a comment |category: jQuery |Views: 435

tags: jQuery another

Becoming a ReSharper Samurai - Part 1(dimecasts.net)

submitted by dwhittaker(13.1k) 3 years, 6 months ago

Part 1 of Becoming a ReSharper Samurai - A short video on how to use various features of ReSharper to make you a better, faster coder. read more...

1 comment |category: Tips & Tricks |Views: 572

tags: astroturfing Tips another

jQuery and Microsoft(weblogs.asp.net)

submitted by mosessaur(5424) 3 years, 7 months ago

ScottGu announce that Microsoft will be shipping jQuery with Visual Studio going forward. We will distribute the jQuery JavaScript library as-is, and will not be forking or changing the source from the main jQuery branch. The files will continue to use and ship under the existing jQuery MIT license. read more...

1 comment |category: ASP.NET |Views: 380

tags: Pick jQuery news ASP.NET Microsoft another

The problem(s) with value types(blog.activa.be)

submitted by activa(2340) 4 years ago

Value types can sometimes cause unexpected behavior. This post explains one of the pitfalls you can encounter when using arrays and lists of value types. read more...

1 comment |category: C# |Views: 326

tags: pitfalls arrays C# Generics another

Alpha Hibernate 2.0(ayende.com)

submitted by gauravyakhmi(90) 4 years ago

Alpha Hibernate 2.0 read more...

4 comments |category: ASP.NET |Views: 11

tags: ASP.NET another