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

Articles with tag SQL Server 2005 Rss

Search for any content tagged sql server 2005

<< Newer    Items 41 to 60 of 763    Older >>
 

Convert String to a Table using CTE

Explains how to convert a list of Ids passed as string and convert it to a table  Read more...
By Amit Gaur 2009/12/14 | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 12,764 reads

How to simulate transparent data encryption (TDE) with SQL 2000 and 2005

Encryption of data at rest is becoming more and more crucial in today’s world. This tip is aimed to help businesses that do not have the budgets or resources to purchase hardware encryption tools or to upgrade to SQL 2008. It basically illustrates how to achive transparent file encryption with SQL 2005 or SQL 2000.  Read more...
Rating:  Rate this |   Briefcase | 3,052 reads

Undocumented Extended and Stored Procedures

Some useful undocumented extended and stored procedures in SQL Server 2005  Read more...
By Timothy A Wiseman 2009/11/20 (first published: 2008/05/09) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 30,198 reads

Why We Recommend Against xp_cmdshell

Every so often I see a post in a forum or on Twitter about the use of xp_cmdshell. Usually it is someone looking for...  Read more...
By 2009/11/19 | Source: SQLServerCentral.com | Category: blogs
Rating:  Rate this |   Briefcase | 6,833 reads

The Best of SQLServerCentral, Vol.7

The seventh volume in this collection brings you a compilation of the best articles we've seen over the past year, from over 50 authors.   Read more...
By Steve Jones 2009/11/12 | Source: SQLServerCentral.com | Category: books
Rating: (not yet rated) |  Discuss |   Briefcase | 5,426 reads

Tuning SQL Server 2005 Integration Services for EBCDIC Data Conversion

Loading EBCDIC data into SQL Server is not a well documented process - this article provides a very useful guide to optimizing the performance of this operation.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,683 reads

SQL University: Multiple Paths and Ownership Chaining

Welcome back to our last class this term on security in SQL Server here at SQL University. According to the syllabus,...  Read more...
By 2009/11/03 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,630 reads

TechNet Magazine - Oct Q&A

Unexpected Consistency Checks, Troubleshooting Memory Usage, More from Paul Randal.  Read more...
By Additional Articles 2009/10/27 | Source: TechNet Blogs | Category: dbcc
Rating: (not yet rated)  Rate this |   Briefcase | 1,568 reads

SQL Server 2005 Build List

Build List Updated with SP3 CU14 and SP4 CU3.   Read more...
By Steve Jones 2011/03/24 (first published: 2007/04/23) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 114,682 reads

SQL Server Legend – Data Files and Threads

Someone was asking about using multiple data files recently to try and increase performance. I had answered that unless you...  Read more...
By Steve Jones 2009/10/20 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,960 reads

How to Dynamically and Iteratively Populate An Excel Workbook from SQL Server

Integration Services is a great ETL tool, allowing you to build complex and dynamic transformations. New author Marie Deschene brings us a  Read more...
By M. Deschene 2009/10/16 (first published: 2008/01/09) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 53,477 reads

Generating Database Objects Scripts in SQL Server 2005

SQL Server Management Studio provides a wizard to generate script out of a database. Learn how to automate the process to generate and store the database script.  Read more...
By Additional Articles 2009/10/12 | Source: Database Journal | Category: sql server 2005
Rating: (not yet rated)  Rate this |   Briefcase | 3,213 reads

SQL Server 2005 Index Best Practices

In continuing with our series of tips on Best Practices for SQL Server I'm turning my sights on Maintenance. Specifically in this tip we will be discussing Index maintenance: when, if, why, and how are questions that will be addressed.  Read more...
By Additional Articles 2009/10/09 | Source: MSSQLTips.com | Category: sql server 2005
Rating: (not yet rated)  Rate this |   Briefcase | 6,789 reads

Collecting Query Statistics for SQL Server 2005

With SQL Server 2005 DMVs, we can easily find query performance statistics. Every DBA has a favorite script to find query performance stats. I also have one. But, are all the queries captured by the DMVs? In this tip I will walk through capturing some of this data and show what is capture and what is not captured by the DMVs.  Read more...
By Additional Articles 2009/10/05 | Source: MSSQLTips.com | Category: statistics
Rating:  Rate this |   Briefcase | 4,316 reads

Deleting Large Number of Records

Often someone will try to perform a delete on a large number of records and run into a number of problems. Slow performance, log growth, and more. Lynn Pettis shows us how to better handle this situation in SQL Server 2000 and SQL Server 2005  Read more...
By Lynn Pettis 2011/02/18 (first published: 2009/09/15) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 49,185 reads

Issue with SQL Server 2K5 SP3 CU5

In case you are considering to apply SQL Server SP3 CU5 (http://support.microsoft.com/kb/972511) to your system, I'd like to point out one issue / bug we found with CU5.  Read more...
By Jeffrey Yao 2009/09/15 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,487 reads

A Failed Jobs Monitoring System

One DBA's tale of how to monitor jobs for failure and ensure that the DBA is alerted to the fact that there is a problem. (from Feb 2008)  Read more...
By TJay Belt 2009/09/04 (first published: 2008/02/05) | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 22,403 reads

Scripting in SSIS

Tim Mitchell presented at SQLSaturday #17 on Scripting in SSIS. I thought it was a really interesting presentation, and I’m...  Read more...
By Steve Jones 2009/08/07 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,968 reads

SQL Server 2005 Performance Dashboard Using SSRS

A first look at the Performance Dashboard in SQL Server 2005 by new author Robert Griffin.  Read more...
By Robert Griffin 2010/12/03 (first published: 2009/07/29) | Source: SQLServerCentral.com | Category: performance dashboard
Rating: |  Discuss |   Briefcase | 27,764 reads

Failing SQL 2005 Cluster Installation because of too many cpu's

A Failing cluster installation because of too many processors. Sander Stad explains how you might be able to solve this in your environment.  Read more...
By Sander Stad 2009/07/14 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 3,992 reads
<< Newer    Items 41 to 60 of 763    Older >>