Friday, September 03, 2010 Register   Login   
   You Are Here: Articles » SQL Server Articles (Categorized)      

Submit Articles  Upload Scripts   Submit Tips   Start a Blog   Upload Tools   Post Job Openings   Submit Your Resume   About SQL Community

 Article Category
  
  

To download resources, Please Login/Register

  
 SQL Server Articles
Share

 

Thumbnail
Writing A Transact SQL (TSQL) Procedure For SQL Server 2008 To Delete Rows From Table Safely
Author :: Peter Kellner
Date :: Thu 04/29/2010 @ 07:54

In this post, we will show and explain a small TSQL Sql Server 2008 procedure that deletes all rows in a table that are older than some specified date.  That is, say the table has 10,000,000 rows in it the accumulated over the past 2 years.

Say you want to delete all but the last 30 days of activity.  If you just simply say DELETE FROM table WHERE id>10000, you will cause this to happen in one transaction and likely, you will get an error.  That’s the best case.  The worst case is your system tries to do this, eventually consumes all the resources in your computer and crashes your server.


READ MORE ABOUT THIS POST
RATING:   
Thumbnail
Causes of Error 823 in SQL Server and How to Fix it
Author :: Naveen Kadian
Date :: Fri 03/12/2010 @ 03:59

Stellar Phoenix SQL Recovery is the most advanced and powerful utility that is able to effectively handle all database corruption scenarios. The software works well with Microsoft SQL Server 2008, 2005, and 2000. It restores all MDF file objects such as tables, reports, forms, constraints, stored procedures, triggers, data types, and more.


READ MORE ABOUT THIS POST
RATING:   
Thumbnail
SQL Server database corrupt post Unexpected Shutdown
Author :: Naveen Kadian
Date :: Tue 01/05/2010 @ 05:41

Stellar Phoenix SQL Recovery is one of the finest SQL Repair application that allows you to repair corrupt databases after almost all database corruption scenarios. The tool is designed for Windows 7, Vista, XP, 2003, 2000 and NT, and supports SQL Server 2008, 2005, and 2000.


READ MORE ABOUT THIS POST
RATING:   
Thumbnail
Error Messages while restoring the MS SQL Server database
Author :: Naveen Kadian
Date :: Sat 01/02/2010 @ 03:55

Stellar Phoenix SQL Recovery surmounts all other SQL Database Repair applications and provides you with desired results. Compatible with SQL Server 2008, 2005, and 2000, the repair utility incorporates effective scanning procedures to perform the repair process. It supports Windows 7, Vista, XP, 2003, 2000 and NT operating systems.


READ MORE ABOUT THIS POST
RATING:   
Thumbnail
How to Resolve “Database ID DB_ID, object 'OBJNAME' (ID O_ID)...”
Author :: Naveen Kadian
Date :: Mon 12/21/2009 @ 05:24

Stellar Phoenix SQL Recovery is a powerful tool that repairs corrupt databases and restores them on the user-specified location. Compatible with SQL Server 2008, 2005, and 2000, the software repairs almost all database objects including tables, views, rules, etc.


READ MORE ABOUT THIS POST
RATING:   
Thumbnail
Resolving “IAM page P_ID ... that should be in filegroupFG_ID2” Error Message
Author :: Naveen Kadian
Date :: Mon 12/14/2009 @ 04:34

Stellar Phoenix SQL Recovery is an advanced repair application that orderly repairs SQL database created in SQL Server 2008, 2005, and 2000 versions. Compatible with Windows 7, Vista, XP, 2003, 2000 and NT, the SQL Repair application recovers database objects like tables, stored procedures and views.


READ MORE ABOUT THIS POST
RATING:   
Thumbnail
How to Resolve “CHECKTABLE processing of object ID...” Error Message
Author :: Naveen Kadian
Date :: Sun 12/06/2009 @ 11:46

Stellar Phoenix SQL Recovery systematically repairs logically corrupted SQL Server 2008, 2005, and 2000 databases. The SQL Repair software recovers tables, stored procedures, views, and similar database components in just three simple steps. It supports Windows Vista, XP, 2003, 2000 and NT.


READ MORE ABOUT THIS POST
RATING:   
Thumbnail
Resolving “Forward row mismatch” Error message
Author :: Naveen Kadian
Date :: Fri 12/04/2009 @ 05:53

Stellar Phoenix SQL Recovery is one answer to all logically corrupted SQL databases. The SQL Repair software repairs SQL databases created in SQL Server 2008, 2005, and 2000 and recovers tables, stored procedures, views, and similar database components. The recovery tool is compatible with Windows Vista, XP, 2003, 2000 and NT.


READ MORE ABOUT THIS POST
RATING:   
Thumbnail
Database Suspect due to Problems while Transaction Commit
Author :: Naveen Kadian
Date :: Thu 12/03/2009 @ 05:45

Stellar Phoenix SQL Recovery is a professional SQL Repair software used by both technical and non-technical users. The software repairs database created in SQL Server 2008, 2005, and 2000 and recovers all database objects, such as, tables, stored procedures, views, etc.


READ MORE ABOUT THIS POST
RATING:   
Thumbnail
How to Resolve “Could not read and latch...” Error Message
Author :: Naveen Kadian
Date :: Wed 12/02/2009 @ 03:57

Stellar Phoenix SQL Recovery is a professional SQL Repair software used by both technical and non-technical users. The software repairs database created in SQL Server 2008, 2005, and 2000 and recovers all database objects, such as, tables, stored procedures, views, etc.


READ MORE ABOUT THIS POST
RATING:   

< PREVIOUS PAGE

  1 of 13  

NEXT PAGE >

Share
    
SQL Server  |  SQL Server Forums  |  Articles  |  Scripts/Tools  |  Tips & Tricks  |  Blogs  |  Job Board  |  Videos
Copyright 2007 by www.sqlcommunity.com    Terms Of Use   Privacy Statement