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

Content with tag Performance Tuning Rss

<< Newer    Items 61 to 80 of 549    Older >>
 

Get Performance Tips Directly From SQL Server

This article describes a utility that allows you to inspect cached plans and extract information that can be useful in improving the performance of your SQL.  Read more...
By Ian Stirk 2012/06/22 (first published: 2009/06/11) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 46,589 reads

ETL Performance Auditing - Part 3: Auditing Data Warehouse Phase

Easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.  Read more...
By Frank A. Banin 2014/11/14 (first published: 2012/06/19) | Source: SQLServerCentral.com | Category: business intelligence
Rating: |  Discuss |   Briefcase | 7,176 reads

SQL Server Prefetch and Query Performance

Prefetching can make a surprising difference to SQL Server query execution times where there is a high incidence of waiting for disk i/o operations, but the benefits come at a cost. Mostly, the Query Optimizer gets it right, but occasionally there are queries that would benefit from tuning.   Read more...
By Additional Articles 2012/06/14 | Source: SimpleTalk
Rating: (not yet rated)  Rate this |   Briefcase | 3,729 reads

ETL Performance Auditing - Part 2: Auditing Data Staging Phase

Easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.  Read more...
By Frank A. Banin 2014/11/07 (first published: 2012/06/12) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,149 reads

Use your own optimizer to tune queries

Use your own optimizer to tune queries  Read more...
By Gulli Meel 2012/06/07 | Source: SQLServerCentral.com | Category: custome statistics
Rating: |  Discuss |   Briefcase | 2,797 reads

Re-compilation and Its effects on Performance

How recompilation does significantly affect on the execution time of SQL query and plummet or degrade the performance?   Read more...
By at yazdani 2012/06/07 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 8,101 reads

The Real World: Implementing AWE

Describes the gains experienced in my environment by impleenting AWE.  Read more...
Rating: |  Discuss |   Briefcase | 7,949 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: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,437 reads

Performance Test of New Date Manipulation Functions (SQL Spackle)

Performance test of new SQL 2012 functions DateTimeFromParts and Format  Read more...
By Wayne Sheffield 2012/05/10 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 5,914 reads

The Clonesome Database

You need a quiet couple of hours poking about with DMVs, and checking execution plans to get to the bottom of the a query issue, but you can't make a copy the production database either. It's too big, and the data is private....  Read more...
By Phil Factor 2012/03/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 198 reads

ROWLOCK Escalation

By Chris Fradenburg 2012/03/19 | Category: table hint
Rating: (not yet rated) |  Discuss |   Briefcase | 2,278 reads

Get Top Queries Taxing SQL Server CPUs

Script which uses SQL Server DMOs to gather top CPU taxing queries which can benifit most from tuning.  Read more...
By Prakash Heda 2012/03/10 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 2,640 reads

View Active Session SQL

This script can be used to view current SQL statements being executed for all or any one SPID.  Read more...
By David Kranes 2014/01/06 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,159 reads

T-SQL Performance 1

By bitbucket-25253 2012/02/17 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,671 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,721 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,733 reads

Database Performance Transparency

Describes the benefits of publishing instance performance metrics including a script to generate HTML-based Performance Snapshot.  Read more...
By Ron Johnson 2012/02/08 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 6,794 reads

A Computed Column Defined with a User-Defined Function Might Impact Query Performance

A benefit of using computed columns is that they can save developers from having to write calculation logic at the application layer; at the table level, the application can simply reference the computed column. In addition, performance can be improved by persisting a computed column and building an index on it.  Read more...
By Additional Articles 2012/02/03 | Source: SQLCAT | Category: computed columns
Rating:  Rate this |   Briefcase | 2,351 reads

A google like search

A conceptual proof for a google like search procedure  Read more...
By Jean Bulinckx 2012/02/02 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 3,537 reads

RECONFIGURE can flush the procedure cache

I ran across this KB article the other day, which lists a few ways in which performance is affected by...  Read more...
By 2012/01/24 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,579 reads
<< Newer    Items 61 to 80 of 549    Older >>
 
