By tag: 2005
0
kicks
SQL Server - How to get the whole group of duplicate rows
A fast way how to get the whole duplicated group of rows in Sql Server 2005 and up.
0
kicks
The 24 hours of PASS - SQL Server live webcasts
This years biggest online SQL Server related event. It will last full 24 hours.
Don't miss it!
0
kicks
SQL Server 2005 – Fast Running Totals solution with ordered CTE update
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.
0
kicks
How to check when was SQL Server installed with a T-SQL query
Sometimes you might want to check when was SQL Server installed witha query. this is how you do it.
0
kicks
SQL Server - Find missing and unused indexes
How to find SQL Server indexes that should exists and those that shouldn't when performing index maintenance.
0
kicks
Advanced SQL Server 2005 Express Job Scheduling
How to make run once, daily, weekly, monthly absolute and relative scheduling in SQL Server Express 2005 and 2008 without any 3rd party tools.
0
kicks
I KILL-ed you! Now can I go for a coffee break while you die?
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.
0
kicks
OUTPUTing Data from the Just-Inserted, Updated, or Deleted Row(s)
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.
0
kicks
Custom user configurable SQL Server Profiler events
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.
0
kicks
SSMS Tools PACK 1.1 - now with SSMS 2008 support
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.
0
kicks
SQL Server 2005 Express Job Scheduling - Part 1
SQL Server 2005 Express Job Scheduling with the help of Sql Server service broker and without 3rd party products.
0
kicks
SQL Server 2005 temporary tables bug, feature or expected behavior?
Some unexpected SQL Server behaviour around temporary tables that is good to know about. If it can be explained...
0
kicks
SQL SERVER - 2005 - Difference Between INTERSECT and INNER JOIN
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...
0
kicks
Immediate deadlock notifications without changing existing code
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 ...
0
kicks
SQL Server 2005 bug when using LIKE searches
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.