Articles

Fabiano Amorim is hooked on today's Integrated Development Environments with built-in Intellisense, so he looked forward keenly to SQL Server 2008's native intellisense. He was disappointed at how it turned out, so turned instead to SQL Prompt. Fabiano explains why he prefers to SQL Prompt, why he reckons it fits in with the way that database developers work, and goes on to describe some of the features he'd like to see in it

2010-04-09

4,030 reads

SQL Server 2008 Spatial Index Performance

by Additional Articles

MSSQLTips.com

Spatial Data

The institution I work with has decided to migrate their database system to SQL Server 2008. One of the applications uses geospatial data, which consists of millions of rows. I understand that their are indexes that can be used for geospatial data, but have not worked with them. What's the scoop on them?

2010-04-08

4,056 reads

Date Manipulation with DATEADD/DATEDIFF

by Seth Phelabaum

SQLServerCentral.com

Date Manipulation

Learn how to use Dateadd/Datediff functions to manipulate dates in this short article from Seth Phelabaum.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(113)

You rated this post out of 5. Change rating

2010-04-07

37,462 reads

Discuss

New and Improved Functionality in SSIS 2008

by Additional Articles

SQLServerCentral

Integration Services (SSIS)

While it does not bring revolutionary changes, the release of SQL Server 2008 delivers functionality, scalability, and performance improvements to SQL Server Integration Services (SSIS). Here is a comprehensive listing of new and enhanced features of SSIS with a short description of each.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2010-04-07

4,355 reads

Understanding Dynamic Management Views and Functions in SQL Server 2008

by Additional Articles

MSSQLTips.com

Performance monitoring and optimization is an inseparable part of a DBA's activities. To optimize a poorly performing system/query or to troubleshoot the performance issues you need to know the root cause. Prior to SQL Server 2005, we had several system tables to monitor the state of the system.

2010-04-06

2,169 reads

Working with Queues in SQL Server

by Ahmad Alkilani

SQLServerCentral.com

Queue processing

This article shows sow to create a queue from a SQL table to serve each operator exactly one item from the queue that has not been picked up by any other.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(37)

You rated this post out of 5. Change rating

2010-04-05

27,423 reads

Discuss

Celko's SQL Stumper: Eggs in one Basket

by Additional Articles

SimpleTalk

SQL Puzzles

Joe Celko returns with another stumper to celebrate Easter. Unsurprisingly, this involves eggs. More surprising is the nature of the puzzle: This time, the puzzle is one of designing a database rather than a query. DDL as well as the DML.

2010-04-05

2,337 reads

SQL Server Indexed Views

by Additional Articles

SQLServerCentral

Indexed Views

Views can be an effective tool for speeding up your selects and simplifying complex queries. Learn what indexed views are, where you might want to use them, how to create them, and what constraints exist with their use.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2010-04-05

5,000 reads

TSQL Challenge 27 - Identify overlapping weekly schedules of Nurses

by Press Release

SQLServerCentral.com

T-SQL Challenges

This challenge is related a scheduling problem in the home health care industry. The task is to look into the schedules of nurses and identify any overlapping schedules.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2010-04-05

2,580 reads

A High Level Comparison Between Oracle and SQL Server - Part IV

by Additional Articles

SQLServerCentral

Oracle

The concluding part of the Oracle / SQL Server comparison looks at error logging, security, installation and finally querying the databases.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2010-04-02

3,828 reads

Articles

SQL Server Intellisense VS. Red Gate SQL Prompt

SQL Server 2008 Spatial Index Performance

Date Manipulation with DATEADD/DATEDIFF

New and Improved Functionality in SSIS 2008

Understanding Dynamic Management Views and Functions in SQL Server 2008

Working with Queues in SQL Server

Celko's SQL Stumper: Eggs in one Basket

SQL Server Indexed Views

TSQL Challenge 27 - Identify overlapping weekly schedules of Nurses

A High Level Comparison Between Oracle and SQL Server - Part IV

Blogs

Programmatic Tool Calling with the Claude SDK

A New Word: Mauerbauertraurigkeit

Methodology for dealing with bad data in production

Forums

VACATION!

Alamat Kantor BCA KCU Wisma Asia Telp:08218200174

Alamat Kantor BCA KCU Kebayoran Baru Telp:08218200174

Question of the Day

BIT_COUNT() IV