SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Content with tag Miscellaneous Rss

Refine your search with one of the following additional tags (with number of items):

T-SQL Aids (385)     SQL Server 2005 (17)     Other (4)     SQLServerCentral.com (2)    
Maintenance and Management (335)     Security (15)     State of the Business (4)     SS2K5 - XML (2)    
Programming (152)     Basic Querying (14)     Analysis Services (3)     Triggers (2)    
SQLInsider Scripts (129)     ADO (13)     ASP (3)     Bugs (1)    
SQL Server 7, 2000 (120)     Indexing (10)     Disaster Recovery (3)     C++ (1)    
T-SQL (107)     .Net (9)     News (3)     Data Mining (1)    
Strategies (84)     Backup and Recovery (9)     OLAP Server (3)     Data Types (1)    
Career (71)     Basics (9)     OpenXML (3)     Design (1)    
Administering (53)     DTS (9)     SQL Puzzles (3)     Foreign Key (1)    
Backup / Restore (52)     Monitoring (9)     UpdateGrams (3)     Full-Text Search (2005) (1)    
Database Design (46)     Advanced Querying (8)     User-Defined functions (3)     games (1)    
Data Warehouse (41)     Best and Worst Practices (8)     XSL (3)     Management (1)    
Index Management (35)     Performance Tuning (7)     Access (2)     Product Reviews (1)    
XML (32)     SQL-DMO (6)     Administration (2)     Puzzle (1)    
Data Warehousing (28)     System Development Life Cycle (6)     Advanced (2)     Reporting Services (1)    
Lock and Connection Management (26)     Worst Practices (6)     Best Practices (2)     Schemas/DTDs (1)    
Visual Basic 6 (22)     Availability (5)     Development (2)     Scripts (1)    
Configuring (21)     Reviews (5)     Distributed Queries (2)     Semaphore (1)    
Replication (21)     Book Reviews (4)     English Query (2)     SQL Server 2005 - SSIS (1)    
Stored Procedures (20)     Certifications (4)     Rants (2)     SQL Server 2005 - TSQL (1)    
Mail (17)     Installation (4)     SQL Server 2000 (2)     SQL Server 2008 (1)    
Performance Tuning and Scaling (17)     Naming Standards (4)     SQL Server 6.5 (2)    
   Items 1 to 20 of 1261    Next 20 >>
 

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 2008/06/17 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 15 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 2008/06/09 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 100 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 posted: 2004/04/14) | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 35,552 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 | 7,725 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 | 13,573 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 posted: 2003/11/10) | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 59,934 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 S. 2008/05/02 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 1,240 reads

Is XML the Answer?

New Author! Don Peterson writes his first article for us and explores why he considers XML to be...bad! There are some interesting points made here and if you've haven't thought about what XML means to you as a DBA, it's a subject worth spending some time on.   Read more...
By Don Peterson 2008/05/02 (first posted: 2003/10/07) | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 63,261 reads

Free Encryption

Free SQL Server 2000 Encryption for your data!!! Author Michael Coles has put together a tolljit and some XPs that you can use to encrypt your data with the Blowfish algorithm. It is hard to write good applications that encrpyt data and manage the keys and security. This will give you a great headstart on protecting your data.   Read more...
By Michael Coles 2008/04/25 (first posted: 2005/07/21) | Source: SQLServerCentral.com | Category: Security
Rating: |  Discuss |  Briefcase | 66,561 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 S. 2008/04/23 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 1,243 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 S. 2008/04/14 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 1,240 reads

Free Tools for the SQL Server DBA

Everyone has a set of handy utilities and tools that they use with their SQL Server, but sometimes convincing an employer to purchase tools is hard. Longtime DBA David Bird brings us a list of the tools he likes to use and are FREE.   Read more...
By David Bird 2007/05/24 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 39,018 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 | 6,638 reads

Show all database's tables' columns' collations.

Created view displays all text columns' collations in the current database with the information whether the collation is different from the database's one.  Read more...
By Rafal S. 2008/04/04 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 460 reads

Generating combinations 'm elements from n-element set'

This procedure generates a dataset with combinations of elements_to_select taken from number_of_values element set. It prints also the prepared query.   Read more...
By Rafal S. 2008/04/01 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 304 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 S. 2008/03/31 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: (not yet rated) |  Discuss |  Briefcase | 540 reads

2007 Tech Salary Survey Results

Dice.com recently completed a salary survey for 2007. If you didn't participate, Steve Jones summarizes the results for DBAs.   Read more...
By Steve Jones 2007/04/03 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 9,666 reads

Generating permutations - procedure

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

A Common Architecture for Loading Data

Importing data files is always a challenge for a DBA, especially when the files might vary in format. Having one codebase is important and new author Mark Balasundram brings us the template for a high performance application to do just that.   Read more...
By Mark Balasundram 2007/04/04 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 15,669 reads

Search for a text in all databases

This procedure searches for a specified text in all (or one selected) databases in all (or selected) tables.  Read more...
By Rafal S. 2008/03/12 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 811 reads
   Items 1 to 20 of 1261    Next 20 >>
 
Most popular

Free Tools for the SQL Server DBA

Everyone has a set of handy utilities and tools that they use with their SQL Server, but sometimes convincing an employer to purchase tools is hard. Longtime DBA David Bird brings us a list of the tools he likes to use and are FREE.   Read more...
By David Bird 2007/05/24 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 39,018 reads

Ten Ways To Lose Your DBA Job

We often see ways to improve your career, but there's a flip side as well. In the spirit of our "worst practices" series, Steve Jones takes a look at ten skills that could cost you your job if you can't perform them.   Read more...
By Steve Jones 2007/04/13 (first posted: 2006/11/30) | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 61,611 reads

XML Workshop II - Reading values from XML variables

Continuing with his series on XML in SQL Server 2005, Jacob Sebastian brings us a number of examples on how to work with XML in different situations with SQL Server 2005.   Read more...
By Jacob Sebastian 2007/06/06 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 9,734 reads