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

Content with tag Miscellaneous Rss

<< Newer    Items 21 to 40 of 1463    Older >>
 

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

Find SQL Server Install Date

Script to find the SQL Server Instance Install Date  Read more...
By Vijendran R 2010/05/07 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 2,898 reads

Reset count for all alerts

To see the frequency of alerts in use, you can reset their fire count. Restart count from zero for all alerts using the propre stored procedures.  Read more...
By Johan Bijnens 2009/12/22 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 319 reads

Find SQL Server Install Date

Script to find the SQL Server Instance Install Date  Read more...
By Vijendran R 2010/05/07 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 2,898 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,175 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,526 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,211 reads

Function to Add Leading 0's (Zeros) to an INT

Very simple function code to add leading zeros to a passed in int for a length also passed.  Read more...
By Joshua A. Walker 2009/03/05 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 1,572 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,423 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,652 reads

Function to Return Date and Time String for File Archiving

This function will return a string in sortable format YYYYMMDD-hhmmssnnn to append to file names for archiving.  Read more...
By Joshua A. Walker 2009/02/18 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 1,396 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,850 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 | 879 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 | 456 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,775 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,497 reads

Oracle and SQL Server Data Interoperability Issues - Part 1

As much as we're SQL Server folks here, sometimes we do need to connect to other data stores. Hai shares some of his experiences doing so. Might come in handy someday.   Read more...
By Haidong Ji 2008/06/06 (first published: 2004/04/14) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 45,595 reads

The Hazards of IT

Are you taking care of yourself as an IT professional? We try to cover all aspects of your SQL Server career here, not just the technical stuff. Longtime SQL Server guru Michael Coles brings us some health tips in an interview with Dr. Jerry Sanders   Read more...
By Michael Coles 2007/07/02 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,532 reads

From DBA to DBAA

Most of us DBAs have worked on our career to get where we are. A DBA is usually a second or third step in IT and we we've looked to advance our understanding of technology. Jeffrey Yao now brings us a new level of database work to which we may aspire.   Read more...
By Jeffrey Yao 2007/07/12 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 14,446 reads

Worst Practices - Not Using Primary Keys and Clustered Indexes

Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!   Read more...
By Andy Warren 2008/05/09 (first published: 2003/11/10) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 65,910 reads
<< Newer    Items 21 to 40 of 1463    Older >>
 
Tags
t-sql (497)    
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)    
management studio (ssms) (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)