Indexing

Topic

Comments posted to this topic are about the Question of the Day for 05 Mar 2004 posted at http://qa.sqlservercentral.com/testcenter/qod.asp?QuestionID=197.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-03-04

RE: Deadlock Problem Analysis

by blueagle

MSSQLTips.com

Disable the page lock through sp_indexoption.

2004-03-04

One-Many Relationship Help

by Daniel-Matthews

SQLServerCentral.com

Topic

HiFor my project i am trying to create an online registering system. The users enter all of the required info through the form it is then handled on the server by asp scripts.I have to tables resident and householdresident table:----------------------------------------Personal_ID (PK) | Name | DOB | Household_ID Household table:----------------------------------------Household_ID (PK) | Address | Post Code The problem i […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-03-04

2 reads

Retrieve Index Information For All Tables - V2

by Nicholas Cain

SQLServerCentral

Miscellaneous

Script

This is an update to sp_helpindex, it allows you to pass the table name and whether you want to retrieve clustered, nonclustered or primary key indexes for a table. Using the sp_msforeach table will allow you to do this for all tables in a database. Inserting the data into a table will allow you to […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-03-04

930 reads

Discuss

RE: Files as records

by Frank Kalis

Database Journal

Okay Create a new exe-project in VB with a DriveListBox, DirListBox,FileListBox and an Image control Add the following code Private Sub Dir1_Change() File1.Path = Dir1.Path End Sub --- Private Sub Drive1_Change() Dir1.Path = Drive1.Drive End Sub --- Private Sub File1_Click() On Error Resume Next Image1.Picture = LoadPicture(File1.Path & "\" & File1.FileName) End Sub Unless I […]

2004-03-04