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

Content with tags T-SQL, Miscellaneous Rss

   Items 1 to 20 of 574    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

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,485 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

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

BCP Format File Builder

Utility stored procedure to create non-xml format file for BCP/BULK INSERT processes. Very useful for text-qualified CSV files.  Read more...
By Paul Hunter 2009/08/14 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 2,136 reads

Prime Number Table Generator (new ver crunches to 1 Mil in <10.5 sec!)

Generates prime numbers and puts them into a table for future reference by adhoc queries and database and application code. 100% set-based. DDL embedded.  Read more...
By Jesse Roberge 2009/07/15 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 1,208 reads

Yet Another Deleting Duplicate Records (in-place)

Here is another "deleting duplicate records" script, this time in-place, using a uniqueidentifier column.  Read more...
By Peter Petrov 2009/01/15 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 1,846 reads

Counter Table (table of numbers) Setter-Upper for SQL Server 2005

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 622, 386884, and 240641848 numbers.  Read more...
By Jesse Roberge 2008/08/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 878 reads

Counter Table (table of numbers) Setter-Upper for SQL Server 2000

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers.  Read more...
By Jesse Roberge 2008/08/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 454 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

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,485 reads

New Column Updates

What is the fastest way to update a newly created column in a large table? New author Bimal Fernando brings us a look at a technique he uses for just this situation.   Read more...
By Bimal Fernando 2007/05/21 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 7,706 reads

Generating permutations - procedure

This procedure prepares a query for generating permutations of n-numbers set and executes it.  Read more...
By Rafal Skotak 2008/03/18 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 895 reads

Keyword Searching in SQL Server

Have you ever wanted to ensure that keywords in your data are easily searchable? Have you struggled with full-text search? New author Michael Ahmadi brings us an interesting idea for a keyword tracking and searching subsystem based on T-SQL and triggers.   Read more...
By Michael Ahmadi 2007/04/09 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 10,382 reads

Running a Query Using a Text File for Input

When automating administrative actions for SQL Server, there are a number of ways to handle the workflow. Longtime SQL Server DBA Roy Carlson brings us a technique for using a text file as input to the standard SQL Server tools.   Read more...
By Roy Carlson 2007/03/01 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 15,110 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
   Items 1 to 20 of 574    Older >>
 
Tags
maintenance and management (162)    
sqlinsider scripts (106)    
programming (45)    
sql server 7 (44)    
backup / restore (28)    
administration (26)    
data warehousing (24)    
indexing (24)    
stored procedures (20)    
strategies (14)    
performance tuning (13)    
advanced querying (11)    
configuring (10)    
lock and connection management (10)    
visual basic 6 (9)    
xml (9)    
sql server 2005 (8)    
database design (7)    
replication (7)    
security (7)    
mail (6)    
monitoring (6)    
basics (5)    
ado (4)    
development (4)    
sql-dmo (4)    
.net (3)    
best and worst practices (3)    
installation (3)    
nums (3)    
openxml (3)    
sql puzzles (3)    
table of numbers (3)    
tally (3)    
updategrams (3)    
user defined function (udf) (3)    
counter (2)    
dts (2)    
naming standards (2)    
news (2)    
table (2)    
triggers (2)    
worst practices (2)    
xsl (2)    
analysis services (ssas) (1)    
asp (1)    
best practices (1)    
distributed queries (1)    
english query (1)    
full-text search (2005) (1)    
games (1)    
prime (1)    
prime number (1)    
puzzle (1)    
schemas/dtds (1)    
semaphore (1)    
sieve (1)    
sql server 2008 (1)    
utility (1)