Smart questions
Smart answers
Smart people
Join Tek-Tips Forums
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Microsoft SQL Server: Programming FAQ Index

FAQ Index

3rd Party Applications

FAQ Title Author Date Rating/#
Using WinZip in SQL Server   faq183-5065 JayKusch 21 Apr 04 7.3 / 4
 

Convert Access to SQL Server

FAQ Title Author Date Rating/#
How do I convert from Access to SQL Server?   faq183-2935 ANovick 26 Dec 02 5.0 / 17
MS SSMA Tools to Convert MS Access/Oracle/Sybase DBs to SQL Server  faq183-7072 SBerthold 26 Sep 08 --
 

Data Transformation Services

FAQ Title Author Date Rating/#
Where can I find more DTS information and samples?   faq183-962 tlbroadbent 8 Feb 03 6.5 / 22
 

Database and Log Files

FAQ Title Author Date Rating/#
How to attach MDF data files  faq183-363 foxdev 26 Dec 00 6.3 / 9
Shrinking Databases and Logs - SQL 7 and Higher   faq183-1534 tlbroadbent 28 Mar 02 7.9 / 11
Why won't my transaction log shrink?  faq183-345 foxdev 15 Aug 05 8.0 / 28
 

Date and time Tips and tricks

FAQ Title Author Date Rating/#
A Complete Guide to Dates!  faq183-6628 ptheriault 23 Apr 07 7.1 / 15
Converting Seconds to HH:MM:SS  faq183-6155 SQLBill 4 Jan 06 9.0 / 1
Converting Seconds to HH:MM:SS Revisited  faq183-6519 AlexCuse 6 Aug 07 9.0 / 1
Holiday Calendar Calculator  faq183-5075 donutman 1 Jul 04 8.5 / 8
How many days from a given date to the first given day of week  faq183-5074 tektipdjango 25 Apr 04 --
Last week day of month   faq183-7304 djj55 29 Jan 10 --
Time data type and convertion to  faq183-7349 djj55 7 May 10 --
Trouble With ISDATE And Converting To SMALLDATETIME  faq183-6419 SQLDenis 29 Sep 06 10.0 / 1
What is DATETIME and how do I work with it?  faq183-5834 SQLBill 26 Apr 05 9.0 / 6
Which date conversion method do I use?   faq183-6252 LNBruno 16 Mar 06 7.2 / 11
Yet another date FAQ, part I: simple tips & tricks  faq183-5842 vongrunt 14 Jul 05 7.9 / 27
 

Effective Forum Participation

FAQ Title Author Date Rating/#
An example to ask questions   faq183-5565 9295 7 Dec 04 10.0 / 1
Learn to Use Tek-Tips Features   faq183-3179 tlbroadbent 18 Feb 03 8.4 / 11
Suggestions for Getting Quick and Appropriate Answers  faq183-874 tlbroadbent 2 Apr 03 7.6 / 188
 

Enterprise Manager

FAQ Title Author Date Rating/#
Can anyone tell me how to enable¬™disable the display of the Master, Model, and Tempdb databases in Enterprise Manager?   faq183-3092 ECAR 28 Jan 03 9.4 / 11
Enterprise Manager has Application Error on Startup   faq183-5911 Catadmin 10 Jun 05 --
Why can't I open a table in Enterprise Manager or Query Analyzer?   faq183-3430 leveyp 10 Apr 03 3.0 / 2
 

Index Choices

FAQ Title Author Date Rating/#
How do I know what type of index to create?  faq183-398 TomSark 8 Jan 01 8.0 / 17
 

MTS -> DTC -> SQL Server

FAQ Title Author Date Rating/#
How MTS Transactions Affect SQL Server  faq183-282 TomSark 15 Nov 00 7.0 / 4
 

Random Numbers

