Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags SQL Server 2008, SQL Server 2005 Rss

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

Inside the Optimizer: Constructing a Plan - Part 3

Join Paul White in part three of a four-part series exploring the internals of query optimization as he looks at the rules that are used to build the execution plan.  Read more...
By Paul White 2010/09/14 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 6,153 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/04/30 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 42,342 reads

Inside the Optimizer: Constructing a Plan - Part 2

How does the query optimizer build an execution plan for your queries? Paul White shows is in part two of a four-part series exploring the internals of query optimization.   Read more...
By Paul White 2010/09/09 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 7,508 reads

Inside the Optimizer: Constructing a Plan - Part 1

Part one of a four-part series exploring the internals of query optimization from T-SQL guru, Paul White.  Read more...
By Paul White 2010/09/07 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 12,310 reads

SQL 2008 & 2005 DDL Auditing - Full Server Self Maintaining Solution

DDL triggers enable us to audit DDL changes but there are a few missing events, design decisions and installation complications.  Read more...
By Sean Elliott 2010/08/17 | Source: SQLServerCentral.com | Category: ddl
Rating: |  Discuss |   Briefcase | 7,196 reads

For SQL Server 2005/2008, Consider SecurityAdmin = SysAdmin

In a recent thread here on SQL Server Central, it was pointed out that a member of the securityadmin fixed...  Read more...
By Brian Kelley 2010/07/23 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,942 reads

SSIS Package to Script All SQL Server Jobs to Individual Files

The provided SSIS package contains a single script task that will script all SQL Server 2000/2005/2008 Agent Jobs into individual files.  Read more...
Rating: |  Discuss |   Briefcase | 9,731 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,724 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 | 34,779 reads

A little restriction that prevent changing tables in SQL Server 2008

In SQL Server 2008, by default, the option to prevent tables changes is "on". We can have some issues and...  Read more...
By Dukagjin Maloku 2010/03/24 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,232 reads

Find weak login passwords in your server

Use this script to search for SQL Server logins who use weak password  Read more...
By Th Tr 2010/01/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,499 reads

Managing Large Data Sets in SQL Server 2005 and 2008

Easily manage operations against large data sets, be able to stop and start operations at a whim and throttle them up or down to manage system performance.  Read more...
By Zach Mided 2010/01/04 | Source: SQLServerCentral.com | Category: large data sets
Rating: |  Discuss |   Briefcase | 10,420 reads

Getting Started with SQL Server Event Notifications

Learn the basics of Event Notifications from MVP Jonathan Kehayia. This article will show you how to create customized responses to events in SQL Server 2005/2008.  Read more...
By Jonathan Kehayias 2009/12/22 | Source: SQLServerCentral.com | Category: event notifications
Rating: |  Discuss |   Briefcase | 12,630 reads

Is It Worth Upgrading to SQL Server 2008

New author Nigel Maneffa brings us a look at SQL Server 2008 and its new features, trying to decide if it's worth the upgrade.  Read more...
By Nigel Maneffa 2009/12/18 (first published: 2008/10/21) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 30,801 reads

Using a Certificate Signed Stored Procedure to Execute sp_send_dbmail

Learn how to create a certificate signed stored procedure to solve common permissions problems using sp_send_dbmail. MVP Jonathan Kehayias brings us a short tutorial that discusses your options and code to show you how to implement certificate security.  Read more...
By Jonathan Kehayias 2009/12/17 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 7,752 reads

Generate stored procedure parameter list based on table

Generate stored procedure parameter list based on table, useful when creating new SPs on tables with lots of columns.   Read more...
By Thomas Cournane 2009/12/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,636 reads

Why We Recommend Against xp_cmdshell

Every so often I see a post in a forum or on Twitter about the use of xp_cmdshell. Usually it is someone looking for...  Read more...
By 2009/11/19 | Source: SQLServerCentral.com | Category: blogs
Rating:  Rate this |   Briefcase | 6,833 reads

The Best of SQLServerCentral, Vol.7

The seventh volume in this collection brings you a compilation of the best articles we've seen over the past year, from over 50 authors.   Read more...
By Steve Jones 2009/11/12 | Source: SQLServerCentral.com | Category: books
Rating: (not yet rated) |  Discuss |   Briefcase | 5,428 reads

SQL University: Multiple Paths and Ownership Chaining

Welcome back to our last class this term on security in SQL Server here at SQL University. According to the syllabus,...  Read more...
By 2009/11/03 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,630 reads

Scripting in SSIS

Tim Mitchell presented at SQLSaturday #17 on Scripting in SSIS. I thought it was a really interesting presentation, and I’m...  Read more...
By Steve Jones 2009/08/07 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,968 reads
<< Newer    Items 21 to 40 of 56    Older >>
 
Tags
blogs (7)    
security (7)    
t-sql (7)    
sql server 2000 (5)    
internals (4)    
optimizer (4)    
sql server (4)    
undocumented (4)    
backup / restore (3)    
database security (3)    
integration services (ssis) (3)    
jobs (3)    
performance tuning (3)    
sql server 2008 r2 (3)    
apply (2)    
books (2)    
clustering (2)    
database mail (2)    
sql agent (2)    
sql server 7 (2)    
sql server architecture (2)    
status (2)    
administration (1)    
auditing (1)    
backup (1)    
compression (1)    
conferences/user groups (1)    
copy_only (1)    
data types (1)    
database mirroring (1)    
database trigger (1)    
ddl (1)    
ddl triggers (1)    
event notifications (1)    
file exists (1)    
hierarchyid (1)    
index maintenance (1)    
indexing (1)    
information (1)    
information_schema (1)    
integrity check (1)    
large data sets (1)    
logshipping (1)    
maintenance (1)    
paging (1)    
parameters (1)    
permissions (1)    
php (1)    
presenting (1)    
professional development (1)    
professional organization for sql server (1)    
proxy accounts (1)    
row_number() (1)    
server trigger (1)    
service broker (1)    
smo (1)    
sql server 2012 (1)    
sql server 2014 (1)    
sql university (1)    
sqlsaturday (1)    
statistics (1)    
stored procedures (1)    
syscolumns (1)    
sysobjects (1)    
time range (1)    
tools (1)    
top (1)    
training (1)    
upgrading (1)    
vbscript (1)    
windows security (1)    
xp_sendmail (1)