SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Content with tag SQL Server 2005 Rss

Refine your search with one of the following additional tags (with number of items):

Administration (182)     Profiler (4)     CLR UDT (1)     prime number (1)    
SQL Server 2005 - SSIS (102)     sys.allocation_units (4)     column (1)     Procedure (1)    
Development (68)     Backup / Restore (3)     columns (1)     Product Reviews (1)    
T-SQL (56)     BCP (3)     compact edition (1)     proxy accounts (1)    
SQL Server 7, 2000 (55)     Data Types (3)     Compression (1)     Puzzle (1)    
Performance Tuning (42)     Data Warehousing (3)     Configuring (1)     Queries (1)    
SQL Server 2005 - TSQL (29)     Jobs (3)     copy_only (1)     Query performance (1)    
Maintenance and Management (27)     Notification Services (3)     crossword (1)     quotename (1)    
SQL Server 2005 - Security (27)     Service Packs (3)     Data Compression (1)     Random Numbers (1)    
Security (26)     Space Usage (3)     Data directory (1)     Reindex (1)    
T-SQL Aids (25)     SQL Agent (3)     Data path (1)     Remote Connection tool (1)    
News (21)     SQL Server (3)     Database Files (1)     Report Builder (1)    
Utility (21)     SS2K5 - Full Text Searching (3)     Database Mail (1)     Reporting (1)    
Maintenance (20)     SS2K5 Triggers (3)     database options administration (1)     Reporting System (1)    
Miscellaneous (20)     2-Dimensional Arrays (2)     Database Roles (1)     Row Versioning (1)    
SMO (19)     Advanced (2)     database security (1)     ROW_NUMBER() (1)    
Indexing (17)     auto-growth (2)     database size (1)     Running aggregate (1)    
SQL Server 2008 (17)     Backups (2)     DDL Triggers (1)     Running Totals (1)    
Index Management (16)     BLOB Manipulation (2)     Default settings (1)     Schema (1)    
Service Broker (16)     Buffer Cache (2)     Defragment (1)     script (1)    
Integration Services (SSIS) (14)     Common Language Runtime (CLR) (2)     delete (1)     Secure Programming (1)    
Indexes (13)     data file management (2)     Dependencies (1)     Selectivity (1)    
SS2K5 - XML (13)     Database Design (2)     DM_DB_Index_Physical_Stats (1)     setup (1)    
2005 Compact Edition (12)     Database Mirroring (2)     DROP (1)     shrink (1)    
Advanced Querying (12)     DBCC (2)     DTS (1)     shrinkdatabase (1)    
SS2K5 - CLR Integration (12)     Design and Theory (2)     dump (1)     SHRINKFILE (1)    
XML (12)     DMV (2)     Duplicate Indexes (1)     sieve (1)    
Analysis Services (SSAS) (10)     Excel (2)     dynamic (1)     Size estimation (1)    
Disaster Recovery (9)     Fragmentation (2)     EBCDIC (1)     Slowly Changing Dimensions (1)    
Monitoring (9)     games (2)     Embedded Edition (1)     snapshot (1)    
Strategies (9)     Index Usage (2)     ETL (1)     solo (1)    
powershell (8)     Linked Server (2)     Export (1)     sp_msforeachdb (1)    
Reporting Services (SSRS) (8)     Lock and Connection Management (2)     Express Edition (1)     sp_spaceused (1)    
Search (8)     Log Shipping (2)     extended procedures (1)     SQL Server 6.5 (1)    
Admin (7)     MDX (2)     Extended Stored Procedures (1)     SQL Server Architecture (1)    
High Availability (7)     Namespaces (2)     File Exists (1)     SQL Server security (1)    
nums (7)     OpenXML (2)     Files and Filegroups (1)     SQL University (1)    
Replication (7)     paging (2)     Foreign Key (1)     SQL Server 2000 (1)    
SQL Server Express (7)     Partitioned Tables (2)     foreign key constraints (1)     SQL-DMO (1)    
SQLInsider Scripts (7)     Performance (2)     foreign keys (1)     SQLSaturday (1)    
sys.dm_db_partition_stats (7)     Permissions (2)     Generate scripts (1)     SSIS (1)    
Table of Numbers (7)     report (2)     Globalization (1)     statistics (1)    
tables (7)     Restore (2)     Growth (1)     status (1)    
tally (7)     routine database growth (2)     growth trend (1)     Suspect Database (1)    
Backup and Recovery (6)     routine growth (2)     Hardware (1)     sybase linked server (1)    
Blogs (6)     SQL Server 2000 (2)     HierarchyID (1)     Synonyms (1)    
counter (6)     SQL Server Management Studio (SSMS) (2)     index maintenance (1)     sys.columns (1)    
parse (6)     SQL Trace (2)     Index Tuning (1)     sys.dm_db_index_usage_stats (1)    
pivot (6)     SQLCLR (2)     Indexed Views (1)     sys.dm_db_missing_index_details (1)    
SS2K5 - Replication (6)     sys.dm_exec_query_plan (2)     Information (1)     sys.dm_exec_connections (1)    
Storage (6)     sys.dm_exec_requests (2)     like (1)     sys.dm_exec_cursors (1)    
Arrays (5)     sys.dm_exec_sessions (2)     Localization (1)     sys.dm_tran_session_transactions (1)    
automated DBA (5)     sys.dm_exec_sql_text (2)     Log directory (1)     sys.foreign_key_columns (1)    
Clustering (5)     sys.dm_os_buffer_descriptors (2)     log file (1)     sys.foreign_keys (1)    
Crosstab (5)     sys.partitions (2)     Log path (1)     sys.sql_modules (1)    
Delimited Strings (5)     Troubleshooting (2)     Logins (1)     sys.systypes (1)    
Encryption (5)     Upgrade (2)     Management Studio (1)     sys.tables (1)    
List Indexes (5)     XSL (2)     Memory Management (1)     Sysobjects (1)    
Programming (5)     Access (1)     Merge Replication (1)     System Development Life Cycle (1)    
SS2K5 - High Availability (5)     ADO.NET (1)     Metadata (1)     Table (1)    
SS2K5 - Tools (5)     Aggregates (1)     Microsoft Office (1)     Table aliases (1)    
Stored Procedures (5)     Alias (1)     Mirroring (1)     Table search (1)    
String Manipulation (5)     ASCII (1)     Missing Indexes (1)     Time Range (1)    
.Net (4)     automatic (1)     Naming Standards (1)     Traces (1)    
Auditing (4)     Backup directory (1)     OLAP (1)     TSQL (1)    
Backup (4)     Backup path (1)     OLTP (1)     VBScript (1)    
Data Mining (4)     Best Practices (1)     Partitioned Views (1)     Video (1)    
Extract, Transform, Load (ETL) (4)     Book Reviews (1)     Partitioning (1)     whitespace (1)    
FOR XML PATH (4)     books (1)     Passwords (1)     Windows Vista (1)    
index (4)     bulk insert (1)     Performance Monitoring (1)     Writing readable code (1)    
Installation (4)     CLR functions (1)     PHP (1)     xp_sendmail (1)    
Management (4)     CLR Stored Procedures (1)     prime (1)    
   Items 1 to 20 of 972    Next 20 >>
 

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 | 14,530 reads

