<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Content with tag
SQL Server 2008
Items 1 to 20 of 425
Next 20 >>
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 and SQL Server 2008 R2.
Read more...
By
Ola Hallengren
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
34,805 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:
(not yet rated)
|
Discuss
|
Briefcase
|
1,120 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
|
16,846 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
|
29,448 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
|
5,347 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 and SQL Server 2008 R2.
Read more...
By
Ola Hallengren
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
34,805 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
|
1,700 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,095 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
|
1,811 reads
SQL Server 2008 Build List
The list of builds for SQL Server 2008 updated SP3.
Read more...
By
Steve Jones
2012/02/14 (first published: 2008/09/26)
|
Source:
SQLServerCentral.com
|
Category:
sql server 2008
Rating:
|
Discuss
|
Briefcase
|
41,651 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...
By
Additional Articles
2011/09/15
|
Source:
SQL Server Performance
|
Category:
reporting services (ssrs)
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,224 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
|
643 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 and SQL Server 2008 R2.
Read more...
By
Ola Hallengren
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
34,805 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,110 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
|
3,965 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
|
6,693 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
|
1,459 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,447 reads
SQL Server 2008 Build List
The list of builds for SQL Server 2008 updated SP3.
Read more...
By
Steve Jones
2012/02/14 (first published: 2008/09/26)
|
Source:
SQLServerCentral.com
|
Category:
sql server 2008
Rating:
|
Discuss
|
Briefcase
|
41,651 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
|
2,910 reads
Items 1 to 20 of 425
Next 20 >>
Tags
sql server 2005
(40)
t-sql
(38)
integration services (ssis)
(20)
auditing
(17)
security
(14)
backup / restore
(12)
blogs
(12)
filestream
(12)
spatial data
(12)
clustering
(11)
data types
(11)
data warehousing
(10)
upgrade
(10)
change data capture (cdc)
(9)
data collector
(9)
performance tuning
(9)
administration
(8)
indexing
(8)
reporting services (ssrs)
(8)
resource governor
(8)
sample chapters
(8)
compression
(7)
extended events
(7)
hierarchyid
(7)
management studio (ssms)
(7)
news
(7)
pbm
(7)
sql server 2008 r2
(7)
tde
(7)
installation
(6)
replication
(6)
service packs
(6)
sql server 2000
(6)
data compression
(5)
high availability
(5)
merge
(5)
policy based management
(5)
profiler
(5)
analysis services (ssas)
(4)
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)
sql server
(4)
undocumented
(4)
video
(4)
64-bit
(3)
data mining
(3)
database security
(3)
grouping sets
(3)
jobs
(3)
monitoring
(3)
service broker
(3)
sparse columns
(3)
sql trace
(3)
triggers
(3)
xml
(3)
.net
(2)
apply
(2)
attach
(2)
backup compression
(2)
data profiling
(2)
database mail
(2)
database mirroring
(2)
date manipulation
(2)
dba
(2)
debugger
(2)
dmv
(2)
editorial
(2)
filtered indexes
(2)
fragmentation
(2)
gis
(2)
mcitp
(2)
mcts
(2)
peer-to-peer
(2)
permissions
(2)
policy-based management
(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)
tvp
(2)
visualizations
(2)
windows 2008
(2)
xevents
(2)
access
(1)
ado.net
(1)
advanced querying
(1)
adventureworks
(1)
amo
(1)
analysis services processing task
(1)
appdev
(1)
application programming
(1)
asynchronous messaging
(1)
backup
(1)
best practices
(1)
book reviews
(1)
brad's sure guides
(1)
build list
(1)
bulk import
(1)
business case
(1)
business intelligence
(1)
certification
(1)
certifications
(1)
change tracking
(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_only
(1)
cryptography
(1)
custom scripting
(1)
data
(1)
data access
(1)
database reactoring
(1)
database snapshots
(1)
database trigger
(1)
datetimeoffset
(1)
ddl event
(1)
ddl trigger
(1)
ddl triggers
(1)
deadlock
(1)
declarative management framework (dmf)
(1)
dependencies
(1)
designing database solutions
(1)
detach
(1)
developer
(1)
development
(1)
dimensions
(1)
dts
(1)
editorial - ipod
(1)
editorial - mp3
(1)
editorial - wmv
(1)
enterprise policy management framework (epm)
(1)
event notifications
(1)
exams
(1)
fast track data warehouse
(1)
features
(1)
file exists
(1)
file system task
(1)
fill factor
(1)
firewall
(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)
large data sets
(1)
large udt
(1)
loading data
(1)
log shipping
(1)
logs
(1)
maintenance and management
(1)
maintenance and management sql server 2005
(1)
maintenance plans
(1)
mdx
(1)
merge replication
(1)
migration assistant
(1)
miscellaneous
(1)
monitor server
(1)
netweaver
(1)
operators
(1)
oracle
(1)
ownership
(1)
page compression
(1)
paging
(1)
parameters
(1)
partitioned tables
(1)
partitioning
(1)
pass
(1)
performance
(1)
performance advisor
(1)
performance testing
(1)
php
(1)
powershell
(1)
presenting
(1)
product reviews
(1)
professional development
(1)
professional organization for sql server
(1)
programming
(1)
proxy accounts
(1)
query optimization
(1)
report builder
(1)
restore
(1)
row compression
(1)
row_number()
(1)
sample databases
(1)
sap
(1)
schema
(1)
server trigger
(1)
smo
(1)
snapshots
(1)
sp_detach_db
(1)
spinlock
(1)
sponsored article
(1)
sql sentry
(1)
sql university
(1)
sqlsaturday
(1)
star schemas
(1)
streaming
(1)
studying
(1)
surface area configuration tool
(1)
syscolumns
(1)
sysobjects
(1)
system databases
(1)
system monitor
(1)
teradata
(1)
time range
(1)
tips
(1)
tools
(1)
top
(1)
trace
(1)
training
(1)
transactional replication
(1)
transparent data encryption
(1)
troubleshooting
(1)
truncate
(1)
upgrade advisor
(1)
user defined table type
(1)
vbscript
(1)
visual studio
(1)
web service
(1)
webinar
(1)
windows security
(1)
xmla
(1)
xp_sendmail
(1)
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
