WiX 3 Tutorial: Solution/Project structure and Dev resources(weblogs.sqlteam.com)

submitted by spirit1(3160) 2 years, 3 months ago

First in a series of WiX tutorials that shows the recommended WiX project structure and its properties and lists some other WiX development resources. read more...

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

tags: wix WindowsInstaller C# another

SQL Server - How to get the whole group of duplicate rows(weblogs.sqlteam.com)

submitted by spirit1(3160) 2 years, 7 months ago

A fast way how to get the whole duplicated group of rows in Sql Server 2005 and up. read more...

add a comment |category: Database |Views: 16

tags: Database SQLServer 2005 2008 another

Why I prefer surrogate keys instead of natural keys in database design(weblogs.sqlteam.com)

submitted by spirit1(3160) 2 years, 7 months ago

A practical field tested answer why are surrogate keys better than natural keys in database design. read more...

add a comment |category: Database |Views: 23

tags: SQLServer Design Database another

Why would Visual Studio build always rebuild a solution? (weblogs.sqlteam.com)

submitted by spirit1(3160) 2 years, 9 months ago

A simple problem with a weird solution. read more...

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

tags: VisualStudio another

The 24 hours of PASS - SQL Server live webcasts(weblogs.sqlteam.com)

submitted by spirit1(3160) 2 years, 9 months ago

This years biggest online SQL Server related event. It will last full 24 hours. Don't miss it! read more...

add a comment |category: Database |Views: 13

tags: Database SQLServer 2005 2008 another

SQL Server 2005 – Fast Running Totals solution with ordered CTE update(weblogs.sqlteam.com)

submitted by spirit1(3160) 2 years, 9 months ago

The Running Totals problem is as old as accounting. This is the fastest Running Totals solution using ordered Common Table Expressions (CTE) direct update feature in SQL Server 2005 and up. read more...

add a comment |category: Database |Views: 43

tags: Database SQLServer 2005 2008 another

How to check when was SQL Server installed with a T-SQL query(weblogs.sqlteam.com)

submitted by spirit1(3160) 2 years, 10 months ago

Sometimes you might want to check when was SQL Server installed witha query. this is how you do it. read more...

add a comment |category: Database |Views: 9

tags: Database SQLServer 2005 2008 another

Adding one file to multiple projects in a .Net solution(weblogs.sqlteam.com)

submitted by spirit1(3160) 2 years, 11 months ago

There are times when you want to have one .cs or any other file in multiple projects. This is how you do it. read more...

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

tags: VisualStudio C# another

SQL Server 2008 Extended Events - high performance eventing system(weblogs.sqlteam.com)

submitted by spirit1(3160) 2 years, 11 months ago

Extended Events are the new low level, high performance eventing system in SQL Server. They use less system resources and provide better tracking of SQL Server performance than previous methods like Perfmon and SQL Trace/Profiler events. read more...

1 comment |category: Database |Views: 19

tags: Performance SQLServer 2008 Database another

Free SQL Server 2008 Powerpoint dark template(weblogs.sqlteam.com)

submitted by spirit1(3160) 3 years ago

Just what the title says. read more...

add a comment |category: Database |Views: 36

tags: Presentation powerpoint Database another

Comparing SQL Server HASHBYTES function and .Net hashing(weblogs.sqlteam.com)

submitted by spirit1(3160) 3 years ago

Hashing comparison in .Net and SQL Server and things you have to be careful about. read more...

add a comment |category: Database |Views: 100

tags: SQLServer Database C# another

SQL Server - Find missing and unused indexes(weblogs.sqlteam.com)

submitted by spirit1(3160) 3 years, 1 month ago

How to find SQL Server indexes that should exists and those that shouldn't when performing index maintenance. read more...

add a comment |category: Database |Views: 43

tags: Database SQLServer 2005 2008 another

SSMS Tools Pack 1.5 is out with Window Connection Coloring(weblogs.sqlteam.com)

submitted by spirit1(3160) 3 years, 3 months ago

This new version of this popular SSMS add-in brings Window Connection Coloring feature and a few improved old features. read more...

add a comment |category: Database |Views: 210

tags: SSMS addin Database another

The day Google “died” and I used Live search for an hour(weblogs.sqlteam.com)

submitted by spirit1(3160) 3 years, 3 months ago

On Saturday 31st January 2009 at around 14:40 UTC something “historical” happened. Google stopped working for an hour. Every single search result was marked with “This site may harm your computer” and it redirected you to a warning site. read more...

add a comment |category: Other |Views: 19

tags: NothingOfValue NOT_DOTNET Google another

The simplest way to delete dupes and compare two result sets in SQL(weblogs.sqlteam.com)

submitted by spirit1(3160) 3 years, 4 months ago

The simplest and probably the fastest way to check for duplicates and compare 2 resultsets in SQL Server. read more...

add a comment |category: Database |Views: 20

tags: Database another

SSMS 2008 suggests missing indexes with actual execution plan(weblogs.sqlteam.com)

submitted by spirit1(3160) 3 years, 4 months ago

When you choose to Include the Actual Execution Plan in SSMS 2008 it suggest any missing indexes it thinks that are needed. Plus it also calculates the performance benefit from adding them. Pretty awsome! read more...

add a comment |category: Database |Views: 16

tags: 2008 SQLServer Database another