SQL Server 2005 & 2008 - Backup, Integrity Check & Index Optimization

Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005 and SQL Server 2008. Updated 05 Sep 2009.  Read more...
By Ola Hallengren 0001/01/01 | Source: SQLServerCentral.com | Category: Backup / Restore
Rating: |  Discuss |  Briefcase | 22,098 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 | 943 reads

SQL Server 2005 - Work with Flat Files

It's a scripts about working with Flat Files  Read more...
By Luan Moreno M. Maciel 2009/11/03 | Source: SQLServerCentral.com | Category: ETL
Rating: |  Discuss |  Briefcase | 911 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 | 478 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 | Category: DBCC
Rating: (not yet rated)  Rate this |  Briefcase | 1,087 reads

The Ultimate Running Requests Reporter

Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.  Read more...
By Jesse Roberge 0001/01/01 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 2,324 reads

SQL Server 2005 Build List

Build List Updated with Cumulative Update 16 for SP2 and CU 6 for SP3.   Read more...
By Steve Jones 2009/10/26 (first published: 2007/04/23) | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 79,193 reads

The Ultimate Connection Summarizer and Trouble Finder

Reports summaries, in 3 levels of detail, connections, running requests, open transactions + cursors, and blocking. Provides query text + plan for the piggiest running request of each group.  Read more...
Rating: |  Discuss |  Briefcase | 4,373 reads

The Ultimate Table Searcher Mk2

Searches for tables who's names contain the search string. Gives Aggregate Size, Rows, Index, and Column information as well.  Read more...
By Jesse Roberge 2009/10/20 | Source: SQLServerCentral.com | Category: Administration
Rating: (not yet rated) |  Discuss |  Briefcase | 701 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 | 779 reads

The Ultimate Column Searcher

Searches for columns with names containing @Colname that belong to tables with names containing @TableName or schemas with names containing @SchemaName. Gives size and rowcount for tables.  Read more...
By Jesse Roberge 2009/10/16 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 1,079 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 | 46,325 reads

The Ultimate Index-Less Foreign-Key Finder

Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.  Read more...
By Jesse Roberge 2009/10/15 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 516 reads

The Ultimate Table Searcher

Searches for tables who's names contain the search string. Gives Size and Rows information as well.  Read more...
By Jesse Roberge 0001/01/01 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 1,932 reads

The Ultimate Foreign Key Researcher

Searches for actual and potential foreign key columns for a given primary key reference.  Read more...
By Jesse Roberge 0001/01/01 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 1,775 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 | 2,548 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 | 5,674 reads

The Ultimate Precompiled Procedure Searcher

Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.  Read more...
By Jesse Roberge 0001/01/01 | Source: SQLServerCentral.com | Category: SQL Server 2005
Rating: |  Discuss |  Briefcase | 1,595 reads

The Ultimate Object Searcher

Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.  Read more...
By Jesse Roberge 2009/10/06 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 600 reads
   Items 1 to 20 of 972    Next 20 >>
 
Most popular

Default trace - A Beginner's Guide

This article is the beginner's guide to Default Trace. The article outlines how to query the default trace for key trace events, with a focus on DDL history.  Read more...
By Adam Haines 2008/11/11 | Source: SQLServerCentral.com | Category: SQL Server 2005
Rating: |  Discuss |  Briefcase | 13,612 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 | 3,276 reads

SQL Server 2005 Build List

Build List Updated with Cumulative Update 16 for SP2 and CU 6 for SP3.   Read more...
By Steve Jones 2009/10/26 (first published: 2007/04/23) | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 79,193 reads