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


 

Content with tags T-SQL, SQL Server 2005 Rss

   Items 1 to 20 of 121    Next 20 >>
 

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: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 17,689 reads

Generate Drop / Create Script for views, stored Procedures

This Script generates drop and create scripts for views or stored procedures.  Read more...
By Kenneth Nielsen 2013/01/01 | Source: SQLServerCentral.com | Category: maintenance and management
Rating: |  Discuss |   Briefcase | 5,443 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: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 7,228 reads

Understanding and Using APPLY (Part 2)

The second of a series by Paul White examining the APPLY operator. In this section learn how this operator compares with joins and about both the cross and outer options.  Read more...
By Paul White 2012/01/13 (first published: 2010/04/19) | Source: SQLServerCentral.com | Category: apply
Rating: |  Discuss |   Briefcase | 19,528 reads

Understanding and Using APPLY (Part 1)

The first of a two-part series of articles examining the APPLY operator. Learn the basics of how this operator works and how it can help you solve some tricky problems.  Read more...
By Paul White 2012/01/06 (first published: 2010/04/12) | Source: SQLServerCentral.com | Category: apply
Rating: |  Discuss |   Briefcase | 32,987 reads

A Sudoku solution with set based T-SQL utilizing binary operators

A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.  Read more...
By Kevin Duan 2011/12/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,420 reads

Check Instance Info

Named or default instance, this will check info like Virtual Server Name, Cluster Name , Current owner, Preferred Owner? and? Status? (if clustered) and IP/Port for the current instance.  Read more...
By Pedro Lopes MS 2011/12/15 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 3,317 reads

Proc to Rename a file

A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.  Read more...
By Simon Facer 2011/10/28 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 2,736 reads

Using TOP To Rank Columns In a Table

This article covers the use of the TOP clause to select data from a table based on the TOP n columns in a table.  Read more...
By Tim Parker 2011/10/25 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 6,281 reads

Index Fragmentation

This stored procedure is capable of performing defragmentation indices with avg_fragmentation_in_percent greater than the threshold passed.  Read more...
By Sergio Govoni 2011/10/21 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 3,982 reads

Parse the dependency chain of an object

Parses up & down the dependency chain of an object.  Read more...
By Jesse McLain 2011/09/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,089 reads

In-CASE you need to SUM...

Read more...
By BenWard 2011/07/11 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,117 reads

Tic Tac Toe TSQL Style

This allows a player to play tic tac toe against an automated computer.  Read more...
By Adam Haines 2011/04/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,681 reads

Deleting Large Number of Records

Often someone will try to perform a delete on a large number of records and run into a number of problems. Slow performance, log growth, and more. Lynn Pettis shows us how to better handle this situation in SQL Server 2000 and SQL Server 2005  Read more...
By Lynn Pettis 2011/02/18 (first published: 2009/09/15) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 48,242 reads

What's the best way to count?

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

Way to Check Multiple LIKE without dynamic SQL

I was asked to do so by one of my colleague. So, I thought to share it with you how to use multiple LIKE conditions.  Read more...
By Atif-ullah Sheikh 2010/09/16 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 3,386 reads

Retreive the Schema of a Stored Procedure or Function

This script shows you code that retrives schema of a routine (Stored procedure or a function).   Read more...
By Anthony peiris 2010/09/09 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,889 reads

Count Number of Words and Characters

Count Number of Words and Characters  Read more...
By Atif-ullah Sheikh 2010/07/27 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 2,023 reads

Simple Crosstab Procedure with Power

Create crosstab queries as easily as MS Access with a lot more power.  Read more...
By cgruel 2010/06/02 | Source: SQLServerCentral.com | Category: crosstab
Rating: |  Discuss |   Briefcase | 3,077 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,436 reads
   Items 1 to 20 of 121    Next 20 >>
 
Tags
administration (25)    
maintenance and management (23)    
utility (22)    
maintenance (16)    
performance tuning (13)    
advanced querying (12)    
indexing (10)    
development (9)    
miscellaneous (8)    
search (8)    
nums (7)    
sql server 2008 (7)    
sqlinsider scripts (7)    
sys.dm_db_partition_stats (7)    
table of numbers (7)    
tally (7)    
counter (6)    
pivot (6)    
sql server 7 (6)    
string manipulation (6)    
tables (6)    
arrays (5)    
automated dba (5)    
crosstab (5)    
delimited strings (5)    
list indexes (5)    
parse (5)    
storage (5)    
for xml path (4)    
stored procedures (4)    
sys.allocation_units (4)    
space usage (3)    
2-dimensional arrays (2)    
apply (2)    
auto-growth (2)    
buffer cache (2)    
data file management (2)    
games (2)    
lock and connection management (2)    
routine database growth (2)    
routine growth (2)    
sys.dm_exec_query_plan (2)    
sys.dm_exec_requests (2)    
sys.dm_exec_sessions (2)    
sys.dm_exec_sql_text (2)    
sys.dm_os_buffer_descriptors (2)    
sys.partitions (2)    
troubleshooting (2)    
aggregates (1)    
auditing (1)    
blob manipulation (1)    
columns (1)    
common language runtime (clr) (1)    
cte (1)    
delete (1)    
dm_db_index_physical_stats (1)    
duplicate indexes (1)    
foreign keys (fk) (1)    
growth trend (1)    
ids to table (1)    
indexed views (1)    
information_schema (1)    
management (1)    
missing indexes (1)    
paging (1)    
parameters (1)    
prime (1)    
prime number (1)    
procedure (1)    
puzzle (1)    
report (1)    
running aggregate (1)    
running totals (1)    
security (1)    
selectivity (1)    
sieve (1)    
solo (1)    
sql server 2000 (1)    
sqlclr (1)    
strategies (1)    
string to table (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_tran_session_transactions (1)    
sys.foreign_key_columns (1)    
sys.foreign_keys (1)    
sys.sql_modules (1)    
syscolumns (1)    
sysobjects (1)    
table (1)    
top (1)    
xml (1)    
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.