Click here to Skip to main content
15,906,335 members
Home / Discussions / Database
   

Database

 
Questionunable to start the SQL Full Text Search Service from SQL Server Configuration Manager Pin
MahaKh1-Dec-10 20:07
MahaKh1-Dec-10 20:07 
AnswerRe: unable to start the SQL Full Text Search Service from SQL Server Configuration Manager Pin
Pete O'Hanlon1-Dec-10 23:49
mvePete O'Hanlon1-Dec-10 23:49 
QuestionRetrieving the new defalt value of a uniqueidentifier Pin
henry19511-Dec-10 14:41
henry19511-Dec-10 14:41 
AnswerRe: Retrieving the new defalt value of a uniqueidentifier Pin
Mycroft Holmes1-Dec-10 15:44
professionalMycroft Holmes1-Dec-10 15:44 
AnswerRe: Retrieving the new defalt value of a uniqueidentifier Pin
PIEBALDconsult4-Dec-10 4:19
mvePIEBALDconsult4-Dec-10 4:19 
GeneralRe: Retrieving the new defalt value of a uniqueidentifier Pin
henry19514-Dec-10 5:16
henry19514-Dec-10 5:16 
GeneralRe: Retrieving the new defalt value of a uniqueidentifier Pin
PIEBALDconsult4-Dec-10 8:26
mvePIEBALDconsult4-Dec-10 8:26 
GeneralRe: Retrieving the new defalt value of a uniqueidentifier Pin
Joe DiNatale6-Dec-10 11:08
Joe DiNatale6-Dec-10 11:08 
henry1951 wrote:
I chose them for the absolute certainty that there would be no collisions in IDs


Actually it's not an absolute certainty. It's just that the chance of a collision is extremely small.

Be careful using GUIDs as PKs. Significant performance issues can arise (both time and space are wasted) when the clustering index is a GUID and the default in SQLServer is to create a clustering index on the PK. You can get around this by using the newsequentialid()function or by generating your own sequential GUIDs. See this article[^]for a discussion of the issue.
GeneralRe: Retrieving the new defalt value of a uniqueidentifier Pin
Mycroft Holmes4-Dec-10 11:42
professionalMycroft Holmes4-Dec-10 11:42 
GeneralRe: Retrieving the new defalt value of a uniqueidentifier Pin
PIEBALDconsult4-Dec-10 12:53
mvePIEBALDconsult4-Dec-10 12:53 
GeneralRe: Retrieving the new defalt value of a uniqueidentifier Pin
Mycroft Holmes4-Dec-10 14:45
professionalMycroft Holmes4-Dec-10 14:45 
QuestionSQL database works on IIS but not in client machines Pin
saud_a_k30-Nov-10 20:45
saud_a_k30-Nov-10 20:45 
AnswerRe: SQL database works on IIS but not in client machines Pin
Rajesh Anuhya30-Nov-10 22:31
professionalRajesh Anuhya30-Nov-10 22:31 
GeneralRe: SQL database works on IIS but not in client machines Pin
saud_a_k1-Dec-10 0:35
saud_a_k1-Dec-10 0:35 
GeneralRe: SQL database works on IIS but not in client machines Pin
Eddy Vluggen1-Dec-10 7:03
professionalEddy Vluggen1-Dec-10 7:03 
GeneralRe: SQL database works on IIS but not in client machines Pin
saud_a_k3-Dec-10 18:48
saud_a_k3-Dec-10 18:48 
GeneralRe: SQL database works on IIS but not in client machines Pin
Eddy Vluggen4-Dec-10 2:18
professionalEddy Vluggen4-Dec-10 2:18 
AnswerRe: SQL database works on IIS but not in client machines Pin
G-Tek4-Dec-10 5:41
G-Tek4-Dec-10 5:41 
QuestionMaintain max x records Pin
Eduard Keilholz29-Nov-10 22:45
Eduard Keilholz29-Nov-10 22:45 
AnswerRe: Maintain max x records Pin
Mycroft Holmes30-Nov-10 0:05
professionalMycroft Holmes30-Nov-10 0:05 
GeneralRe: Maintain max x records Pin
PIEBALDconsult30-Nov-10 2:18
mvePIEBALDconsult30-Nov-10 2:18 
GeneralRe: Maintain max x records Pin
Eduard Keilholz30-Nov-10 2:45
Eduard Keilholz30-Nov-10 2:45 
GeneralRe: Maintain max x records Pin
David Skelly30-Nov-10 6:14
David Skelly30-Nov-10 6:14 
GeneralRe: Maintain max x records Pin
Chris Meech30-Nov-10 7:19
Chris Meech30-Nov-10 7:19 
GeneralRe: Maintain max x records Pin
Jason Christian1-Dec-10 6:52
Jason Christian1-Dec-10 6:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.