Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag SQL Server 2008 Rss

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

Creating A SQL Server 2008\2008 R2 Failover Cluster

Details how to install a SQL Server 2008\2008R2 Failover Cluster Instance  Read more...
By Perry Whittle 2013/12/23 (first published: 2011/01/19) | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 18,362 reads

Fun with real and float

By Dave 2013/07/01 | Category: float
Rating: (not yet rated) |  Discuss |   Briefcase | 2,347 reads

Change Data Capture - SQL Server 2008

Change Data Capture (CDC) records DML operations performed on SQL tables and makes records available with information regarding what changed and when the change happened in a simple way.  Read more...
By Nitesh R Dedhia 2013/06/24 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 6,493 reads

iSpy (on your development)

Using EventNotification (Service Broker - DDL_EVENTS) to audit Schema change on a Server, or any of it's databases  Read more...
By Rob Lobbe 2013/06/19 | Source: SQLServerCentral.com | Category: schemas
Rating: |  Discuss |   Briefcase | 1,405 reads

Attention users running SQL Server 2008 & 2008 R2!

Updates to the latest CUs for SQL Server 2008 and SQL Server 2008 R2 from Aaron Bertrand.  Read more...
By Press Release 2013/06/18 | Source: SQL Blog | Category: cumulative updates (cu)
Rating: (not yet rated)  Rate this |   Briefcase | 10,479 reads

PowerShell to SlipStream SQL 2008

PowerShell script to SlipStream SQL Server 2008 installer with SPx patch.  Read more...
By Fahim Ahmad 2014/08/27 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 966 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, SQL Server 2014, and SQL Server 2016.  Read more...
By Ola Hallengren 2016/07/11 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 44,962 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 | 57,887 reads

Number of Rows

By Dave 2013/01/18 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,473 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, SQL Server 2014, and SQL Server 2016.  Read more...
By Ola Hallengren 2016/07/11 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 44,962 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,604 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 | 57,887 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 | 631 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,473 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,574 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 | 57,887 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,855 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 | 57,887 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,387 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,871 reads
<< Newer    Items 21 to 40 of 447    Older >>
 
Tags
sql server 2005 (43)    
t-sql (42)    
integration services (ssis) (20)    
auditing (18)    
security (15)    
backup and restore (12)    
blogs (12)    
clustering (12)    
filestream (12)    
spatial data (12)    
datatypes (11)    
performance tuning (11)    
sql server 2008 r2 (11)    
upgrading (11)    
data warehousing (10)    
reporting services (ssrs) (10)    
change data capture (cdc) (9)    
data collector (9)    
indexing (9)    
administration (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)    
internals (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)    
mdw (4)    
optimizer (4)    
performance monitoring (4)    
sql audit (4)    
sql server 2012 (4)    
undocumented (4)    
video (4)    
64-bit (3)    
agent jobs (3)    
data mining (3)    
database mirroring (3)    
database security (3)    
dmv (3)    
grouping sets (3)    
monitoring (3)    
service broker (3)    
sparse columns (3)    
sql server 2014 (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)    
datazen (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)    
mobile dashboard (2)    
peer-to-peer (2)    
permissions (2)    
powershell (2)    
scalability (2)    
schemas (2)    
sql agent (2)    
sql server 7 (2)    
sql server architecture (2)    
statistics (data) (2)    
status (2)    
stored procedures (2)    
table valued parameters (tvp) (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)    
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 migration (1)    
database reactoring (1)    
database snapshots (1)    
database trigger (1)    
datetimeoffset (1)    
ddl (1)    
ddl_events (1)    
deadlocks (1)    
declarative management framework (dmf) (1)    
dependencies (1)    
designing database solutions (1)    
detach database (1)    
developer (1)    
dimensions (1)    
dmo (1)    
dts (1)    
editorial - ipod (1)    
editorial - mp3 (1)    
editorial - wmv (1)    
email (1)    
enterprise edition (1)    
enterprise policy management framework (epm) (1)    
error handling (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)    
indexed views (1)    
information (1)    
information_schema (1)    
instances (1)    
integrity check (1)    
is_tracked_by_cdc (1)    
key performance indicators (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 (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)    
processes (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)    
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 2016 (1)    
sql server migrtion (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)