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

Content with tags T-SQL, Performance Tuning Rss

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

What's the best way to count?

By Dave 2010/10/19 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,227 reads

Tips to optimize your SQL statements

Don't blame SQL Server if your SQL Statements perform badly! But where do you start to investigate the problem? This article is a primer on were to start looking when your SQL runs slowly.  Read more...
By Brian Ellul 2012/02/10 (first published: 2010/07/29) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 40,688 reads

SQL Server 2008 Table Valued Parameters Performance

An article from Scott Zurolo tests the terformance of SQL Server 2008 Table Valued Parameters against more traditional methods of updating many rows at once.  Read more...
By Scott Zurolo 2010/07/08 | Source: SQLServerCentral.com | Category: tvp
Rating: |  Discuss |   Briefcase | 9,526 reads

The Ultimate Running Requests Reporter

Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.  Read more...
By Jesse Roberge 2010/05/24 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,532 reads

Optimising Server-Side Paging - Part II

The second part of this series compares four methods of obtaining the total number of rows in a paged data set.  Read more...
By Paul White 2010/05/24 | Source: SQLServerCentral.com | Category: paging
Rating: |  Discuss |   Briefcase | 8,229 reads

SQL Server 2005 Paging – The Holy Grail

Handling the paging of results in T-SQL has been a challenge for a long time. Robert Cary presents an interesting technique in this article.  Read more...
By Robert Cary 2010/05/07 (first published: 2009/03/11) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 34,729 reads

Optimising Server-Side Paging - Part I

This article by Paul White presents an optimisation for paging through a wide data set.  Read more...
By Paul White 2010/04/26 | Source: SQLServerCentral.com | Category: paging
Rating: |  Discuss |   Briefcase | 15,545 reads

T-SQL: Why “It Depends”

Why does everyone use "it depends" as an answer to many T-SQL questions? Bob Hovious brings us a short example of how performance can change based on data loads for the same code.   Read more...
By Bob Hovious 2010/03/16 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 11,149 reads

Breaking Down TempDB Contention

Breaking Down TempDB Contention  What is tempDB contention? From the outside looking in, tempDB contention may look like any other blocking. There...  Read more...
By Robert Davis 2010/03/10 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,237 reads

SARGable

By Prakriti Agrawal 2010/02/26 | Category: performance tuning
Rating: (not yet rated) |  Discuss |   Briefcase | 3,445 reads

Optimising “Ends With” searches with REVERSE

A simple way to improve performance for queries that use the LIKE operator. Ben Seaman shows how to deal with searches that look at the end of a piece of text  Read more...
By Ben Whitman 2010/01/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 9,008 reads

Comparing cursor vs. WHILE loop performance in SQL Server 2008

There are situations in which you need to individually handle each row in a result set. SQL Server 2008 provides a minimal set of tools — cursors and WHILE loops — to accomplish this task. I'll take a closer look at each option and explain why it's difficult to pinpoint which is better in terms of performance.  Read more...
By Additional Articles 2009/12/11 | Source: Builder.com | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 4,693 reads

An Un-indexed Foreign Key Gotcha

Indexing is important for improving performance, but do you know that a lack of indexes might actually cause things to stop working? Alok Dwivedi brings us a very interesting scenario where the lack of an index causes a problem with concurrency.  Read more...
By Alok Dwivedi 2009/11/09 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,718 reads

The Ultimate Running Requests Reporter

Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.  Read more...
By Jesse Roberge 2010/05/24 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,532 reads

The Ultimate Connection Summarizer and Trouble Finder

Reports summaries, in 3 levels of detail, connections, running requests, open transactions + cursors, and blocking. Provides query text + plan for the piggiest running request of each group.  Read more...
Rating: |  Discuss |   Briefcase | 5,693 reads

The Ultimate Index-Less Foreign-Key Finder

Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.  Read more...
By Jesse Roberge 2009/10/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,308 reads

SQL WHERE Clause Optimization

