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

Content with tag Miscellaneous Rss

   Items 1 to 20 of 1462    Older >>
 

Get all user def table info

Get space for all user defined table information like size and row counts.  Read more...
By Mohit Nayyar 2013/12/27 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 7,319 reads

Find Text in all columns of all tables in a Database

Will find the Table Name, Column Name and the number of occurances some text appears in a database.  Read more...
By Joshua A. Walker 2013/12/20 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,377 reads

Get the list of permissions of database object

List permissions for an object in various ways.  Read more...
By Deepthi Viswanathan Nair 2013/12/19 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 14,433 reads

Search All SQL Script Objects in All Databases for Text

Edit the @SearchText and you can enter any text you would like to search for in SQL Objects.  Read more...
By Joshua A. Walker 2013/05/21 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 2,633 reads

Function to Split Multivalued Parameter

This Function is written to split Multivalued Parameter passed by Reporting Services 2005.  Read more...
By Hari Sharma 2012/07/16 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 2,656 reads

Effectively mapping primary key – foreign key relations

This script maps the primary key - foreign key relations regardless if the column names are the same or not.  Read more...
By John Liu 2012/05/15 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 2,767 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,486 reads

Select from stored procedure

This terse script shows an easy (but "dirty" - so not advisable for production environments - rather for personal use) way to select data from stored procedure.  Read more...
By Rafal Skotak 2011/12/14 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 4,023 reads

Clear database - delete all records from a database (updated)

The procedure below deletes all records from the specified database's(except master, model, msdb and tempdb) tables (except those from the schema 'sys').  Read more...
By Rafal Skotak 2011/12/09 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 4,020 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,766 reads

Generating number sequences with Common Table Expressions

The script shows one of ways generating number sequence - this one uses CTE.  Read more...
By Rafal Skotak 2011/10/04 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 1,780 reads

How to Test Connectivity for a Linked Server

Just one way of testing for a linked server based on data within your database.  Read more...
By Chris Morton 2011/09/16 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 2,546 reads

Table row count using 3 different ways

Three different ways that you can get the count of the rows in a table.  Read more...
By Mohit Nayyar 2011/06/16 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,422 reads

Get all user def table info

Get space for all user defined table information like size and row counts.  Read more...
By Mohit Nayyar 2013/12/27 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 7,319 reads

Row count and space used for all tables in database (update)

This procedure works like the sp_spaceused procedure but this one shows statistics for all tables in the selected database or for all databases (excluding tempdb and model).   Read more...
By Rafal Skotak 2011/05/25 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,808 reads

Get the list of permissions of database object

List permissions for an object in various ways.  Read more...
By Deepthi Viswanathan Nair 2013/12/19 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 14,433 reads

Find Text in all columns of all tables in a Database

Will find the Table Name, Column Name and the number of occurances some text appears in a database.  Read more...
By Joshua A. Walker 2013/12/20 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,377 reads

Internals and Performance class in Dallas

  At last, my blog is starting to pay real dividends. Not only do I get the opportunity to publish my...  Read more...
By Martin Catherall 2011/01/28 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,321 reads

Find SQL Server TCP/IP Port Number

Script to find the TCP/IP Port number of SQL Instance  Read more...
By Vijendran R 2010/05/13 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 3,510 reads
   Items 1 to 20 of 1462    Older >>
 
Tags
t-sql (496)    
maintenance and management (333)    
programming (152)    
sqlinsider scripts (131)    
sql server 7 (124)    
strategies (84)    
career (71)    
data warehousing (69)    
backup / restore (60)    
administration (55)    
database design (46)    
indexing (44)    
xml (32)    
lock and connection management (25)    
performance tuning (22)    
visual basic 6 (22)    
configuring (21)    
stored procedures (21)    
replication (20)    
sql server 2005 (20)    
mail (16)    
security (15)    
ado (13)    
advanced querying (11)    
.net (9)    
basics (9)    
dts (9)    
monitoring (9)    
best and worst practices (8)    
sql-dmo (6)    
system development life cycle (6)    
worst practices (6)    
availability (5)    
development (5)    
reviews (5)    
book reviews (4)    
certifications (4)    
installation (4)    
naming standards (4)    
other (4)    
state of the business (4)    
analysis services (ssas) (3)    
asp (3)    
dba (3)    
disaster recovery (dr) (3)    
news (3)    
nums (3)    
olap server (3)    
openxml (3)    
sql puzzles (3)    
table of numbers (3)    
tally (3)    
updategrams (3)    
user defined function (udf) (3)    
xsl (3)    
access (2)    
advanced (2)    
best practices (2)    
counter (2)    
distributed queries (2)    
english query (2)    
function (2)    
rants (2)    
sql server 6.5 (2)    
sqlservercentral (2)    
table (2)    
triggers (2)    
archive file (1)    
archiving (1)    
blogs (1)    
bugs (1)    
c++ (1)    
chris morton (1)    
codrakon (1)    
columns (1)    
data (1)    
data mining (1)    
data types (1)    
date (1)    
dba code (1)    
design and theory (1)    
foreign keys (fk) (1)    
full-text search (2005) (1)    
games (1)    
identity property (1)    
integration services (ssis) (1)    
linked server (1)    
management (1)    
prime (1)    
prime number (1)    
product reviews (1)    
puzzle (1)    
reporting services (ssrs) (1)    
schemas/dtds (1)    
scripts (1)    
semaphore (1)    
sieve (1)    
sql server 2008 (1)    
tables (1)    
time (1)    
training (1)    
utility (1)    
views (1)    
warehouse (1)