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

SQL Server 2008 Build List

The list of builds for SQL Server 2008 updated SP3 through MS14-044.  Read more...
By Steve Jones 2013/01/30 (first published: 2008/09/26) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 56,445 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,690 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 | 882 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 | 2,729 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,452 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,448 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,166 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 | 2,832 reads

SQL Server 2008 Build List

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

Table Value Constructors in SQL Server 2008

Table Value Constructors (TVCs) are a useful feature of 2008, allowing you to specify tables of values and expressions. Users who are stuck with previous versions of SQL Server can play along, since Rob Sheldon demonstrates that there have always been ways of doing this in SQL Server, though less elegantly.  Read more...
By Additional Articles 2011/07/07 | Source: SimpleTalk | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 3,389 reads

SQL DBAdmin toolbox - Part 1: Restore single database

A stored procedure for restoring a database up to the latest log backup from a file folder. Compatible with the backups made by standard SQL maintenance plan.   Read more...
By Infostar 2011/06/10 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 1,437 reads

Support for 15,000 Partitions in SQL Server 2008 SP2 and SQL Server 2008 R2 SP1

In SQL Server 2008 and SQL Server 2008 R2, the number of partitions on tables and indexes is limited to 1,000. This paper discusses how SQL Server 2008 SP2 and SQL Server 2008 R2 SP1 address this limitation by providing an option to increase the limit to 15,000 partitions. It describes how support for 15,000 partitions can be enabled and disabled on a database. It also talks about performance characteristics, certain limitations associated with this support, known issues, and their workarounds. This support is targeted to enterprise customers and ISVs with large-scale decision support or data warehouse requirements.  Read more...
By Additional Articles 2011/06/09 | Source: TechNet Blogs | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 2,207 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,121 reads

Getting the most out of your SQL Server 2008 Cluster

Gain an insight into how to use your SQL Server cluster for more than just high availibility in this article from Mark Jones.  Read more...
By Mark Jones 2011/05/26 | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 3,841 reads

Upgrade Strategies for SQL Server 2008

If you make the decision to upgrade to 2008, there are a number of tools that make the process easier, but you still need to understand what things you should consider. We have a new article from Arshad Ali to help you understand the process and what you should consider.  Read more...
By Arshad Ali 2011/05/20 (first published: 2009/03/02) | Source: SQLServerCentral.com | Category: upgrading
Rating: |  Discuss |   Briefcase | 21,510 reads

SQL Server 2008 Build List

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

More SQL Server 2008 Installation Issues

Robert Pearl brings us a few more potential SQL Server 2008 installation issues on Windows 7 and a few workarounds that might help you get around them.  Read more...
By Robert Pearl 2011/05/05 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 5,072 reads

SQL Server 2008 Installation Issues - Issues and Workarounds

MVP Robert Pearl explains how to get around some common issues that might occur when installing SQL Server 2008 on Windows 7.  Read more...
By Robert Pearl 2011/04/28 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 6,793 reads

OUTPUT & NEWID()

By Jason Selburg 2011/04/25 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,990 reads

The SQL Server 2008 Datetimeoffset Data Type

The Datetimeoffset Data Type was introduced in SQL Server 2008 (and .Net Frameword 3.5) and is the most advanced date and time date type available.  Read more...
By James Skipwith 2014/03/28 (first published: 2011/04/18) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 13,169 reads
<< Newer    Items 41 to 60 of 433    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)    
indexing (8)    
policy based management (pbm) (8)    
resource governor (8)    
sample chapters (8)    
administration (7)    
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)    
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)    
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)    
cumulative updates (cu) (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)    
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)