Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Advanced Rss

Search for any content tagged advanced

   Items 1 to 20 of 63    Older >>
 

The Basics of Sizing a SQL Server Database

Sizing a database can be one of the most arduous tasks a DBA, analyst or developer must attend to. It?s time consuming and more hours go into analyzing the database than actually sizing it. This article focuses on how to monitor the database?s growth after its deployed and contains some tips on how to size it before deployment. We will also dive a little into how to benchmark your database against a robust data load.   Read more...
By Brian Knight 2008/08/01 (first published: 2001/07/25) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 39,954 reads

Worst Practices - Not Using Primary Keys and Clustered Indexes

Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!   Read more...
By Andy Warren 2008/05/09 (first published: 2003/11/10) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 65,876 reads

Storing IPs in SQL Server

An IP address is something we all recognize and is a piece of data that is quite prevalent in many systems. However it is a piece of data tha presents some challenges in its storage and retrieval. SQL Server guru David Poole presents us with a look at how you can work with this strange formatting.   Read more...
By David Poole 2007/04/02 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 13,959 reads

Table Defaults

In working on an existing database, DBAs often look to normalize tables and correct obvious flaws in design. Recently Andy Warren was working on a consulting project and realized that defaults would prevent many issues.   Read more...
By Andy Warren 2007/01/04 | Source: SQLServerCentral.com | Category: advanced
Rating: |  Discuss |   Briefcase | 7,157 reads

SQL Stored Procedure to Log Updates, Independent of Database Structure

How many DBAs need a solution to track those changes made for multiple systems? Auditing is becoming more and more prevalent in all systems and having a good solution can really make your DBA job interesting. New author Keren Ramot brings us his technique that works indepedent of the database structure.   Read more...
By Keren Ramot 2007/02/12 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 17,639 reads

Designing Cross Database Queries

As systems get bigger, servers consolidated, and SQL Server back ends more types of applications, the need for cross database queries for reports, updates, and more will continue to grow. Steve Jones looks at a few ways that you can design your linkages and talks about why he prefers one over the other.   Read more...
By Steve Jones 2007/10/19 (first published: 2005/03/09) | Source: SQLServerCentral.com | Category: advanced
Rating: |  Discuss |   Briefcase | 31,317 reads

Enterprise Architecture: Connect-the-Dots for Adults

Developing an enterprise architecture can be viewed as connect-the-dots for adults. However, in doing so, all you get is a pretty picture and not a management tool that can help an organization understand and manage itself.  Read more...
By Additional Articles 2007/10/04 | Source: TDAN | Category: advanced
Rating: (not yet rated)  Rate this |   Briefcase | 2,289 reads

Dynamic Partitioning and Dynamic Indexing

We are always searching for new ways to improve the performance of our database systems. Raghavendra Narayana brings us a new article that examines an idea for rebuilding partitions and indexes based on data access: in real time!   Read more...
By Narayana Raghavendra 2007/09/26 | Source: SQLServerCentral.com | Category: advanced
Rating: |  Discuss |   Briefcase | 4,171 reads

Reduce Aggravating Aggregation: Improve the Performance of History or

Optimize the performance of a database which includes history or status tables.  Read more...
By Additional Articles 2007/09/13 | Source: SQL Server Performance | Category: advanced
Rating:  Rate this |   Briefcase | 2,155 reads

Why Data Models Do Not Work: The Role of Reference Data

There is an urgent need to acknowledge the limitations of data models and find a way to bridge the logical-physical divide between models and actual databases so that database designs can be fully understood.  Read more...
By Additional Articles 2007/09/13 | Source: TDAN | Category: advanced
Rating:  Rate this |   Briefcase | 2,669 reads

SqlCredit Part 7: Performance Impact of EncryptByCert and DecryptByCer

Part 7 of our "Developing a Complete SQL Server OLTP Database Project" discusses performance issues resulting from using EncryptByCert and DecryptByCert. Read the article and download the code to run the test yourself.  Read more...
By Additional Articles 2007/08/28 | Source: Database Journal | Category: advanced
Rating:  Rate this |   Briefcase | 1,507 reads

SqlCredit Part 6: Exploring EncryptByCert and DecryptByCert

SQL Server 2005 includes support for encrypting and decrypting data for storage using EncryptByCert. Let’s look at how to implement this in the SqlCredit database.  Read more...
By Additional Articles 2007/08/24 | Source: Database Journal | Category: advanced
Rating:  Rate this |   Briefcase | 1,904 reads

Close These Loopholes in Your Database Testing

Alex Kuznetsov starts off a series of three articles on 'Unit Testing' your database development work. He begins by describing five simple rules that make all the difference.   Read more...
By Additional Articles 2007/08/20 | Source: SimpleTalk | Category: advanced
Rating:  Rate this |   Briefcase | 2,700 reads

A Love Hate Affair with User Defined Types

Many new DBAs think that User-defined types are a very cool feature in SQL Server when they first encounter them. However many experienced DBAs soon realize that UDTs can be a pain to work with and longtime SQL Server guru David Poole discusses his experiences   Read more...
By David Poole 2007/07/23 | Source: SQLServerCentral.com | Category: advanced
Rating: |  Discuss |   Briefcase | 6,399 reads

Foreign Keys and their States

In this article, we will examine some rarely explored areas that concern foreign keys; in particular, we will look at disabled and un-trusted foreign keys.   Read more...
By Additional Articles 2007/06/29 | Source: SimpleTalk | Category: advanced
Rating:  Rate this |   Briefcase | 2,772 reads

Enforce Business Rules for All Your Data with Constraints

The only way to guarantee that your business rules are always enforced for all your data is by using constraints. Learn how to use them to enforce business rules in the database.  Read more...
By Additional Articles 2007/06/05 | Source: DevX | Category: advanced
Rating:  Rate this |   Briefcase | 2,758 reads

Using Views to Enforce Business Rules

A view is most commonly thought of as a SELECT statement. Most developers will simply create a view to "group" complex SELECT statements for reuse within another view or stored procedures. It makes typing easier! But the really power of views is their ability to implement business rules.  Read more...
By Additional Articles 2007/04/23 | Source: SQLTeam.com | Category: advanced
Rating:  Rate this |   Briefcase | 4,169 reads

Dynamic Images and Databases

Should you store dynamically generated web-site graphics in a database or is the file system the better option? Dino illustrates how to make this decision in ASP.NET  Read more...
By Additional Articles 2007/04/17 | Source: Dr. Dobbs | Category: .net
Rating:  Rate this |   Briefcase | 3,343 reads

Sic Semper NULL

The great debate over NULLs will probably never end. Should we use them in our databases? What meaning do they have? These are all valid questions. In this article SQL Server expert Michael Coles takes a look at the problems that are inherent in eliminating NULLs completely from a database.   Read more...
By Michael Coles 2007/04/10 | Source: SQLServerCentral.com | Category: advanced
Rating: |  Discuss |   Briefcase | 5,870 reads

Storing IPs in SQL Server

An IP address is something we all recognize and is a piece of data that is quite prevalent in many systems. However it is a piece of data tha presents some challenges in its storage and retrieval. SQL Server guru David Poole presents us with a look at how you can work with this strange formatting.   Read more...
By David Poole 2007/04/02 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 13,959 reads
   Items 1 to 20 of 63    Older >>