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

submitted by spirit1(3140) 3 months, 25 days 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: 8

tags: SQLServer 2008 Database 2005 another

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

submitted by spirit1(3140) 6 months, 4 days 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: 12

tags: SQLServer 2008 Database 2005 another

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

submitted by spirit1(3140) 6 months, 12 days 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: 23

tags: SQLServer 2008 Database 2005 another

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

submitted by spirit1(3140) 6 months, 24 days 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: SQLServer 2008 Database 2005 another

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

submitted by spirit1(3140) 10 months, 1 day 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: 33

tags: SQLServer 2008 Database 2005 another

Advanced SQL Server 2005 Express Job Scheduling (weblogs.sqlteam.com)

submitted by spirit1(3140) 1 year, 2 months ago

How to make run once, daily, weekly, monthly absolute and relative scheduling in SQL Server Express 2005 and 2008 without any 3rd party tools. read more...

add a comment | category: Database | Views: 63

tags: SQLServer 2008 Database 2005 another

I KILL-ed you! Now can I go for a coffee break while you die? (weblogs.sqlteam.com)

submitted by spirit1(3140) 1 year, 3 months ago

Find out how long it will take for a rollback to complete in SQL Server with the help of a little know feature of the KILL keyword. read more...

add a comment | category: Database | Views: 12

tags: SQLServer 2008 Database 2005 another

OUTPUTing Data from the Just-Inserted, Updated, or Deleted Row(s) (scottonwriting.net)

submitted by atifaziz(990) 1 year, 3 months ago

Scott Mitchell discusses a little gem he discovered, which is the use of OUTPUT clause in INSERT, UPDATE, DELETE and MERGE (2008) DML statement to get the effect of in-place triggers and more. read more...

add a comment | category: Database | Views: 11

tags: SQLServer 2008 2005 Database SQL another

Custom user configurable SQL Server Profiler events (weblogs.sqlteam.com)

submitted by spirit1(3140) 1 year, 3 months ago

SQL Server Profiler is a well known tool for tracing different activity that happens between your server and the clients connected to it. But very few people know that you can have custom events and trace them in the SQL Server Profiler. read more...

add a comment | category: Database | Views: 16

tags: 2008 SqlProfiler SQLServer Database 2005 another

SSMS Tools PACK 1.1 - now with SSMS 2008 support (weblogs.sqlteam.com)

published 1 year, 3 months ago, submitted by spirit1(3140) 1 year, 4 months ago

With this new version you can use it for SQL Server Management Studio 2008 and SQL Server Management Studio 2008 Express. Plus some extra features. read more...

add a comment | category: Database | Views: 218

tags: SQLServer 2008 Database 2005 another

SQL Server 2005 Express Job Scheduling - Part 1 (weblogs.sqlteam.com)

submitted by spirit1(3140) 1 year, 5 months ago

SQL Server 2005 Express Job Scheduling with the help of Sql Server service broker and without 3rd party products. read more...

add a comment | category: Database | Views: 86

tags: SQLServer ServiceBroker Database 2005 another

SQL Server 2005 temporary tables bug, feature or expected behavior? (weblogs.sqlteam.com)

submitted by spirit1(3140) 1 year, 5 months ago

Some unexpected SQL Server behaviour around temporary tables that is good to know about. If it can be explained... read more...

1 comment | category: Database | Views: 17

tags: SQLServer 2005 Database another

SQL SERVER - 2005 - Difference Between INTERSECT and INNER JOIN (blog.sqlauthority.com)

published 1 year, 6 months ago, submitted by pinaldave(6378) 1 year, 6 months ago

INTERSECT operator in SQL Server 2005 is used to retrieve the common records from both the left and the right query of the Intersect Operator. INTERSECT operator returns almost same results as INNER JOIN clause many times. When using INTERSECT operator the number and the order of the columns must be the same in all queries as well data type must be compatible. Let us see understand how INTERSECT and INNER JOIN are related.We will be using AdventureWorks database to demonstrate our example. read more...

3 comments | category: Database | Views: 266

tags: SQL SQLAuthority pinaldave SQLServer Database another

Immediate deadlock notifications without changing existing code (weblogs.sqlteam.com)

submitted by spirit1(3140) 1 year, 6 months ago

In my previous post about immediate deadlock notifications in SQL Server 2005 I've shown a way to use a try catch block to get the deadlock error. The con of this method, although it uses best practice for error handling in SQL Server 2005, is that you have to change existing code and it doesn't work for non stored procedure code. And that IS a pretty BIG con! So here's a solution to this con. read more...

add a comment | category: Database | Views: 12

tags: SQLServer 2008 Database 2005 another

SQL Server 2005 bug when using LIKE searches (weblogs.sqlteam.com)

submitted by spirit1(3140) 1 year, 6 months ago

Here's a demo of a nice little bug in SQL Server 2005 when using LIKE comparisons for searching. What is so "nice" about it is that it only manifests itself if your search ends in number 9 followed by a wildcard when selecting only columns covered by a nonclustered index. read more...

add a comment | category: Database | Views: 15

tags: SQLServer 2005 Database another

Seup Your environment 4 WF with ASP.NET in VS 2005 (wfblogger.net)

submitted by thaisold(160) 1 year, 6 months ago

what you need to know to set up your environment to use workflow foundation while still using visual studio 2005 read more...

add a comment | category: Windows Workflow Foundation | Views: 15

tags: VisualStudio 2005 WWF ASP.NET another