INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

HANDLE


PASSWORD
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!
E-mail*
Handle

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

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Member Feedback

"...At last there is indeed a website/forum that deals with professional and serious matters. Keep up with the good work!!"
More...

Geography

Where in the world do Tek-Tips members come from?
Click Here To Find Out!
Home > Forums > Programmers > DBMS Packages > Microsoft SQL Server: Programming

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.5 / 12
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.0 / 7
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 --
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 6.9 / 10
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.2 / 17
 

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.5 / 20
 

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/#
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 10.0 / 1
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.5 / 2
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 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 8.7 / 3
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 / 2
JOIN Fundamentals   faq183-4785 SemperFiDownUnda 29 Jan 04 9.3 / 20
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.4 / 15
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 / 8
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 --