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 21 to 29 of 29   
 

Trace Analysis script

Script to help you analyze a trace to find worst performing procs.  Read more...
By Andie Letourneau 2013/06/25 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 1,244 reads

Nested Loops, Parallelism and Confusion

I’m 30 today. In addition, it’s been 10 years since I started working with SQL Server. In my twenties, I fell in...  Read more...
By Matan_Yungman 2013/06/11 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 342 reads

What's changed recently?

Often when tracking down problems, you need to know if anything has changed recently, this script will tell you...  Read more...
By Ian Stirk 2013/06/10 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 2,210 reads

Automating SQL Traces

Capturing the activity on a server when a problem occurs can be a challenge for many DBAs. This article shows how you can automate the capture of information when a CPU spike occurs.  Read more...
By Clark Froebe 2013/05/23 | Source: SQLServerCentral.com | Category: sql trace
Rating: |  Discuss |   Briefcase | 5,149 reads

Object Qualification

I came across an interesting issue recently with NHibernate, now it is widely known I despise ORM’s, in my experience...  Read more...
By Chris McGowan 2013/05/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,102 reads

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 | 262 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 | 867 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 | 4,473 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,108 reads
<< Newer    Items 21 to 29 of 29   
 
Tags
blogs (8)    
t-sql (7)    
editorial (3)    
execution plans (2)    
indexing (2)    
sql trace (2)    
tuning (2)    
window functions (2)    
actual execution plan (1)    
actual plan (1)    
administration (1)    
binary flags (1)    
bit operations (1)    
conditional split (1)    
database design (1)    
database development (1)    
database performance (1)    
database weekly (1)    
debug (1)    
estimated plan (1)    
execution plan (1)    
hash match (1)    
index (1)    
integration services (ssis) (1)    
lag (1)    
lead (1)    
lookup table (1)    
merge (1)    
optimization (1)    
orm (1)    
over clause (1)    
page life expectancy (1)    
page splits (1)    
parallelism (1)    
query optimization (1)    
query optimizer (1)    
reporting services (ssrs) (1)    
software development (1)    
sql server 2012 (1)    
sqlh2 (1)    
sqlio (1)    
sqlprep (1)    
tally table (1)    
tips (1)    
tools (1)    
tsql (1)    
update (1)