Click here to Skip to main content
15,168,235 members
Home / Discussions / Database
   

Database

 
GeneralRe: Conditional statements in ON clause of joins Pin
Mycroft Holmes9-Nov-18 18:02
professionalMycroft Holmes9-Nov-18 18:02 
GeneralRe: Conditional statements in ON clause of joins Pin
simpledeveloper11-Nov-18 18:28
Membersimpledeveloper11-Nov-18 18:28 
QuestionLooking for a lightweight database to use for a vb win app Pin
jkirkerx7-Nov-18 13:01
professionaljkirkerx7-Nov-18 13:01 
AnswerRe: Looking for a lightweight database to use for a vb win app Pin
Nathan Minier8-Nov-18 2:08
professionalNathan Minier8-Nov-18 2:08 
GeneralRe: Looking for a lightweight database to use for a vb win app Pin
jkirkerx8-Nov-18 11:25
professionaljkirkerx8-Nov-18 11:25 
AnswerRe: Looking for a lightweight database to use for a vb win app Pin
--ZiM-- .11-Nov-18 9:36
Member--ZiM-- .11-Nov-18 9:36 
QuestionBackup file is not restoring into Database even after giving message as restored successfully Pin
simpledeveloper7-Nov-18 8:40
Membersimpledeveloper7-Nov-18 8:40 
QuestionIndex on nvarchar column doesnot affect performance (sql server) Pin
Heba Kamel23-Oct-18 2:29
MemberHeba Kamel23-Oct-18 2:29 
Hello,

I have a column in table that have nvarchar(200) datatype

and then I add index on another column include my nvarchar(200) column

but the performance is the same when I do a select query with where condition in the nvarchar(200) column

I need to know why the index on nvarchar column doesn't affect the performance?
AnswerRe: Index on nvarchar column doesnot affect performance (sql server) Pin
Richard Deeming23-Oct-18 2:58
mveRichard Deeming23-Oct-18 2:58 
GeneralRe: Index on nvarchar column doesnot affect performance (sql server) Pin
Heba Kamel23-Oct-18 3:03
MemberHeba Kamel23-Oct-18 3:03 
GeneralRe: Index on nvarchar column doesnot affect performance (sql server) Pin
Richard Deeming23-Oct-18 3:04
mveRichard Deeming23-Oct-18 3:04 
Questionhow do i scan a image from a flat bed scanner using python and Microsoft access Pin
Member 1401815918-Oct-18 4:19
MemberMember 1401815918-Oct-18 4:19 
Rant[REPOST] how do i scan a image from a flat bed scanner using python and Microsoft access Pin
Richard Deeming18-Oct-18 4:28
mveRichard Deeming18-Oct-18 4:28 
AnswerRe: how do i scan a image from a flat bed scanner using python and Microsoft access Pin
CHill6018-Oct-18 5:50
mveCHill6018-Oct-18 5:50 
Generalthank you for your reply how you suggest i do it? Pin
Member 1401815918-Oct-18 21:52
MemberMember 1401815918-Oct-18 21:52 
GeneralRe: thank you for your reply how you suggest i do it? Pin
CHill6021-Oct-18 3:20
mveCHill6021-Oct-18 3:20 
QuestionACCESS DATABASE OR PYTHON - SCANNING FROM A FLAT BED SCANNER Pin
Member 1401815918-Oct-18 1:41
MemberMember 1401815918-Oct-18 1:41 
AnswerRe: ACCESS DATABASE OR PYTHON - SCANNING FROM A FLAT BED SCANNER Pin
Richard MacCutchan18-Oct-18 2:22
mveRichard MacCutchan18-Oct-18 2:22 
QuestionSQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Hotaxion8-Oct-18 22:58
MemberHotaxion8-Oct-18 22:58 
AnswerRe: SQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Richard Deeming9-Oct-18 3:15
mveRichard Deeming9-Oct-18 3:15 
GeneralRe: SQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Hotaxion9-Oct-18 16:20
MemberHotaxion9-Oct-18 16:20 
GeneralRe: SQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Victor Nijegorodov9-Oct-18 23:03
MemberVictor Nijegorodov9-Oct-18 23:03 
GeneralRe: SQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Hotaxion14-Oct-18 18:20
MemberHotaxion14-Oct-18 18:20 
GeneralRe: SQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Richard Deeming10-Oct-18 8:57
mveRichard Deeming10-Oct-18 8:57 
GeneralRe: SQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Hotaxion14-Oct-18 18:23
MemberHotaxion14-Oct-18 18:23 

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.