Friday, July 25, 2014
 
  SQL SERVER BEST PRACTICES, WHITEPAPERS AND ARTICLES
Permalink
Thumbnail
Understanding Transact-SQL Cursors
Author :: Nyssa Rogers
Date :: Wed 02/02/2011 @ 12:02

Post by: Nyssa Rogers
Some developers use them, and some developers think they're the worst thing since the plague. But what are they?

Here's a basic overview of how to declare cursors and perform basic fetches for procedures that need to look at data one line at a time rather than as a set.


read article
RATING:   COMMENTS (0)
Permalink
Thumbnail
Migrating from Oracle, MySQL, SYBASE, Access to Microsoft SQL Server
Author :: Adrian Claxton
Date :: Sat 12/18/2010 @ 05:11
Let’s talk a little bit about migration when it comes to DBMS of the relational model. Migration is a process of moving data and applications from one operating environment to another operating environment. Such environments are relational database management systems for small businesses to enterprise server database management systems for large organizations. Examples of these environments are Oracle, MySQL, SYBASE, Visual FoxPRO, and Microsoft Access. All of these applications can be migrated to Microsoft SQL Server.

read article
RATING:   COMMENTS (0)
Permalink
Thumbnail
Understanding Transact-SQL Triggers
Author :: Jun Wong
Date :: Sat 12/18/2010 @ 05:07
Triggers are a part of SQL Server that provides an important set of features that can be utilized for a variety of programming needs. It is essentially a special type of stored procedure that runs when a particular event occurs in the database server.  

read article
RATING:   COMMENTS (0)
Permalink
Thumbnail
Understanding SQL Server in a Windows Server 2-Node Cluster using MS Virtual Server
Author :: Alberto Ortoll
Date :: Sat 12/18/2010 @ 05:00

 

The purpose of this paper is to serve as a walk-through on how to practically setup a two-node cluster, and install Windows SQL Server on it. Before we start to talk about the prerequisites and architecture, I want to cover a few technology terms to clarify any questions that you may have.


read article
RATING:   COMMENTS (0)
Permalink
Thumbnail
Dead Locks and Concurrency Issues
Author :: Chun-Ming Chen
Date :: Sat 12/18/2010 @ 04:56
Concurrency
Concurrency is an ability that allows multiple users to access the same data at the same time.   However as more users access the data at the same time, the greater the chance for users to change the same set of data at the same time and overwrite each other’s input. The integrity of the data is compromised without the users initiating the operations knowing it. There are four types of concurrency problems:

·       Lost updates
·       Dirty reads (uncommitted dependencies)
·       Nonrepeatable reads (inconsistent analysis)
·       Phantom reads

read article
RATING:   COMMENTS (0)
Permalink
Thumbnail
Query & Index Tuning using Dynamic Management Views
Author :: Brian D'Mello
Date :: Sat 12/18/2010 @ 04:50
This article discusses using general information about DMVs and specifically Index related DMVs that can be used to tune queries.
read article
RATING:   COMMENTS (0)
Permalink
Thumbnail
Understanding SQL Server Stored Procedures
Author :: Gary Mitchell
Date :: Sat 12/18/2010 @ 04:24
I chose Stored Procedures as a topic because, while Database Administration can be done without writing them, they are a key to automating many of the administration tasks. The intent is not to determine what can be automated or to cover the T-SQL language, but to cover some features and possible methodologies for stored procedures.

read article
RATING:   COMMENTS (0)
Permalink
Thumbnail
SQL Server Agent Job Calling SSIS Package Never Completes!
Author :: Saleem Hakani
Date :: Sat 12/18/2010 @ 04:20
In some situation, a SQL Agent job calling an SSIS package, never completes - neither fails nor succeeds, but keeps running - indefinitely. This article provides a solution for that.
read article
RATING:   COMMENTS (1)
Permalink
Thumbnail
Maintenance Plan SSIS Packages cause problems on the exported server
Author :: Manoj Deshpande
Date :: Sat 12/18/2010 @ 04:18
Most often - I would say always - we develop the solutions on the development server and they are then implemented on Production. No where I have seen this case that the solution is directly developed on the Production - might happen somewhere, but that's not the matter of discussion anyway :-)..
read article
RATING:   COMMENTS (0)
Permalink
Thumbnail
MAINTAINING DATABASE AVAILABILITY WITH SQL SERVER FEATURES
Author :: Silin Kuang
Date :: Mon 11/15/2010 @ 04:13

read article
RATING:   COMMENTS (0)
< BACK  1 of 2  NEXT >
HOME   |   Article Library   |   Scripts & Tools   |   Training Videos   |   Job Board   |   Resources
Copyright 2010 by SQLCOMMUNITY.COM