Cursors in SQL Server(aspdotnet-suresh.blogspot.com)

submitted by sureshdasari(715) 1 year, 6 months ago

This post explains about Cursors in SQL Server read more...

add a comment |category: Database |Views: 7

tags: Database another

What are Sparse Files and Why Should I Care as SQL Server DBA?(blogs.msdn.com)

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

Last week I worked with one of my co-workers from the Windows Platform Support group in a backup-related issue with SQL Server data files. We both learn several things because of that case and I think it is worth the time to share this information with you. read more...

add a comment |category: Database |Views: 4

tags: Database another

Model first + many to many = easy!(www.mindscape.co.nz)

submitted by traskjd(3229) 1 year, 7 months ago

Let's be frank, many-to-many relationships can be a bit more fiddly than they should be when working with them in a domain model. This post highlights how using a model first approach and generating the database from the model makes it easy to create many-to-many relationships, be it in SQL Server, Oracle, PostgreSQL, MySQL or most other relational database stores. read more...

add a comment |category: Database |Views: 200

tags: Database another

6 ways to import data into SQL Server(blogs.lessthandot.com)

submitted by SQL_Menace(4890) 2 years, 8 months ago

6 different ways are shown to import data from a file into SQL Server read more...

add a comment |category: Database |Views: 443

tags: SQLServer SQL Database another

Windows 7 Tricks and Keyboard Shortcuts (geekswithblogs.net)

submitted by sdorman(1415) 3 years ago

A summary of Windows 7 keyboard shortcuts and tips. read more...

add a comment |category: Tips & Tricks |Views: 585

tags: Tips another

My New Favorite Tool: OneNote(aspectdatasystems.com)

submitted by Boydski(101) 3 years ago

Review of Microsoft OneNote 2007 relating to the developer. read more...

3 comments |category: Products |Views: 633

tags: another

22 amazing JQuery - Modal - Plugins(blogrammierer.de)

submitted by blogrammierer(265) 3 years, 1 month ago

A collection of 22 amazing JQuery - Modal - Window - Plugins read more...

add a comment |category: jQuery |Views: 775

tags: jQuery another

Web Browser in C#(c-sharpcorner.com)

submitted by rohan123(740) 3 years, 1 month ago

The attached project is a Web Browser application created in C# 2.0. read more...

1 comment |category: C# |Views: 586

tags: C# another

Perform batch inserts in sql server 2005 using XML(raihaniqbal.org)

submitted by PrinceOfDhaka(390) 3 years, 1 month ago

My current project requires me to download huge amounts of data from a remote server in the form of XML and save them to our local database. Lets see if we can do this using just one simple T-SQL stored procedure. read more...

add a comment |category: Tips & Tricks |Views: 213

tags: Tips another

C# Design Patterns - The Visitor Pattern(geekdaily.net)

submitted by justinbezanson(1555) 3 years, 1 month ago

One principle that I really like is the Open/Closed principle which says that an object should be open to new functionality but closed to structural changes. The visitor pattern helps facilitate this principle by giving us the means to perform operations against an object without changing the objects structure. Looking back at a previous pattern we wanted to adjust the registration cost for a dog if they had been picked up by the dog catcher. read more...

add a comment |category: Patterns |Views: 595

tags: Patterns another

Introduction to JOINs - A simplest Visual Explanation of Join(blog.sqlauthority.com)

submitted by pinaldave(9662) 3 years, 1 month ago

Introduction to JOINs - A simplest Visual Explanation of Join This post is for every developer who just want to make sure that their basics of Join is perfect. Bookmark this for future use or for teaching your friends of Jr. about Joins. Blog about this post if you like it. read more...

2 comments |category: Database |Views: 536

tags: SQLAuthority pinaldave SQLServer Database SQL another

Learning the Template Pattern(dimecasts.net)

submitted by dwhittaker(13.1k) 3 years, 1 month ago

Taking a look at how you can use the Template Design Pattern in your applications. The Template Design Pattern is perhaps one of the most widely used and useful design pattern. It is used to set up the outline or skeleton of an algorithm, leaving the details to specific implementations later. This way, subclasses can override parts of the algorithm without changing its overall structure. read more...

add a comment |category: Architecture |Views: 424

tags: Dimecasts.net Architecture Patterns another

Logical Query Processing Phases - Order of Statement Execution(blog.sqlauthority.com)

submitted by pinaldave(9662) 3 years, 1 month ago

SQL SERVER -What actually sets SQL Server apart from other programming languages is the way SQL Server processes its code. Generally, most programming languages process statement from top to bottom. By contrast, SQL Server processes them in a unique order which is known as Logical Query Processing Phase. These phases generate a series of virtual tables with each virtual table feeding into the next phase (virtual tables not viewable). These phases and their orders are given as follows: read more...

add a comment |category: Database |Views: 193

tags: SQLAuthority pinaldave SQLServer Database SQL another

fn_virtualfilestats: Measure the I/O load on your disk system (sqlserveradvisor.blogspot.com)

submitted by sqlserveradvisor(385) 3 years, 2 months ago

Microsoft included the fn_virtualfilestats function in SQL Server so you can monitor the I/O load the instance executes on the disk subsystem. read more...

add a comment |category: Database |Views: 33

tags: T-SQL SQLServer Database another

How .NET Regular Expressions Really Work(moserware.com)

submitted by moserware(1665) 3 years, 2 months ago

A very deep dive into the source code for how .NET Regular Expressions really work read more...

3 comments |category: Regular Expressions |Views: 609

tags: RegEx another

SQL Server Enable Instant File Initialization(sqlserveradvisor.blogspot.com)

submitted by sqlserveradvisor(385) 3 years, 2 months ago

In SQL Server 2005 (and higher versions), data files can be initialized instantaneously. Instant file initialization reclaims used disk space without filling that space with zeros. Instead, disk content is overwritten as new data is written to the files... read more...

add a comment |category: Database |Views: 32

tags: Database another