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

Content with tag SQL Server 2008 Rss

<< Newer    Items 21 to 40 of 438    Older >>
 

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

2008 Index Rebuild using DMV

Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.  Read more...
Rating: |  Discuss |   Briefcase | 1,575 reads

SQL Server 2008 Build List

The list of builds for SQL Server 2008 updated SP4.  Read more...
By Steve Jones 2013/01/30 (first published: 2008/09/26) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 56,869 reads

Logshipping Backup Files Management

Delete Log-shipping Tlog backup files which are already restored onto Secondary Server.  Read more...
By Vaibhav Mehta 2012/06/28 | Source: SQLServerCentral.com | Category: logshipping
Rating: |  Discuss |   Briefcase | 589 reads

Transaction Replication Publisher failover to Mirror

Transaction Replication Publisher failover/failback to mirror standby with automatic redirection of the subscriber and client application.  Read more...
By Paul Brewer 2012/06/28 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 2,400 reads

Change Tracking - 2008

Change tracking in SQL Server 2008 enables applications to obtain only changes that have been made to the user tables, along with the information about those changes.  Read more...
By Nitesh R Dedhia 2012/06/18 | Source: SQLServerCentral.com | Category: change tracking
Rating: |  Discuss |   Briefcase | 7,446 reads

SQL Server 2008 Build List

The list of builds for SQL Server 2008 updated SP4.  Read more...
By Steve Jones 2013/01/30 (first published: 2008/09/26) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 56,869 reads

CLR Integration in SQL

Learn how to build a CLR function that can be used to perform string manipulations that might be rather complex in T-SQL.  Read more...
By Bina Khan 2012/04/05 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 7,781 reads

SQL Server 2008 Build List

The list of builds for SQL Server 2008 updated SP4.  Read more...
By Steve Jones 2013/01/30 (first published: 2008/09/26) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 56,869 reads

Tips for Upgrading a Cluster to SQL 2008 - Part 2

This article describes my experience in upgrading a four node cluster with three active instances to SQL 2008  Read more...
By Alejandro Pelc 2012/03/20 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 2,354 reads

Adding a log shipping monitor

This article describes how to add a log shipping monitor to a log shipping configuration that is already in place.  Read more...
By Luke Campbell 2012/03/15 | Source: SQLServerCentral.com | Category: log shipping
Rating: |  Discuss |   Briefcase | 4,469 reads

Fix SSRS Subscription Owners

Stored procedure to update SSRS Subscription owners to avoid email errors.  Read more...
Rating: |  Discuss |   Briefcase | 940 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

Get Top Queries Taxing SQL Server CPUs

Script which uses SQL Server DMOs to gather top CPU taxing queries which can benifit most from tuning.  Read more...
By Prakash Heda 2012/03/10 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 2,598 reads

sp_JobSchedule_rpt for SQL 2005/8

I just took the stored procedure documented here: http://www.sql-server-performance.com/2002/job-report/ ?? ...and made it work on 2005/2008.   Read more...
By Sekhar Mynam 2012/02/23 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,314 reads

SQL Server 2008 Build List

The list of builds for SQL Server 2008 updated SP4.  Read more...
By Steve Jones 2013/01/30 (first published: 2008/09/26) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 56,869 reads

A Guide to Installing SQL Server 2008 R2 Reporting Services

This document shows how to install a Microsoft SQL Server 2008 R2 Reporting Services instance.   Read more...
Rating: |  Discuss |   Briefcase | 14,407 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

create jobs script for 2000 2005 or 2008

will create jobs script for backup or DR purposes to install on another server.  Read more...
By Gene Hunter 2012/01/18 | Source: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 1,914 reads

Understanding and Using APPLY (Part 2)

The second of a series by Paul White examining the APPLY operator. In this section learn how this operator compares with joins and about both the cross and outer options.  Read more...
By Paul White 2012/01/13 (first published: 2010/04/19) | Source: SQLServerCentral.com | Category: apply
Rating: |  Discuss |   Briefcase | 20,993 reads
<< Newer    Items 21 to 40 of 438    Older >>
 