FAQ Title Author Date Rating/#
How Can I Generate a Series of Random Integers With T-SQL?   faq183-1142 tlbroadbent 3 Oct 01 6.3 / 3
How Can I Select Random Records From a Table with T-SQL?   faq183-1143 tlbroadbent 6 Jun 03 7.4 / 13
How to Generate Random Integer?   faq183-593 Andel 26 Mar 01 7.8 / 5
How to SELECT *, RandomNumber AS Rnd   faq183-7147 fhlee 9 Mar 09 --
Random numbers: reloaded  faq183-6047 vongrunt 12 Feb 06 10.0 / 5
 

Restoring SQL Database

FAQ Title Author Date Rating/#
How Do I Develop a Backup and Restore Strategy?   faq183-1784 tlbroadbent 26 Jun 02 6.3 / 7
Restoring Database in MSSQL 7  faq183-151 phoward 21 Jul 00 4.3 / 16
 

Scheduling DTS Packages

FAQ Title Author Date Rating/#
How can I ensure that my scheduled DTS Packages will execute correctly?  faq183-280 TomSark 14 Nov 00 8.3 / 9
How to Schedule a Job Programatically with VB   faq183-1494 Craftor 25 Jan 02 --
 

SoundEx function

FAQ Title Author Date Rating/#
A better Soundex code   faq183-4110 zhavic 3 Sep 03 9.3 / 9
 

SQL 2000 Table Variables

FAQ Title Author Date Rating/#
How do I use the new table variables in SQL Server 2000?   faq183-1100 jacktek 14 Sep 01 5.0 / 5
 

SQL 2005 DDL Triggers

FAQ Title Author Date Rating/#
How to monitor DDL events in your DB  faq183-6696 ptheriault 31 Jul 07 10.0 / 2
 

SQL Mail

FAQ Title Author Date Rating/#
How do I set up and configure SQL Mail?   faq183-3146 tlbroadbent 8 Feb 03 8.4 / 5
 

SQL Server Administration

FAQ Title Author Date Rating/#
Determining Table sizes (in KB)  faq183-2519 BigTeeJay 7 Dec 04 6.1 / 14
SQL Server TEMPDB WARNING   faq183-1695 CasperTFG 26 Mar 02 2.6 / 5
 

SQL Server Performance Issues

FAQ Title Author Date Rating/#
How can I eliminate or reduce locking?   faq183-714 tlbroadbent 9 May 01 7.0 / 5
How Can I Improve Performance of Range Search Queries?   faq183-768 tlbroadbent 28 May 01 7.6 / 10
How to Use Batch Size to Speed Mass Updates, Inserts and Deletes   faq183-3141 tlbroadbent 7 Feb 03 8.6 / 18
Using Lock Escalation to Improve Update Query Performance   faq183-767 tlbroadbent 28 May 01 7.3 / 4
 

SQL Server Reference Material

FAQ Title Author Date Rating/#
Useful Reference Books for SQL Server Professionals  faq183-3324 SQLSister 17 Feb 05 7.4 / 18
 

SQL Server Resources

FAQ Title Author Date Rating/#
SQL Server 2000 Operations Guide  faq183-1062 tlbroadbent 19 Jun 06 7.0 / 13
SQL Websites   faq183-513 ColinM 28 Feb 01 5.4 / 29
What are SQL Books Online & Where Can I Find Them?   faq183-689 tlbroadbent 26 Apr 01 8.7 / 15
What Help is Available on the Microsoft Technet Website?   faq183-718 tlbroadbent 9 May 03 5.3 / 7
Where can I find training/tutorials for SQL and T-SQL?  faq183-694 tlbroadbent 19 Nov 02 6.2 / 21
 

SQL Server Security

FAQ Title Author Date Rating/#
SQL Server Security Resources for DBAs and System Admins   faq183-3131 tlbroadbent 5 Mar 03 6.0 / 2
using NT Authentication to login into SQL   faq183-779 DougP 2 Dec 02 7.0 / 9
Which SQL Server Service Pack am I running?   faq183-3159 osjohnm 12 Feb 03 10.0 / 3
Why can't I CREATE or DROP a USER in a database restored from another server?   faq183-2153 tlbroadbent 30 Apr 03 7.8 / 4
 

