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 765    Older >>

Is It Worth Upgrading to SQL Server 2008

New author Nigel Maneffa brings us a look at SQL Server 2008 and its new features, trying to decide if it's worth the upgrade.  Read more...
By Nigel Maneffa 2009/12/18 (first published: 2008/10/21) | Source: | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 30,814 reads

Using a Certificate Signed Stored Procedure to Execute sp_send_dbmail

Learn how to create a certificate signed stored procedure to solve common permissions problems using sp_send_dbmail. MVP Jonathan Kehayias brings us a short tutorial that discusses your options and code to show you how to implement certificate security.  Read more...
By Jonathan Kehayias 2009/12/17 | Source: | Category: security
Rating: |  Discuss |   Briefcase | 8,210 reads

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: | Category: cte
Rating: |  Discuss |   Briefcase | 12,816 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,521 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: | Category: stored procedures
Rating: |  Discuss |   Briefcase | 30,502 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: | Category: blogs
Rating:  Rate this |   Briefcase | 7,071 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: | Category: books
Rating: (not yet rated) |  Discuss |   Briefcase | 5,961 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,746 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: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,867 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,656 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: | Category: administration
Rating: |  Discuss |   Briefcase | 115,704 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: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,103 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: | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 53,755 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,304 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: | Category: sql server 2005
Rating: (not yet rated)  Rate this |   Briefcase | 6,852 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: | Category: statistics
Rating:  Rate this |   Briefcase | 4,414 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: | Category: t-sql
Rating: |  Discuss |   Briefcase | 49,992 reads

Issue with SQL Server 2K5 SP3 CU5

In case you are considering to apply SQL Server SP3 CU5 ( 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: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,605 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: | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 22,487 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: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,139 reads
<< Newer    Items 41 to 60 of 765    Older >>