Additional Articles


Technical Article

Bulk Insert proc to try out ur optimization skills

This SP can be used for bulk inserting data from an ascii text file onto a table. You have to change the structure, of the temporary table (ITEM_MASTER_TEMP) and the actual table onto which data is inserted, to suit ur needs . I wish you people workout this SP and try to optimize it as […]

You rated this post out of 5. Change rating

2004-08-26 (first published: )

201 reads

Technical Article

Foreign keys chain in a view. It may be useful.

I made this view because I had to generate a sql server database from  an Oracle database and I had to knew the order in which I import tables.This view, which may be improved, contains the foreign key, the primary and detail table, the column and it's position and may be useful in  many situations

You rated this post out of 5. Change rating

2004-08-25 (first published: )

106 reads

Technical Article

Into Fantasy Football? Join the SQLServerCentral.com League.

If you're into fantasy football, come waste some time with us and join our free league at Yahoo. Read the below instructions on how to join. Space is limitted in the first league to 12 teams so join quickly and the draft starts Tuesday! If it's popular, we'll create other leagues.


In order to join the league, just go to http://football.fantasysports.yahoo.com/f1,
click the "Sign Up Now" or "Get Another Team" button and
follow the links to "Join a Custom League". When prompted,
enter the League ID# and password below.

League ID#: 525071

Password: ssc

You rated this post out of 5. Change rating

2004-08-20

204 reads

Blogs

Stack Overflow & AI

By

I won’t try to pretend otherwise, I’ve had some mixed feelings about Stack Overflow...

Checking Myself with GenAI

By

I had a suggestion from somone on a place where AI helps them and...

Redgate SQL Prompt in SSMS 21

By

Disclaimer: this post is not sponsored by Redgate 🙂 For those who’ve missed it,...

Read the latest Blogs

Forums

Deadlocks and Backups - Need help

By Mike-342950

Hey everyone, please excuse my ignorance, I'm just .NET developer and have used SQL...

Does Version Control Scare You

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Does Version Control Scare You

Unlimited Text

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Unlimited Text

Visit the forum

Question of the Day

Unlimited Text

If I want to get unlimited amounts of data back from a varchar(max)/nvarchar(max) column, what do I run?

See possible answers