Tags
sql server 7 (121)    
t-sql (113)    
sql server 2005 (46)    
administration (45)    
indexing (45)    
blogs (23)    
miscellaneous (22)    
configuring (15)    
programming (15)    
hardware (13)    
stored procedures (13)    
database design (11)    
dmv (11)    
editorial (11)    
maintenance (11)    
monitoring (11)    
sql server 2008 (11)    
utility (11)    
maintenance and management (10)    
sql server 6.5 (9)    
advanced querying (8)    
troubleshooting (8)    
ado (7)    
strategies (7)    
database weekly (6)    
execution plans (6)    
xml (6)    
backup / restore (5)    
list indexes (5)    
pivot (5)    
profiler (5)    
search (5)    
sqlservercentral (5)    
sys.dm_db_partition_stats (5)    
basics (4)    
crosstab (4)    
for xml path (4)    
integration services (ssis) (4)    
leadership (4)    
professional development (4)    
replication (4)    
reporting services (ssrs) (4)    
security (4)    
visual basic 6 (4)    
webinar (4)    
.net (3)    
analysis services (ssas) (3)    
availability (3)    
cpu (3)    
data types (3)    
dts (3)    
foreign keys (fk) (3)    
i/o (3)    
indexed views (3)    
paging (3)    
sql server (3)    
sql server 2012 (3)    
sqlclr (3)    
storage (3)    
storage management (3)    
user defined function (udf) (3)    
architecture (2)    
blocking (2)    
computed columns (2)    
cursors (2)    
data warehousing (2)    
deadlock (2)    
distributed queries (2)    
etl (2)    
fundamentals (2)    
fuzzy match (2)    
installation (2)    
io (2)    
lock and connection management (2)    
locking (2)    
memory tuning (2)    
openxml (2)    
pagination (2)    
query plans (2)    
row compression (2)    
sql monitor (2)    
statistics (2)    
sys.dm_exec_query_plan (2)    
sys.dm_exec_requests (2)    
sys.dm_exec_sessions (2)    
sys.dm_exec_sql_text (2)    
tools (2)    
training (2)    
triggers (2)    
tuning (2)    
addressing windows extensions (1)    
affinity (1)    
algorithm (1)    
asp (1)    
auditing (1)    
awe (1)    
batch requests per sec (1)    
batching (1)    
best practices (1)    
bi (1)    
big data (1)    
brad mcgehee (1)    
buffer cache hit ratio (1)    
business intelligence (1)    
cached execution plan (1)    
case studies (1)    
change data capture (cdc) (1)    
clustered index (1)    
compression (1)    
confio (1)    
connections (1)    
custom optimizaqtion (1)    
custome statistics (1)    
damerau-levenshtein (1)    
data flow task (1)    
database i/o (1)    
database mirroring (1)    
database performance analyzer (1)    
database snapshots (1)    
datetimefromparts (1)    
dbcc checkdb (1)    
dmo (1)    
dmvs (1)    
dmv's (1)    
dpa (1)    
duplicate indexes (1)    
ebook (1)    
edit distance (1)    
editorial - mp3 (1)    
english query (1)    
excel (1)    
execution plan (1)    
extended events (1)    
fetch (1)    
fnord (1)    
formatting (1)    
fuzzy-string (1)    
google (1)    
graphs (1)    
hard disk (1)    
heap (1)    
host bus adapter (1)    
hp eva (1)    
html (1)    
idle (1)    
ignite (1)    
implicit conversion (1)    
indicators (1)    
internals (1)    
ip addresses (1)    
ipv4 addresses (1)    
isolation levels (1)    
kpi (1)    
large data sets (1)    
latch waits per sec (1)    
like (1)    
linked server (1)    
lock escalation (1)    
lock pages in memory (1)    
lock waits per sec (1)    
logins (1)    
logouts (1)    
loop (1)    
memory (1)    
memory grants (1)    
memory management (1)    
merge join performance merge join alogrithm (1)    
metrics (1)    
missing indexes (1)    
name value pair (1)    
naming standards (1)    
news (1)    
nhibernate (1)    
number of deadlocks per sec (1)    
off-topic (1)    
olap server (1)    
online re-indexing (1)    
optimization (1)    
other (1)    
pae (1)    
page life expectancy (1)    
page splits (1)    
parameter sniffing (1)    
parameterized queries (1)    
partition (1)    
partition alignment (1)    
partitioning (1)    
perfmon (1)    
performance metrics (1)    
physical address extensions (1)    
policy based management (pbm) (1)    
procedural programming (1)    
procedure (1)    
procedure cache (1)    
query hint (1)    
query optimization (1)    
query performance (1)    
raid (1)    
resource governor (1)    
reverse (1)    
row_number() (1)    
rss (1)    
san (1)    
sas (1)    
sata (1)    
scale-out (1)    
schedulers (1)    
selectivity (1)    
server side trace (1)    
set based (1)    
shrink database (1)    
solarwinds (1)    
sp writing tips (1)    
sp_blitz (1)    
sql puzzles (1)    
sql server agent (1)    
sql trace (1)    
sqlite (1)    
star schemas (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)    
system monitor (1)    
table compression (1)    
table hint (1)    
table hints (1)    
table scan (1)    
tables (1)    
tempdb (1)    
temporary tables (1)    
test data (1)    
tips and tricks (1)    
top cpu queries (1)    
total latch wait time (1)    
trace (1)    
transaction logs (1)    
transactions (1)    
tvp (1)    
udt (1)    
update (1)    
update statistics (1)    
updategrams (1)    
vmware (1)    
waits and queues (1)    
what queries are running (1)    
where (1)    
while loop (1)    
window functions (1)    
wmi query (1)    
xevents (1)    
xsl (1)    
your own optimizer (1)