Error!
Success!

By tag: 2005

showing:  of
0
kicks

SQL Server - How to get the whole group of duplicate rows  (Unpublished)

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


Kicked By:
Drop Kicked By:
0
kicks

The 24 hours of PASS - SQL Server live webcasts  (Unpublished)

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


Kicked By:
Drop Kicked By:
0
kicks

SQL Server 2005 – Fast Running Totals solution with ordered CTE update  (Unpublished)

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.


Kicked By:
Drop Kicked By:
0
kicks

How to check when was SQL Server installed with a T-SQL query  (Unpublished)

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


Kicked By:
Drop Kicked By:
0
kicks

SQL Server - Find missing and unused indexes  (Unpublished)

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


Kicked By:
Drop Kicked By:
0
kicks

Advanced SQL Server 2005 Express Job Scheduling  (Unpublished)

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


Kicked By:
Drop Kicked By:
0
kicks

I KILL-ed you! Now can I go for a coffee break while you die?  (Unpublished)

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.


Kicked By:
Drop Kicked By:
0
kicks

OUTPUTing Data from the Just-Inserted, Updated, or Deleted Row(s)  (Unpublished)

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.


Kicked By:
Drop Kicked By:
0
kicks

Custom user configurable SQL Server Profiler events  (Unpublished)

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.


Kicked By:
Drop Kicked By:
0
kicks

SSMS Tools PACK 1.1 - now with SSMS 2008 support  (Unpublished)

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.


Kicked By:
Drop Kicked By:
0
kicks

SQL Server 2005 Express Job Scheduling - Part 1  (Unpublished)

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


Kicked By:
Drop Kicked By:
0
kicks

SQL Server 2005 temporary tables bug, feature or expected behavior?  (Unpublished)

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


Kicked By:
Drop Kicked By:
0
kicks

SQL SERVER - 2005 - Difference Between INTERSECT and INNER JOIN  (Unpublished)

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...


Kicked By:
Drop Kicked By:
0
kicks

Immediate deadlock notifications without changing existing code  (Unpublished)

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 ...


Kicked By:
Drop Kicked By:
0
kicks

SQL Server 2005 bug when using LIKE searches  (Unpublished)

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.


Kicked By:
Drop Kicked By: