Additional Articles

SQL Server Intellisense VS. Red Gate SQL Prompt

by Additional Articles

SimpleTalk

SQL PROMPT

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

New and Improved Functionality in SSIS 2008

by Additional Articles

Database Journal

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.

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

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

Database Journal

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.

2010-04-05

5,000 reads

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

by Additional Articles

SQL Server Performance

Oracle

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

2010-04-02

3,828 reads

Busy Work

by Additional Articles

SQLServerCentral.com

humor

Run this fun script when you're bored.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(9)

You rated this post out of 5. Change rating

2010-04-01 (first published: 2010-03-31)

4,378 reads

Discuss

Insider Insights

by Additional Articles

SimpleTalk

humor

Insider rumours and gossip from the murky world of the Database Industry, and from the colourful characters that inhabit it.

2010-04-01

2,611 reads

SQL Server 2008 - Accessing Audit Details

by Additional Articles

Database Journal

Auditing

Learn how to use the SQL Server 2008 catalog view and dynamic management view to access the audit details of existing server and database level audits.

2010-03-31

2,478 reads

All authors

Additional Articles

SQL Server Intellisense VS. Red Gate SQL Prompt

SQL Server 2008 Spatial Index Performance

New and Improved Functionality in SSIS 2008

Understanding Dynamic Management Views and Functions in SQL Server 2008

Celko's SQL Stumper: Eggs in one Basket

SQL Server Indexed Views

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

Busy Work

Insider Insights

SQL Server 2008 - Accessing Audit Details

Blogs

A New Word: on tenderhooks

Ramblings about data communities and your contributions, no excuses

SQL Server Journey till 2025 (brief)

Forums

Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)

Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE

Having a Little Fun at SQL Server Central

Question of the Day

String Similarity I