Click here to Skip to main content
15,904,877 members
Home / Discussions / Database
   

Database

 
GeneralRe: how to union some table in a while loop to a table Pin
Eddy Vluggen1-May-13 4:59
professionalEddy Vluggen1-May-13 4:59 
QuestionSSE 2008 R2 Backup Strategy Pin
Richard.Berry10030-Apr-13 19:47
Richard.Berry10030-Apr-13 19:47 
AnswerRe: SSE 2008 R2 Backup Strategy Pin
GuyThiebaut30-Apr-13 21:56
professionalGuyThiebaut30-Apr-13 21:56 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
Richard.Berry10030-Apr-13 22:16
Richard.Berry10030-Apr-13 22:16 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
GuyThiebaut30-Apr-13 22:43
professionalGuyThiebaut30-Apr-13 22:43 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
Richard.Berry10030-Apr-13 23:18
Richard.Berry10030-Apr-13 23:18 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
GuyThiebaut30-Apr-13 23:34
professionalGuyThiebaut30-Apr-13 23:34 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
Richard.Berry1001-May-13 0:10
Richard.Berry1001-May-13 0:10 
GuyThiebaut wrote:
I take it there there is one central instance of an SQL Server rather than an instance on each workstation.

If there is one central instance then try to get it off the OS drive(probably the C: drive) so that disk access is not competing between OS calls and SQL Server calls - does that make sense?

Yes - one server instance on the server. Any yes I see what you mean. It makes sense, and I do remember reading something like that, but when I installed, I seemed to have missed where I could specify a different install location, so it installed on the C: drive (default).. At the moment there are way more serious performance hits in the app itself (populating too many datagrid rows at a time etc) - Only realized this when I got a copy of their data a year after the initial installation... I'd been testing with a bare bones DB on my machine - so yeah what those poor users have been going though - aw shame!
QuestionGeneric column mapping Pin
Ravikiran72p30-Apr-13 1:57
Ravikiran72p30-Apr-13 1:57 
AnswerRe: Generic column mapping Pin
Eddy Vluggen30-Apr-13 9:49
professionalEddy Vluggen30-Apr-13 9:49 
AnswerRe: Generic column mapping Pin
Mycroft Holmes30-Apr-13 13:56
professionalMycroft Holmes30-Apr-13 13:56 
AnswerRe: Generic column mapping Pin
GuyThiebaut30-Apr-13 21:49
professionalGuyThiebaut30-Apr-13 21:49 
AnswerRe: Generic column mapping Pin
jschell1-May-13 8:34
jschell1-May-13 8:34 
QuestionMariaDB on Linux Pin
mbadi27-Apr-13 10:57
mbadi27-Apr-13 10:57 
QuestionError on SQL server join Pin
DeveloperLife201526-Apr-13 13:12
DeveloperLife201526-Apr-13 13:12 
AnswerRe: Error on SQL server join Pin
s_magus26-Apr-13 17:41
s_magus26-Apr-13 17:41 
AnswerRe: Error on SQL server join Pin
AANIL DHAKAD8-May-13 19:17
AANIL DHAKAD8-May-13 19:17 
QuestionSQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
PrissySC26-Apr-13 12:37
PrissySC26-Apr-13 12:37 
AnswerRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
Mycroft Holmes26-Apr-13 13:01
professionalMycroft Holmes26-Apr-13 13:01 
GeneralRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
PrissySC27-Apr-13 1:39
PrissySC27-Apr-13 1:39 
AnswerRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
jschell27-Apr-13 11:32
jschell27-Apr-13 11:32 
GeneralRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
PrissySC28-Apr-13 1:41
PrissySC28-Apr-13 1:41 
GeneralRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
Mycroft Holmes28-Apr-13 12:49
professionalMycroft Holmes28-Apr-13 12:49 
AnswerAttached not seen over network still - will try ID values but .... Pin
PrissySC7-May-13 7:07
PrissySC7-May-13 7:07 
QuestionHow do I get the SSRS Report Mgr to work with a custom security extension? Pin
brandon schave23-Apr-13 6:31
brandon schave23-Apr-13 6:31 

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.