SQL SMO Programming

FAQ Title Author Date Rating/#
Using the SMO to create Database Snapshots in SQL 2005   faq183-6425 Catadmin 4 Oct 06 --
 

SQLDMO

FAQ Title Author Date Rating/#
How can I script my SQL Server databases from Visual Basic?   faq183-1637 tlbroadbent 8 May 03 7.9 / 7
How do I script all the objects from all databases on a server and record changes   faq183-4379 nigelrivett 1 Nov 03 --
 

Stored Procedures

FAQ Title Author Date Rating/#
Can you use stored procedures in select queries?   faq183-695 Cagliostro 30 Apr 01 4.3 / 23
Debugging Complex Stored Procedures.  faq183-4314 SQLSister 16 Mar 04 7.9 / 10
How Can I Obtain "Rows Affected" by Execution of a Dynamic SQL Statement?   faq183-761 tlbroadbent 26 May 01 8.4 / 5
How to generate a random password   faq183-7235 Malchik 26 Aug 09 --
Return value of a Stored Procedure   faq183-891 dbtech 7 Jul 01 5.2 / 5
 

Sysprocesses

FAQ Title Author Date Rating/#
Sysprocesses table definition   faq183-4179 TomKane 16 Sep 03 --
 

T-SQL Hints and Tips

