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

<< Previous 20    Items 41 to 52 of 52   
 

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,162 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 | Category: php
Rating: (not yet rated)  Rate this |   Briefcase | 1,739 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...
By Silver Pheonix 2009/03/31 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 5,452 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,036 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 | 4,896 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,419 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,259 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,772 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,064 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, and SQL Server 2012.  Read more...
By Ola Hallengren 2013/03/13 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 38,306 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, and SQL Server 2012.  Read more...
By Ola Hallengren 2013/03/13 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 38,306 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,697 reads
<< Previous 20    Items 41 to 52 of 52   
 
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)    
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 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)    
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.