SQL WHERE clause optimization is important to get maximum performance from a query. If an index exists on a column you obviously want the query to use it...   Read more...
By Additional Articles 2009/09/25 | Source: SQL-Server-Pro | Category: t-sql
Rating:  Rate this |   Briefcase | 9,283 reads

Using Star Join and Few-Outer-Row Optimizations to Improve Data Warehousing Queries

In this white paper we discuss two of the new features in SQL Server 2008, Star Join and Few-Outer-Row optimizations. We test the performance of SQL Server 2008 on a set of complex data warehouse queries designed to highlight the effect of these two features and observed a significant performance gain over SQL Server 2005 (without these two features).  Read more...
By Additional Articles 2009/09/10 | Source: Microsoft MSDN | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 3,834 reads

Parameterized Queries

Previous T-SQL best practices articles have discussed different coding styles that led to slow and fast query executions, and ways to minimize cached plans. This article will be an extension on those concepts, focusing on how the SQL Server optimizer tries to parameterize a query if it can, as well as how you can build your own parameterized query.  Read more...
By Additional Articles 2009/09/03 | Source: Database Journal | Category: t-sql
Rating:  Rate this |   Briefcase | 5,497 reads

Storing IPv4 Addresses for Performance

An in-depth analysis on how to store IPv4 addresses to achieve maximum efficiency and performance in both storage and queries  Read more...
By Jean-Sebastien Carle 2009/08/19 | Source: SQLServerCentral.com | Category: ipv4 addresses
Rating: |  Discuss |   Briefcase | 8,259 reads
<< Newer    Items 21 to 40 of 138    Older >>
 
Tags
sql server 7 (38)    
administration (18)    
indexing (15)    
miscellaneous (13)    
sql server 2005 (13)    
utility (11)    
maintenance and management (10)    
maintenance (9)    
stored procedures (9)    
programming (8)    
advanced querying (7)    
list indexes (5)    
monitoring (5)    
pivot (5)    
sys.dm_db_partition_stats (5)    
blogs (4)    
crosstab (4)    
for xml path (4)    
strategies (4)    
xml (4)    
ado (3)    
configuring (3)    
database design (3)    
paging (3)    
security (3)    
visual basic 6 (3)    
basics (2)    
data types (2)    
dmv (2)    
foreign keys (fk) (2)    
lock and connection management (2)    
openxml (2)    
pagination (2)    
replication (2)    
sql server 2008 (2)    
sql server 6.5 (2)    
sys.dm_exec_query_plan (2)    
sys.dm_exec_requests (2)    
sys.dm_exec_sessions (2)    
sys.dm_exec_sql_text (2)    
triggers (2)    
troubleshooting (2)    
user defined function (udf) (2)    
.net (1)    
affinity (1)    
backup / restore (1)    
computed columns (1)    
cpu (1)    
custom optimizaqtion (1)    
custome statistics (1)    
data warehousing (1)    
deadlock (1)    
distributed queries (1)    
dts (1)    
duplicate indexes (1)    
editorial - mp3 (1)    
english query (1)    
excel (1)    
execution plans (1)    
graphs (1)    
implicit conversion (1)    
installation (1)    
internals (1)    
ip addresses (1)    
ipv4 addresses (1)    
like (1)    
missing indexes (1)    
naming standards (1)    
optimization (1)    
parameterized queries (1)    
procedural programming (1)    
reporting services (ssrs) (1)    
reverse (1)    
schedulers (1)    
search (1)    
selectivity (1)    
set based (1)    
sql puzzles (1)    
sql server 2012 (1)    
star schemas (1)    
statistics (1)    
storage (1)    
string (1)    
substring (1)    
sys.dm_db_index_usage_stats (1)    
sys.dm_db_missing_index_details (1)    
sys.dm_exec_connections (1)    
sys.dm_exec_cursors (1)    
sys.dm_os_ring_buffers (1)    
sys.dm_os_schedulers (1)    
sys.dm_os_sysinfo (1)    
sys.dm_tran_session_transactions (1)    
tables (1)    
tvp (1)    
updategrams (1)    
where (1)    
xsl (1)    
your own optimizer (1)