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


 

Content with tags t-sql, administration Rss

<< Previous 20    Items 41 to 60 of 123    Next 20 >>
 

The Ultimate Index Lister (Pivoted)

Lists details for all indexes on one or more tables / schemas, including row count and size. This version outputs the member seek + include columns as two comma separated output columns.  Read more...
By Jesse Roberge 2008/10/09 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,339 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 2008/10/07 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,790 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: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 17,607 reads

Permission scripting over all databases

Scripts permissions/roles for db user across all databases.  Read more...
By W Louw 2013/05/19 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 10,795 reads

Switching tables

Switching tables describe the scenario of 2 tables containning data; while making a process on one tables the other table can continue and function in front of some application.  Read more...
By tomer lev 2008/09/05 | Source: SQLServerCentral.com | Category: locking
Rating: |  Discuss |   Briefcase | 867 reads

The Ultimate Precompiled Procedure Searcher

Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.  Read more...
By Jesse Roberge 2009/10/08 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,806 reads

The Ultimate Foreign Key Researcher

Searches for actual and potential foreign key columns for a given primary key reference.  Read more...
By Jesse Roberge 2009/10/12 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,400 reads

public access to extended SP's

check public access to extended stored procedures  Read more...
By Mani Singh 2008/08/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 862 reads

Just For Fun: An Impossible Delete

How can you delete only some duplicates? Without Identity's, Temp tables, Cursors, loops or ROW_NUMBER()? Would you believe, go back to the 70's?  Read more...
By RBarry Young 2009/10/30 (first published: 2008/08/05) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 31,997 reads

Grant Permission to Specific objects(e.g. SP's)

Grant permissions to specific objects in Database using dynamic SQL.  Read more...
By Mani Singh 2008/08/01 | Source: SQLServerCentral.com | Category: administrator
Rating: |  Discuss |   Briefcase | 2,392 reads

Search for a String in all Stored Procedures and beyond?

Search for String Occurence with this script in your stored procedures.  Read more...
By Mani Singh 2011/10/20 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 4,721 reads

Finding and Listing ALL Procedures, Functions, and Views in SQL Server 2005

James Rea brings us another great article that shows you how to keep on top of the code that's stored in each of your databases.  Read more...
By James Rea 2008/07/28 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 13,787 reads

Return Query Text Along With sp_who2 Using SQL 2000

This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".  Read more...
By Ken Simmons 2008/07/18 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 7,620 reads

usp_addcolumns

This is a stored procedure to add a columns to multiple tables, if column doesn't exist  Read more...
By Wilfred van Dijk 2008/07/01 | Category: t-sql
Rating: |  Discuss |   Briefcase | 583 reads

Column Level Permissions

GRANT Column Level Permissions  Read more...
By Mani Singh 2013/05/19 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,504 reads

Modify columns' name in batches

Modify columns' name in batches.  Read more...
By hxd001_810-512717 2008/02/14 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 949 reads

How to empty database

Sometimes you need to empty the content of database. Following script can do that for you.  Read more...
By Boka 2013/05/19 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,297 reads

Using the OUTPUT Clause to Capture Identity Values on Multi-Row Insert

SQL Server 2005 introducted the OUTPUT clause which we can use to capture values from the inserted and deleted virtual tables.  Read more...
By Additional Articles 2006/08/25 | Source: SQLTeam.com | Category: advanced querying
Rating:  Rate this |   Briefcase | 3,863 reads

Attach and Detach..Again

Attaching and detaching databases is old hat these days right? Do you know how to reattach a database that has more than 16 files? Or do you know what happens if you try to reattach a database that had two log files but one is missing/deleted? And even if you know the answer to that - do you know how to fix it without restoring from backup? Maybe it's not ALL old hat just yet!   Read more...
By Andy Warren 2006/06/23 (first published: 2002/04/05) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 24,171 reads

SQL 2000 DBA Toolkit Part 4

In the final installment of his series, Michael Coles examines a few other functions in his SQL Server 2000 toolkit to help you with other functions, like reading a directory on your server. Read the series and send some feedback to make this THE premier toolset for SQL Server 2000 DBAs.   Read more...
By Michael Coles 2006/05/04 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 13,969 reads
<< Previous 20    Items 41 to 60 of 123    Next 20 >>
 
Tags
sql server 7 (56)    
miscellaneous (26)    
maintenance and management (25)    
sql server 2005 (25)    
utility (25)    
maintenance (19)    
performance tuning (18)    
advanced querying (15)    
configuring (13)    
indexing (13)    
stored procedures (13)    
programming (11)    
strategies (10)    
monitoring (9)    
search (9)    
automated dba (7)    
storage (7)    
sys.dm_db_partition_stats (7)    
tables (7)    
database design (6)    
security (6)    
backup / restore (5)    
list indexes (5)    
pivot (5)    
auto-growth (4)    
crosstab (4)    
data file management (4)    
for xml path (4)    
installation (4)    
routine database growth (4)    
routine growth (4)    
sys.allocation_units (4)    
visual basic 6 (4)    
dts (3)    
permissions (3)    
space usage (3)    
sql-dmo (3)    
triggers (3)    
administrator (2)    
buffer cache (2)    
columns (2)    
grant (2)    
lock and connection management (2)    
naming standards (2)    
script (2)    
sql puzzles (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)    
user defined function (udf) (2)    
.net (1)    
aggregates (1)    
backup/restore (1)    
basics (1)    
best and worst practices (1)    
connectivity (1)    
database mirroring (1)    
databases (1)    
dba (1)    
development (1)    
diagnostic (1)    
distributed queries (1)    
duplicate indexes (1)    
english query (1)    
extended stored procedures (1)    
filegroups (1)    
foreign keys (fk) (1)    
growth trend (1)    
indexed views (1)    
linked servers (1)    
locking (1)    
logins (1)    
missing indexes (1)    
multi process (1)    
object permissions (1)    
openxml (1)    
product reviews (1)    
public (1)    
replication (1)    
report (1)    
reviews (1)    
role (1)    
running aggregate (1)    
running totals (1)    
scripting (1)    
selectivity (1)    
service packs (1)    
sql server 2008 (1)    
sql server 6.5 (1)    
sqlclr (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)    
system development life cycle (1)    
updategrams (1)    
user (1)    
worst practices (1)    
xml (1)    
xsl (1)    
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.