Tags
sql server 2005 (43)    
t-sql (42)    
integration services (ssis) (20)    
auditing (17)    
security (14)    
blogs (12)    
clustering (12)    
filestream (12)    
spatial data (12)    
backup / restore (11)    
data types (11)    
performance tuning (11)    
upgrading (11)    
data warehousing (10)    
reporting services (ssrs) (10)    
sql server 2008 r2 (10)    
change data capture (cdc) (9)    
data collector (9)    
administration (8)    
indexing (8)    
policy based management (pbm) (8)    
resource governor (8)    
sample chapters (8)    
compression (7)    
extended events (7)    
hierarchyid (7)    
management studio (ssms) (7)    
news (7)    
replication (7)    
transparent data encryption (tde) (7)    
installation (6)    
service packs (6)    
sql server 2000 (6)    
analysis services (ssas) (5)    
data compression (5)    
high availability (ha) (5)    
merge (5)    
profiler (5)    
sql server (5)    
books (4)    
database weekly (4)    
datetime manipulation (4)    
encryption (4)    
extract, transform, load (etl) (4)    
full-text search (2008) (4)    
internals (4)    
mdw (4)    
optimizer (4)    
performance monitoring (4)    
sql audit (4)    
undocumented (4)    
video (4)    
64-bit (3)    
data mining (3)    
database mirroring (3)    
database security (3)    
dmv (3)    
grouping sets (3)    
jobs (3)    
monitoring (3)    
service broker (3)    
sparse columns (3)    
sql server 2012 (3)    
sql trace (3)    
triggers (3)    
xml (3)    
.net (2)    
apply (2)    
attach (2)    
backup (2)    
backup compression (2)    
certifications (2)    
change tracking (2)    
cumulative updates (cu) (2)    
data profiling (2)    
database mail (2)    
date manipulation (2)    
dba (2)    
ddl triggers (2)    
debugger (2)    
development (2)    
editorial (2)    
filtered indexes (2)    
fragmentation (2)    
gis (2)    
log shipping (2)    
mcitp (2)    
mcts (2)    
peer-to-peer (2)    
permissions (2)    
powershell (2)    
scalability (2)    
sql agent (2)    
sql server 7 (2)    
sql server architecture (2)    
statistics (2)    
status (2)    
stored procedures (2)    
table valued parameters (2)    
transactional replication (2)    
tvp (2)    
visualizations (2)    
windows 2008 (2)    
xevents (2)    
.net framework 3.5 (1)    
access (1)    
ado.net (1)    
advanced querying (1)    
adventureworks (1)    
amo (1)    
appdev (1)    
application programming (1)    
asynchronous messaging (1)    
audit (1)    
backup / recovery (1)    
best practices (1)    
blob manipulation (1)    
book reviews (1)    
brad's sure guides (1)    
build list (1)    
bulk import (1)    
business case (1)    
business intelligence (1)    
cdc.fn_cdc_get_all_changes (1)    
cdc.fn_cdc_get_net_changes (1)    
cdc.lsn_time_mapping (1)    
change cata capture (1)    
collation (1)    
command prompt (1)    
common language runtime (clr) (1)    
compare database (1)    
compliance (1)    
compress (1)    
compression ratio (1)    
conferences/user groups (1)    
copy database script (1)    
copy_only (1)    
cryptography (1)    
custom scripting (1)    
data (1)    
data access (1)    
database reactoring (1)    
database snapshots (1)    
database trigger (1)    
datetimeoffset (1)    
ddl (1)    
ddl_events (1)    
deadlock (1)    
declarative management framework (dmf) (1)    
dependencies (1)    
designing database solutions (1)    
detach (1)    
developer (1)    
dimensions (1)    
dmo (1)    
dts (1)    
editorial - ipod (1)    
editorial - mp3 (1)    
editorial - wmv (1)    
email (1)    
enterprise policy management framework (epm) (1)    
error (1)    
event notifications (1)    
eventnotification (1)    
events (1)    
exams (1)    
failure (1)    
fast track data warehouse (1)    
features (1)    
file exists (1)    
file system task (1)    
fill factor (1)    
firewall (1)    
float (1)    
ftp task (1)    
full database compression (1)    
geo-replication (1)    
hierarchies (1)    
ienumerable (1)    
index maintenance (1)    
indexed views (1)    
information (1)    
information_schema (1)    
instances (1)    
integrity check (1)    
is_tracked_by_cdc (1)    
large data sets (1)    
large udt (1)    
loading data (1)    
logs (1)    
logshipping (1)    
maintenance (1)    
maintenance and management (1)    
maintenance plans (1)    
mdx (1)    
merge replication (1)    
migration assistant (1)    
miscellaneous (1)    
monitor server (1)    
netweaver (1)    
new feature of sql server 2008 (1)    
nitesh dedhia (1)    
notifications (1)    
operators (1)    
oracle (1)    
ownership (1)    
page compression (1)    
paging (1)    
parameters (1)    
partitioned tables (1)    
partitioning (1)    
pass (1)    
performance advisor (1)    
performance testing (1)    
php (1)    
presenting (1)    
processing (1)    
product reviews (1)    
professional development (1)    
professional organization for sql server (1)    
programming (1)    
proxy accounts (1)    
query optimization (1)    
report (1)    
report builder (1)    
restore (1)    
row compression (1)    
row_number() (1)    
sample databases (1)    
sap (1)    
schema (1)    
schemas (1)    
server trigger (1)    
slipstream (1)    
smo (1)    
snapshots (1)    
sp_cdc_enable_db (1)    
sp_cdc_enable_table (1)    
sp_detach_db (1)    
spinlock (1)    
sponsored article (1)    
sql sentry (1)    
sql server 2014 (1)    
sql university (1)    
sqlclr (1)    
sqlsaturday (1)    
star schemas (1)    
streaming (1)    
studying (1)    
subscription (1)    
surface area configuration tool (1)    
sys.sp_cdc_cleanup_change_table (1)    
syscolumns (1)    
sysobjects (1)    
system databases (1)    
system monitor (1)    
teradata (1)    
time range (1)    
tips (1)    
tools (1)    
top (1)    
top cpu queries (1)    
trace (1)    
trace flags (1)    
training (1)    
troubleshooting (1)    
truncate table (1)    
upgrade advisor (1)    
user defined table type (1)    
vbscript (1)    
visual studio (1)    
visual studio 2010 (1)    
web service (1)    
webinar (1)    
windows security (1)    
xmla (1)    
xp_sendmail (1)