<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)
SQL Server
(4)
CLR functions
(1)
PHP
(1)
SQL Server 2005 - SSIS
(102)
SQL Server 2000
(4)
CLR Stored Procedures
(1)
prime
(1)
Development
(68)
sys.allocation_units
(4)
CLR UDT
(1)
prime number
(1)
T-SQL
(57)
Backup / Restore
(3)
column
(1)
Procedure
(1)
SQL Server 7, 2000
(55)
BCP
(3)
columns
(1)
Product Reviews
(1)
Performance Tuning
(42)
Data Types
(3)
compact edition
(1)
proxy accounts
(1)
SQL Server 2005 - TSQL
(29)
Data Warehousing
(3)
Compression
(1)
Puzzle
(1)
Security
(28)
Jobs
(3)
Configuring
(1)
Queries
(1)
Maintenance and Management
(27)
Notification Services
(3)
copy_only
(1)
Query performance
(1)
SQL Server 2005 - Security
(27)
Service Packs
(3)
crossword
(1)
quotename
(1)
T-SQL Aids
(25)
Space Usage
(3)
Data Compression
(1)
Random Numbers
(1)
News
(21)
SQL Agent
(3)
Data directory
(1)
Reindex
(1)
Utility
(21)
SS2K5 - Full Text Searching
(3)
Data path
(1)
Remote Connection tool
(1)
Maintenance
(20)
SS2K5 Triggers
(3)
Database Files
(1)
Report Builder
(1)
Miscellaneous
(20)
2-Dimensional Arrays
(2)
Database Mail
(1)
Reporting
(1)
SQL Server 2008
(20)
Advanced
(2)
database options administration
(1)
Reporting System
(1)
SMO
(19)
auto-growth
(2)
Database Roles
(1)
Row Versioning
(1)
Indexing
(17)
Backups
(2)
database size
(1)
ROW_NUMBER()
(1)
Index Management
(16)
BLOB Manipulation
(2)
DDL Triggers
(1)
Running aggregate
(1)
Service Broker
(16)
books
(2)
Default settings
(1)
Running Totals
(1)
Integration Services (SSIS)
(14)
Buffer Cache
(2)
Defragment
(1)
Schema
(1)
Indexes
(13)
Common Language Runtime (CLR)
(2)
delete
(1)
script
(1)
SS2K5 - XML
(13)
data file management
(2)
Dependencies
(1)
Secure Programming
(1)
2005 Compact Edition
(12)
Database Design
(2)
DM_DB_Index_Physical_Stats
(1)
Selectivity
(1)
Advanced Querying
(12)
Database Mirroring
(2)
DROP
(1)
setup
(1)
SS2K5 - CLR Integration
(12)
database security
(2)
DTS
(1)
shrink
(1)
XML
(12)
DBCC
(2)
dump
(1)
Shrink Database
(1)
Analysis Services (SSAS)
(10)
Design and Theory
(2)
Duplicate Indexes
(1)
sieve
(1)
Disaster Recovery
(9)
DMV
(2)
dynamic
(1)
Size estimation
(1)
Monitoring
(9)
Excel
(2)
EBCDIC
(1)
Slowly Changing Dimensions
(1)
Strategies
(9)
Fragmentation
(2)
Embedded Edition
(1)
snapshot
(1)
powershell
(8)
games
(2)
ETL
(1)
solo
(1)
Reporting Services (SSRS)
(8)
Index Usage
(2)
Export
(1)
sp_msforeachdb
(1)
Search
(8)
Linked Server
(2)
Express Edition
(1)
sp_spaceused
(1)
Admin
(7)
Lock and Connection Management
(2)
extended procedures
(1)
SQL Server 6.5
(1)
Blogs
(7)
Log Shipping
(2)
Extended Stored Procedures
(1)
SQL Server Architecture
(1)
High Availability
(7)
MDX
(2)
File Exists
(1)
SQL University
(1)
nums
(7)
Namespaces
(2)
Files and Filegroups
(1)
SQL Server 2000
(1)
Replication
(7)
OpenXML
(2)
Foreign Key
(1)
SQL-DMO
(1)
SQL Server Express
(7)
paging
(2)
foreign key constraints
(1)
SQLSaturday
(1)
SQLInsider Scripts
(7)
Partitioned Tables
(2)
foreign keys
(1)
SSIS
(1)
sys.dm_db_partition_stats
(7)
Performance
(2)
Generate scripts
(1)
statistics
(1)
Table of Numbers
(7)
Permissions
(2)
Globalization
(1)
status
(1)
tables
(7)
report
(2)
Growth
(1)
Suspect Database
(1)
tally
(7)
Restore
(2)
growth trend
(1)
sybase linked server
(1)
Backup and Recovery
(6)
routine database growth
(2)
Hardware
(1)
Synonyms
(1)
counter
(6)
routine growth
(2)
HierarchyID
(1)
sys.columns
(1)
Encryption
(6)
SQL Server Management Studio (SSMS)
(2)
index maintenance
(1)
sys.dm_db_index_usage_stats
(1)
parse
(6)
SQL Server security
(2)
Index Tuning
(1)
sys.dm_db_missing_index_details
(1)
pivot
(6)
SQL Trace
(2)
Indexed Views
(1)
sys.dm_exec_connections
(1)
SS2K5 - Replication
(6)
SQLCLR
(2)
Information
(1)
sys.dm_exec_cursors
(1)
Storage
(6)
sys.dm_exec_query_plan
(2)
like
(1)
sys.dm_tran_session_transactions
(1)
Stored Procedures
(6)
sys.dm_exec_requests
(2)
Localization
(1)
sys.foreign_key_columns
(1)
Arrays
(5)
sys.dm_exec_sessions
(2)
Log directory
(1)
sys.foreign_keys
(1)
automated DBA
(5)
sys.dm_exec_sql_text
(2)
log file
(1)
sys.sql_modules
(1)
Clustering
(5)
sys.dm_os_buffer_descriptors
(2)
Log path
(1)
sys.systypes
(1)
Crosstab
(5)
sys.partitions
(2)
Logins
(1)
sys.tables
(1)
Delimited Strings
(5)
Sysobjects
(2)
Management Studio
(1)
syscolumns
(1)
List Indexes
(5)
Troubleshooting
(2)
Memory Management
(1)
System Development Life Cycle
(1)
Programming
(5)
Upgrade
(2)
Merge Replication
(1)
Table
(1)
SS2K5 - High Availability
(5)
XSL
(2)
Metadata
(1)
Table aliases
(1)
SS2K5 - Tools
(5)
Access
(1)
Microsoft Office
(1)
Table search
(1)
String Manipulation
(5)
ADO.NET
(1)
Mirroring
(1)
TDE
(1)
.Net
(4)
Aggregates
(1)
Missing Indexes
(1)
Time Range
(1)
Auditing
(4)
Alias
(1)
Naming Standards
(1)
Traces
(1)
Backup
(4)
ASCII
(1)
OLAP
(1)
TSQL
(1)
Data Mining
(4)
automatic
(1)
OLTP
(1)
VBScript
(1)
Extract, Transform, Load (ETL)
(4)
Backup directory
(1)
parameters
(1)
Video
(1)
FOR XML PATH
(4)
Backup path
(1)
Partitioned Views
(1)
whitespace
(1)
index
(4)
Best Practices
(1)
Partitioning
(1)
Windows Vista
(1)
Installation
(4)
Book Reviews
(1)
Passwords
(1)
Writing readable code
(1)
Management
(4)
bulk insert
(1)
Performance Monitoring
(1)
xp_sendmail
(1)
Profiler
(4)
Items 1 to 20 of 976
Next 20 >>
Generate stored procedure parameter list based on table
Generate stored procedure parameter list based on table, useful when creating new SPs on tables with lots of columns.
Read more...
By
Thomas Cournane
2009/12/04
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
18 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...
By
Additional Articles
2009/11/27
|
Source:
MSSQLTips.com
|
Category:
TDE
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2 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
|
23,060 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
|
1,870 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
|
23,022 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
|
Source:
SQLServerCentral.com
|
Category:
books
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
85 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
|
1,237 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
|
999 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
|
592 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,138 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,487 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,498 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,469 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
|
710 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
|
826 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,091 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,844 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
|
571 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,943 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,796 reads
Items 1 to 20 of 976
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,692 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,341 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,498 reads
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
