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

Content with tags Performance Tuning, T-SQL Rss

   Items 1 to 20 of 138    Older >>

Comparing Different Data Types

Comparing columns of different data types can be a drain on resources, as well as our sanity. This is a look into a few strategies for dealing with implicit conversions.  Read more...
By Edward Pollack 2014/05/19 | Source: | Category: datatypes
Rating: |  Discuss |   Briefcase | 6,207 reads

The Ultimate Index Lister (Non-Pivoted)

Lists details for all indexes on one or more tables / schemas, including row count and size. The non-pivot version also gives data type and other details for the columns.  Read more...
By Jesse Roberge 2013/10/02 | Source: | Category: indexing
Rating: |  Discuss |   Briefcase | 3,587 reads

The Ultimate Index Width Stats Reporter

Reports index length stats for indexes who's lengths exceeding parametrized thresholds (defaults to 0 - get all) for total length and seek length, optionally filtering schemas and tables.  Read more...
By Jesse Roberge 2013/07/26 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,231 reads

Finding Queries to Tune

A query to help identify queries that need some tuning.  Read more...
By Simon Osborne 2013/06/11 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,347 reads


By Steven Neumersky 2013/04/29 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,053 reads

Sub query pass through

Occasionally in forums and on client sites I see conditional subqueries in statements. This is where the developer has decided...  Read more...
By Dave Ballantyne 2013/03/26 | Source: | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,929 reads

SQL Server T-SQL Tuning – NOT IN and NOT Exists

Following on from the previous TSQL performance tuning article in this series, we now focus on the important topic of T-SQL “Not IN” And “Not Exists “  Read more...
By Additional Articles 2013/01/16 | Source: SQL Server Performance | Category: t-sql
Rating:  Rate this |   Briefcase | 6,828 reads

SQL Server T-SQL Tuning -TVF and Scalar Functions

A UDF is very convenient for centralising business logic as we can specify a set of business logic in one UDF which references multiple stored procedures and ad-hoc queries. However, they can lead to significant performance degradation due to their demands on the CPU  Read more...
By Additional Articles 2013/01/10 | Source: SQL Server Performance | Category: t-sql
Rating:  Rate this |   Briefcase | 3,746 reads

The Ultimate Missing Index Finder

Reports stats on what the query optimizer records in the DMVs as missing indexes and what it says the cost savings will be if they were present. Can limit by table / schema name patterns.  Read more...
By Jesse Roberge 2013/01/07 | Source: | Category: indexing
Rating: |  Discuss |   Briefcase | 18,907 reads

The Ultimate Index Usage Reporter

Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.  Read more...
By Jesse Roberge 2012/12/27 | Source: | Category: indexing
Rating: |  Discuss |   Briefcase | 7,558 reads

CPU and Scheduler Performance Monitoring using SQL Server and Excel

This article will demonstrate a method of creating an Excel-based CPU/scheduler performance dashboard for SQL Server 2005+.  Read more...
By Derek Colley 2012/10/04 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,256 reads

Use your own optimizer to tune queries

Use your own optimizer to tune queries 
By Gulli Meel 2012/06/07 | Source: | Category: custome statistics
Rating: |  Discuss |   Briefcase | 2,828 reads

Which SELECT * Is Better?

The short answer is, of course, none of them, but testing is the only way to be sure. I was asked,...  Read more...
By 2012/05/11 | Source: | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,529 reads

T-SQL Performance 1

By bitbucket-25253 2012/02/17 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,687 reads

What's the Point of Using VARCHAR(n) Anymore?

The arrival of the (MAX) data types in SQL Server 2005 were one of the most popular feature for the database developer. At the time, there was a lot of discussion as to whether this freedom from having to specify string length came at a cost. Rob attempts to give a final answer as to any down-side.  Read more...
By Additional Articles 2012/02/15 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 7,796 reads

Tips to Optimize Your SQL Statements - Part 1

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: | Category: performance tuning
Rating: |  Discuss |   Briefcase | 44,745 reads

Changes to SQL Server 2012 Execution Plans

I’ve been working with execution plans quite a lot in SQL Server 2012. There are a number of changes, most of them associated with new or different functionality. I had not noticed anything really fundamental until recently. I’ve become a huge proponent of always checking the properties of the SELECT statement. There’s so much useful information in there about what’s happened with the plan generation in the optimizer (not low level stuff, but the big picture items) that you should always be checking it first as a fundamental part of your plan examinations.  Read more...
By Grant Fritchey 2011/12/14 | Source: | Category: execution plans
Rating: (not yet rated)  Rate this |   Briefcase | 6,162 reads


This artcle attempts to differentiate between the uses of WITH RECOMPILE and OPTION (RECOMPILE) features.  Read more...
By Suresh Maganti 2011/07/07 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,334 reads

Slow in the Application, Fast in SSMS? Understanding Performance Mysteries

When I read various forums about SQL Server, I frequently see questions from deeply mystified posters. They have identified a slow query or stored procedure in their application. They cull the SQL batch from the application and run it in SQL Server Management Studio (SSMS) to analyse it, only to find that the response is instantaneous. At this point they are inclined to think that SQL Server is all about magic. A similar mystery is when a developer has extracted a query in his stored procedure to run it stand-alone only to find that it runs much faster – or much slower – than inside the procedure.  Read more...
Rating:  Rate this |   Briefcase | 4,780 reads

Do IF statements cause recompiles?

I heard this one over at SSC a while back. “Avoid IF statements in stored procedures as they result in...  Read more...
By Gail Shaw 2010/12/15 | Source: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,224 reads
   Items 1 to 20 of 138    Older >>
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)    
datatypes (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)