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

Content with tags SQL Server 2008, SQL Server 2005 Rss

<< Newer    Items 41 to 57 of 57   
 

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 | 3,013 reads

Sending E-mail from SQL Server 200X

From monitoring e-mail messages to distributing reports for users, SQL Server's database mail proves quite useful. Learn how to use it in SQL Server 2000 and SQL Server 2005/2008.   Read more...
By Additional Articles 2009/07/01 | Source: DevX | Category: database mail
Rating:  Rate this |   Briefcase | 4,360 reads

Copy Only Backup for SQL 2005 and SQL 2008

Is there any way that my ad hoc backups will not interrupt the sequence of my backup plan?  Read more...
By Additional Articles 2009/06/30 | Source: MSSQLTips.com | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 3,271 reads

SQL Server Stumpers, Vol.5

Whether practicing for an exam or interview, or just wanting to see who's got the biggest SQL Server brain in your office, this book is perfect. Containing 100 SQL Server Central Questions of the Day, this book is a great way to test yourself and increase your knowledge.  Read more...
By Steve Jones 2009/06/03 | Source: SQLServerCentral.com | Category: books
Rating: (not yet rated) |  Discuss |   Briefcase | 2,672 reads

What mechanism allows SQL Server 2008 to commit transactions on the mirror faster than SQL Server 2005?

Question: What mechanism allows SQL Server 2008 to commit transactions on the mirror faster than SQL Server 2005? This question was asked on a technical discussion group. My reply follows.  Read more...
By Robert Davis 2009/05/19 | Source: SQLServerCentral.com | Category: blogs
Rating:  Rate this |   Briefcase | 2,587 reads

Cluster Information

This script will display information about the instance(s) on your cluster. Name of nodes, active node and drive letters of the resources  Read more...
By Rudy Panigas 2009/05/08 | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 1,251 reads

Accessing SQL Server Databases with PHP

The SQL Server 2005 Driver for PHP is a Microsoft-supported extension of PHP 5 that provides data access to SQL Server 2005 and SQL Server 2008. The extension provides a procedural interface for accessing data in all editions of SQL Server 2005 and SQL Server 2008. The SQL Server 2005 Driver for PHP API provides a comprehensive data access solution from PHP, and includes support for many features including Windows Authentication, transactions, parameter binding, streaming, metadata access, connection pooling, and error handling.  Read more...
By Additional Articles 2009/04/29 | Source: TechNet Blogs | Category: php
Rating: (not yet rated)  Rate this |   Briefcase | 1,783 reads

SSIS File Exists Over Range of Time

The process to use a vb script task to check for a file existence over a time range.  Read more...
Rating: |  Discuss |   Briefcase | 5,534 reads

Clustered SQL Server 2005/2008 Installation Using Mount Points

If you are in a clustered environment, check out this article from James Greaves. Here we learn how to deal with the clustered disk space and mount points.  Read more...
By James Greaves 2009/03/19 | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 6,113 reads

Stored procedures to implement paging for large tables or queries in SQL Server 2005 and SQL Server 2008

A tip from MSSQLTips that shows a few ways for implementing paging on large tables.  Read more...
By Additional Articles 2009/03/12 | Source: SQLServerCentral.com | Category: paging
Rating: (not yet rated)  Rate this |   Briefcase | 5,132 reads

Restore a SQL Server 2008 Database into SQL Server 2005

You likely will need to test data against SQL Server 2008 and SQL Server 2005, but ordinary backups are incompatible. Use SQL Server 2008's Generate SQL Server Scripts Wizard to push your SQL Server 2008 data back into SQL Server 2005.   Read more...
By Additional Articles 2009/01/26 | Source: DevX | Category: sql server 2008
Rating:  Rate this |   Briefcase | 3,500 reads

Proxy Accounts in SQL Server

Yan Pan explains how to set up proxies in SQL Server 2000, 2005 and 2008, and compares the differences between them  Read more...
By Additional Articles 2008/12/30 | Source: Database Journal | Category: proxy accounts
Rating: (not yet rated)  Rate this |   Briefcase | 3,483 reads

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: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 30,803 reads

SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes and Times)

SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008  Read more...
By Kevin van der Merwe 2011/05/30 (first published: 2008/05/05) | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 22,134 reads

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014.  Read more...
By Ola Hallengren 2014/10/20 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 43,706 reads

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014.  Read more...
By Ola Hallengren 2014/10/20 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 43,706 reads

New Data Types in SQL Server 2008 Part 2

In this article, we are going to explore the new HierarchyID data type. We are going to show how to implement hierarchies in SQL Server 2005 and than how same thing in can be achived in SQL Server 2008 using the HierarchyID data type.  Read more...
By Additional Articles 2008/02/20 | Source: SQL Server Performance | Category: data types
Rating:  Rate this |   Briefcase | 3,852 reads
<< Newer    Items 41 to 57 of 57   
 
Tags
blogs (7)    
security (7)    
t-sql (7)    
sql server 2000 (5)    
internals (4)    
optimizer (4)    
sql server (4)    
undocumented (4)    
backup / restore (3)    
database security (3)    
integration services (ssis) (3)    
jobs (3)    
performance tuning (3)    
sql server 2008 r2 (3)    
apply (2)    
books (2)    
clustering (2)    
database mail (2)    
sql agent (2)    
sql server 7 (2)    
sql server architecture (2)    
status (2)    
administration (1)    
auditing (1)    
backup (1)    
compression (1)    
conferences/user groups (1)    
copy_only (1)    
data types (1)    
database mirroring (1)    
database trigger (1)    
ddl (1)    
ddl triggers (1)    
event notifications (1)    
file exists (1)    
hierarchyid (1)    
index maintenance (1)    
indexing (1)    
information (1)    
information_schema (1)    
integrity check (1)    
large data sets (1)    
logshipping (1)    
maintenance (1)    
paging (1)    
parameters (1)    
permissions (1)    
php (1)    
presenting (1)    
professional development (1)    
professional organization for sql server (1)    
proxy accounts (1)    
row_number() (1)    
server trigger (1)    
service broker (1)    
smo (1)    
sql server 2012 (1)    
sql server 2014 (1)    
sql university (1)    
sqlsaturday (1)    
statistics (1)    
stored procedures (1)    
syscolumns (1)    
sysobjects (1)    
time range (1)    
tools (1)    
top (1)    
training (1)    
upgrading (1)    
vbscript (1)    
windows security (1)    
xp_sendmail (1)