<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Content with tag
SQL Server 2005
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...
By
Additional Articles
2009/11/05
|
Source:
SQL Server Performance
|
Category:
Integration Services (SSIS)
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...
By
Jesse Roberge
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
Lock and Connection Management
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
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
