Viewing 9 posts - 16 through 24 (of 24 total)
O! I found Host_process_ID to be my computer name! does it reflect all computer names that run a query from the system?
October 8, 2016 at 12:38 am
So what I did is, save the username in the database through stored procedure. The stored procedure is called in the program prior to update. but sadly, I think I...
October 7, 2016 at 6:11 pm
I do have to sometimes say "NO" to something but I'm normally able to suggest an alternative and the reason why the alternative is better.
This is what a DBA should...
October 6, 2016 at 5:54 pm
Bonus points if they also send links to articles/posts that have nothing to do with the actual problem.
This, THIS! HAHAHA! In my last work place the management sends me "motivational"...
October 5, 2016 at 6:12 pm
From a programmer's perspective, I'd say, anything that you'd want to use to communicate with the database should be "tested". Anything which would be new to the database (e.g. Triggers,...
October 5, 2016 at 1:00 am
Can you tell us a little about your database? Is it something you are in the process of constructing or is it something you have inherited? What is the purpose?...
August 18, 2016 at 8:23 pm
My primary keys are int sirs, But my database columns are all varchar(MAX)
I would like to thank you both for the great answers, i'm thinking, could I mark as solution...
August 17, 2016 at 6:16 pm
Interesting! Thank you for the kind response! I'll use varchar(8000) from now on.
August 17, 2016 at 1:20 am
If i use Primary keys for my query? am i properly indexing my query? sorry for these replies, I really don't know much about data degeneration and such...
August 16, 2016 at 6:52 pm
Viewing 9 posts - 16 through 24 (of 24 total)