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 437    Older >>
 

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,571 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,819 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 | 588 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,396 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 Dedhia 2012/06/18 | Source: SQLServerCentral.com | Category: change tracking
Rating: |  Discuss |   Briefcase | 7,392 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,819 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,776 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,819 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,445 reads

Fix SSRS Subscription Owners

Stored procedure to update SSRS Subscription owners to avoid email errors.  Read more...
Rating: |  Discuss |   Briefcase | 937 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,580 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,589 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,312 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,819 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,350 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,580 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,910 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,950 reads

Understanding and Using APPLY (Part 1)

The first of a two-part series of articles examining the APPLY operator. Learn the basics of how this operator works and how it can help you solve some tricky problems.  Read more...
By Paul White 2012/01/06 (first published: 2010/04/12) | Source: SQLServerCentral.com | Category: apply
Rating: |  Discuss |   Briefcase | 35,133 reads
<< Newer    Items 21 to 40 of 437    Older >>
 
Tags
sql server 2005 (43)    
t-sql (41)    
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)    
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)