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 41 to 60 of 445    Older >>
 

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,753 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 Alan Speckman 2012/02/23 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,345 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,836 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 | 15,155 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 | 44,571 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: agent jobs
Rating: |  Discuss |   Briefcase | 1,957 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 | 22,220 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 | 36,883 reads

SQL Server Service Broker demystified

Simplified explanation of whats and hows of Service Brokers  Read more...
By Kautuk 2011/12/15 | Source: SQLServerCentral.com | Category: service broker
Rating: |  Discuss |   Briefcase | 7,625 reads

Tips for Upgrading a Cluster to SQL 2008 - Part 1

This article describes my experience in upgrading a four node cluster with three active instances to SQL 2008  Read more...
By Alejandro Pelc 2011/11/14 | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 2,709 reads

Using TOP To Rank Columns In a Table

This article covers the use of the TOP clause to select data from a table based on the TOP n columns in a table.  Read more...
By Tim Parker 2011/10/25 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 6,367 reads

Diagnosing and Resolving Spinlock Contention on SQL Server

This paper describes how to identify and resolve spinlock contention issues observed when running SQL Server 2008 applications on high concurrency systems with certain workloads.  Read more...
By Additional Articles 2011/10/21 | Source: SQLCAT | Category: spinlock
Rating: (not yet rated)  Rate this |   Briefcase | 2,390 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,836 reads

Adding Custom Code to the Reporting Services 2008 R2

There are numerous circumstances when we wish to add a custom function to a SSRS report in order to cater for needs of the customer which exceeds the capability of the built-in functions in SSRS. In these scenarios we will have to write our own functions. In this article you will see how to add custom code to SSRS.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,920 reads

Detach All User Databases

Detach all user databases on a SQL 2008 instance  Read more...
By Chris McGowan 2011/08/24 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 917 reads

SQL Server 2008 and 2008 R2 Integration Services - Analysis Services Processing Task

The primary purpose of SQL Server 2008 Integration Services is to deliver extraction, transformation, and loading (ETL) functionality that supports core features of the SQL Server database management system. However, there are numerous scenarios where its role involves interaction with components that provide business intelligence-related features incorporated into the product.  Read more...
By Additional Articles 2011/08/15 | Source: Database Journal | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 3,064 reads

Change Tracking and Database Refactoring

Using change tracking in SQL Server 2008 to aid in database refactoring within an OLTP system.  Read more...
By Luke Campbell 2011/08/11 | Source: SQLServerCentral.com | Category: change tracking
Rating: |  Discuss |   Briefcase | 4,686 reads

Guide To MCITP: SQL Server 2008 Administration

Find out what you need to learn for the SQL Server 2008 Administration certification exams.  Read more...
By Mike McQuillan 2011/08/05 | Source: SQLServerCentral.com | Category: mcts
Rating: |  Discuss |   Briefcase | 8,511 reads

Check status of active transactions

Script to check status of active transactions.  Read more...
By Harsha Majety 2011/08/04 | Source: SQLServerCentral.com | Category: status
Rating: |  Discuss |   Briefcase | 2,288 reads

Migrating Microsoft Access Databases to SQL Server 2008

Microsoft Access is a very good database solution, but it has limits. While the portability of mdb and accdb files is convenient, there are advantages to moving to the less portable SQL Server solution. If you do have SQL Server, there's very little reason not to consider migrating your Access Databases. Not all custom-made Access applications easily lend themselves to a SQL Server solution so you'll need to do some analysis before choosing a migration path.  Read more...
By Additional Articles 2011/07/26 | Source: Database Journal | Category: access
Rating: (not yet rated)  Rate this |   Briefcase | 3,057 reads
<< Newer    Items 41 to 60 of 445    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 (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)    
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 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)