FAQ Title Author Date Rating/#
ADD RowGUID column to all Tables in a DB even with multiple schemas  faq183-7686 sparkbyte 17 Oct 13 --
Calculating a median   faq183-4751 JohnDTampaBay 23 Jan 04 10.0 / 1
Calculating a Median without use of Cursors   faq183-4760 hmckillop 5 Feb 04 5.5 / 2
Calculating a Median without use of cursors and dynamic SQL   faq183-6220 vongrunt 21 Feb 06 10.0 / 1
Checking for SQL injection attacks in parameters.  faq183-5267 donutman 18 Jul 04 --
Concatenating a one-to-many relationship into a single column   faq183-2146 AWithers 9 Jul 02 9.0 / 11
Concatenating Row Values into 1 Record/String   faq183-6466 Catadmin 16 Nov 06 6.5 / 2
Concatenating Row Values into 1 Record/String (revisited)   faq183-6485 NoCoolHandle 12 Dec 06 6.0 / 2
Converting UNC/Unix/Oracle Time to readable date field.  faq183-5563 mrdenny 20 Aug 05 10.0 / 1
Crosstab Query - PART I (Code Generator)  faq183-5269 donutman 12 Mar 05 7.5 / 6
Crosstab Query - PART II (Dynamic Execution)  faq183-5278 donutman 12 Mar 05 10.0 / 2
Executing Dynamically Created T-SQL Strings   faq183-3132 sunila7 6 Feb 03 7.8 / 13
Explore Database   faq183-6649 LNBruno 15 May 07 10.0 / 1
Handle duplicate records   faq183-2682 paron 19 Nov 02 6.7 / 6
Handling delimited strings in T-SQL   faq183-1151 ghreddy 10 Oct 01 5.7 / 3
How Can I Find Gaps in Date and Number Sequences?   faq183-840 tlbroadbent 6 Nov 02 6.1 / 8
How can I send a message to an NT user's machine   faq183-2023 gcole 11 Jun 02 7.0 / 1
How Do I Count Business or Work Days Between Two Dates?  faq183-2968 tlbroadbent 29 Jul 09 7.5 / 8
How do I do ___________ with a Hierarchical structure?  faq183-5322 ESquared 19 Nov 04 5.0 / 2
How do I format money/decimal with commas?   faq183-6157 SQLDenis 29 Dec 05 9.7 / 3
How Do I Get a Row Number On Each Row of a Query Result Set?   faq183-3021 tlbroadbent 12 Jan 03 7.8 / 8
How to add sequence number within groups of repeating values  faq183-5021 NathanGriffiths 11 Jul 04 3.0 / 1
How to add yourself to the Administrator Group on a SQL Server  faq183-5723 DBAWinnipeg 4 Mar 05 --
How to find a text inside SQL Server code  faq183-7696 arturm 30 Dec 13 --
How to organize SUM() for character field in SQL Server SELECT query   faq183-1067 TomasDill 4 Sep 01 2.0 / 3
How to renumber records, do running totals without a cursor  faq183-207 MalcolmW 28 Aug 00 7.5 / 13
How to sort or compare multi-segment character information?   faq183-6095 Walid 7 Nov 05 10.0 / 1
How to use the BULK INSERT with a file that has double quotes   faq183-1602 landShark 7 Mar 02 6.3 / 6
How-To Update Tables Using Inner Joins   faq183-1958 MapMan 23 May 02 6.0 / 4
IsNumeric, IsInt, IsNumber  faq183-6423 gmmastros 3 Oct 06 10.0 / 3
JOIN Fundamentals   faq183-4785 SemperFiDownUnda 29 Jan 04 9.3 / 21
Multi Step Update with full rollback if any fail (SQL2005 up)   faq183-6956 Qik3Coder 27 Jun 08 --
Passing a list of values to a Stored Procedure   faq183-3979 JamesLean 5 Aug 03 7.3 / 9
Passing a list of values to a Stored Procedure (Part II)  faq183-5207 ESquared 30 Apr 09 9.0 / 17
Passing a list of values to a Stored Procedure (Part III)   faq183-6684 ESquared 19 Jul 07 8.0 / 2
Retrieving latest entry for each set of two or more repeating keys   faq183-1342 shnaeem 13 Dec 01 7.0 / 1
Should I use JOIN or WHERE to join tables?  faq183-5168 ESquared 25 Jun 04 2.0 / 2
T-SQL Best Practices - PART I - Coding Style  faq183-5275 donutman 6 Jul 04 9.3 / 7
T-SQL Best Practices - PART II - Naming Conventions  faq183-5276 donutman 11 Feb 05 9.8 / 4
T-SQL Best Practices - PART III - Do's and Don'ts  faq183-5277 donutman 19 Aug 04 9.0 / 6
Using Access as front-end to SQL Server   faq183-2320 AWithers 14 Aug 02 8.0 / 9
Why Does SQL Server Display My Data Like That?   faq183-3007 tlbroadbent 9 Jan 03 6.4 / 19
 

Undocumented Procedures

FAQ Title Author Date Rating/#
How do I run a query against all my databases or all my tables?   faq183-4107 SQLBill 3 Sep 03 7.5 / 8
 

Upgrade to SQL Server 2000

FAQ Title Author Date Rating/#
What Should I Expect When Upgrading to SQL 2000?   faq183-1781 tlbroadbent 13 Dec 02 8.1 / 9
 

Useful Stored Procedures

FAQ Title Author Date Rating/#
How to search all your objects for specific phrase/word   faq183-5175 hmckillop 3 Jun 04 10.0 / 3
 

User-Defined Functions

FAQ Title Author Date Rating/#
fn_formatdatetime (Format a datetime variable with a user-defined string)  faq183-4191 SlashZero 11 Apr 04 6.0 / 4
Formating Numbers via T/SQL   faq183-4418 mrdenny 10 Nov 03 4.0 / 1
How to find missing identity values   faq183-6586 SQLWilts 28 Feb 07 --
How to get Time Zone of the SQL Server   faq183-7145 fhlee 5 Mar 09 --
How to use GetDate() or GetUTCDate() from a User Defined Function?   faq183-7146 fhlee 5 Mar 09 --
 

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close