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

   Items 1 to 20 of 536    Older >>
 

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2014/07/23 (first published: 2013/08/21) | Source: Red-Gate | Category: performance tuning
Rating:  Rate this |   Briefcase | 26,416 reads

SQL Server Performance Tuning with Hypothetical Indexes

Daniel Farina demonstrates how to create and test hypothetical indexes with the undocumented DBCC AUTOPILOT command.  Read more...
By Additional Articles 2014/06/13 | Source: MSSQLTips.com | Category: tips and tricks
Rating: (not yet rated)  Rate this |   Briefcase | 2,831 reads

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: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 6,060 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2014/07/23 (first published: 2013/08/21) | Source: Red-Gate | Category: performance tuning
Rating:  Rate this |   Briefcase | 26,416 reads

PBM Policy / WMI query to see which CPUs are in power-saving mode

A simple PBM policy which uses WMI to find out if the CPUs in the target are running at their maximum clock speed.  Read more...
By Ben Whitman 2014/02/13 | Source: SQLServerCentral.com | Category: cpu
Rating: |  Discuss |   Briefcase | 1,347 reads

Analysis Services Tabular

By Steven Neumersky 2014/02/06 | Category: performance tuning
Rating: (not yet rated) |  Discuss |   Briefcase | 1,338 reads

NameSQLinConfioIgnite

This will name Ignite SQL hashes that have not been named yet, based on the object (or batch) they are within.  Read more...
By Thomas Keller 2014/02/05 | Source: SQLServerCentral.com | Category: performance tuning
Rating: (not yet rated) |  Discuss |   Briefcase | 562 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2014/07/23 (first published: 2013/08/21) | Source: Red-Gate | Category: performance tuning
Rating:  Rate this |   Briefcase | 26,416 reads

Fuzzy-String Search: Find misspelled information with T-SQL

An optimized Damerau-Levenshtein Distance (DLD) algorithm for "fuzzy" string matching in Transact-SQL 2000-2008  Read more...
By Thomas Keller 2014/01/10 (first published: 2012/09/18) | Source: SQLServerCentral.com | Category: fuzzy match
Rating: |  Discuss |   Briefcase | 23,338 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,100 reads

Set Up And Schedule a Server Side Trace

How to use Profiler to generate TSQL scripts that can be modified and automated to run as a server-side trace  Read more...
By Grant Fritchey 2013/12/31 (first published: 2010/12/02) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 10,209 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2014/07/23 (first published: 2013/08/21) | Source: Red-Gate | Category: performance tuning
Rating:  Rate this |   Briefcase | 26,416 reads

Using Indexes to Reduce Blocking in Concurrent Transactions

New author Nilav Ghosh brings us a performance tuning article to help your queries run better. This article examines how indexes can help reduce blocking.  Read more...
By Nilav Baran Ghosh 2013/11/15 (first published: 2009/07/07) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 17,955 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: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,558 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2014/07/23 (first published: 2013/08/21) | Source: Red-Gate | Category: performance tuning
Rating:  Rate this |   Briefcase | 26,416 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: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,188 reads

Parameter Sniffing and Sniffing Memory

This article aims to demonstrate bad parameter sniffing and its effects on memory grants.  Read more...
By SQLSACT 2013/07/15 | Source: SQLServerCentral.com | Category: parameter sniffing
Rating: |  Discuss |   Briefcase | 6,690 reads

Performance Tuning in the Age of Big Data

Database Administrators must now deal with large volumes of data and new forms of high-speed data analysis. If your responsibility includes performance tuning, here are the areas to focus on that will become more and more important in the age of Big Data.  Read more...
By Additional Articles 2013/07/02 | Source: Database Journal | Category: big data
Rating:  Rate this |   Briefcase | 2,777 reads

Finding queries to tune

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

Indexed Views

This article will show you the importance of Indexed Views and how they can help performance.  Read more...
By Sarvesh Singh 2013/05/10 (first published: 2010/11/16) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 23,955 reads
   Items 1 to 20 of 536    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)    
.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)    
webinar (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 (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 snapshots (1)    
datetimefromparts (1)    
dbcc checkdb (1)    
dmo (1)    
dmvs (1)    
dmv's (1)    
duplicate indexes (1)    
ebook (1)    
edit distance (1)    
editorial - mp3 (1)    
english query (1)    
excel (1)    
extended events (1)    
fetch (1)    
fnord (1)    
format (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)    
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)    
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 partitioning (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)    
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)