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

Content with tag Performance Rss

<< Newer    Items 41 to 44 of 44   
 

Better Coding, More Savings

The way we write code impacts our users, but it can also impact our wallet, especially in cloud computing. Steve Jones wonders how many people bother to profile and test their code.  Read more...
By Steve Jones 2013/05/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 267 reads

Staggering SQLIO Sessions Across Multiple Volumes

In a previous post, I discussed running SQLIO against multiple files. ┬áThe purpose in using multiple files is being able...  Read more...
By StrateSQL 2013/04/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 983 reads

Is BETWEEN faster than GTE and LTE?

I know I have been light on blog posting this year. They always say that life tends to get in...  Read more...
By kleegeek 2013/04/04 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 5,426 reads

Intelligent Index Reorganize and Rebuild Script - v1.0

This script will provide a dynamic mechanism to decide between REBUILDING an index or simply REORGANIZING an index. Tested and approved for SQL Server 2005 & 2008 Standard or Enterprise or R2.  Read more...
By Tim Parker 2012/11/26 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,490 reads
<< Newer    Items 41 to 44 of 44   
 
Tags
t-sql (9)    
blogs (8)    
administration (4)    
tuning (4)    
editorial (3)    
execution plan (3)    
execution plans (3)    
indexing (3)    
sql server 2014 (3)    
cardinality estimates (2)    
hash match (2)    
merge (2)    
optimization (2)    
query optimizer (2)    
sql trace (2)    
statistics (2)    
window functions (2)    
actual execution plan (1)    
actual plan (1)    
best practices (1)    
binary flags (1)    
bit operations (1)    
bottle necks (1)    
conditional split (1)    
cpu usage data (1)    
cursor (1)    
database design (1)    
database development (1)    
database performance (1)    
database weekly (1)    
debug (1)    
deleted (1)    
duplicates (1)    
estimated plan (1)    
identity (1)    
index (1)    
in-line memory (1)    
inserted (1)    
integration services (ssis) (1)    
jobs (1)    
lag (1)    
lead (1)    
lookup table (1)    
microsoft sql server (1)    
orm (1)    
over clause (1)    
page life expectancy (1)    
page splits (1)    
parallelism (1)    
query optimization (1)    
reporting services (ssrs) (1)    
schedule (1)    
scope_identity (1)    
software development (1)    
sql server 2005 (1)    
sql server 2012 (1)    
sqlagent (1)    
sqlh2 (1)    
sqlio (1)    
sqlpass (1)    
sqlprep (1)    
tally table (1)    
tips (1)    
tools (1)    
update (1)