Click here to Skip to main content
15,908,776 members
Home / Discussions / Database
   

Database

 
AnswerRe: How to add primary key in existing table? Pin
Dhamodharan A18-Jun-15 21:33
Dhamodharan A18-Jun-15 21:33 
GeneralRe: How to add primary key in existing table? Pin
apple blue29-Jun-15 14:48
apple blue29-Jun-15 14:48 
AnswerRe: How to add primary key in existing table? Pin
Daniel Miller23-Oct-15 15:32
professionalDaniel Miller23-Oct-15 15:32 
Questioninterface a c# application and SCADA system using SQL server Pin
zineb errih16-Jun-15 7:36
zineb errih16-Jun-15 7:36 
AnswerRe: interface a c# application and SCADA system using SQL server Pin
Hernan Osorio6-Oct-17 6:30
Hernan Osorio6-Oct-17 6:30 
QuestionQuery Response Time - SQL Server Replication Pin
JammoD8714-Jun-15 1:48
JammoD8714-Jun-15 1:48 
AnswerRe: Query Response Time - SQL Server Replication Pin
Mycroft Holmes14-Jun-15 13:03
professionalMycroft Holmes14-Jun-15 13:03 
AnswerRe: Query Response Time - SQL Server Replication Pin
GuyThiebaut14-Jun-15 21:25
professionalGuyThiebaut14-Jun-15 21:25 
The question is not a valid question, it is not possible to answer, 'question does not compute'... - it is the equivalent of asking which is colder a banana or a strawberry.

In essence there is not enough information being provided within the question in order to answer it.
In the circumstances I would have asked for two examples database installations with details, one that is replicated and one that is not, I would then have more of an idea regarding which had an improved response time.

To give you some idea I use replication for a reporting server - I replicate the tables and stored procedures from the production server onto the replicated server so that when running reports the production server does not get a performance hit.
So in the setup I use replication does improve performance on the production server.
However in and of itself replication is nothing but a tool - used well it will help, used poorly it will hinder.
“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens


modified 15-Jun-15 3:37am.

AnswerRe: Query Response Time - SQL Server Replication Pin
Tim Carmichael15-Jun-15 9:06
Tim Carmichael15-Jun-15 9:06 
AnswerRe: Query Response Time - SQL Server Replication Pin
JammoD8716-Jun-15 1:16
JammoD8716-Jun-15 1:16 
QuestionDatabase grouping of rows using values into columns Pin
indian14310-Jun-15 8:48
indian14310-Jun-15 8:48 
AnswerRe: Database grouping of rows using values into columns Pin
Richard Deeming10-Jun-15 9:05
mveRichard Deeming10-Jun-15 9:05 
AnswerRe: Database grouping of rows using values into columns Pin
Eddy Vluggen10-Jun-15 9:29
professionalEddy Vluggen10-Jun-15 9:29 
QuestionCompare Database Projects Pin
Ashfaque Hussain7-Jun-15 19:47
Ashfaque Hussain7-Jun-15 19:47 
AnswerRe: Compare Database Projects Pin
Mycroft Holmes7-Jun-15 19:54
professionalMycroft Holmes7-Jun-15 19:54 
GeneralRe: Compare Database Projects Pin
Ashfaque Hussain7-Jun-15 20:06
Ashfaque Hussain7-Jun-15 20:06 
QuestionDB2 Please Help Here Pin
ganeshbdas7-Jun-15 2:23
ganeshbdas7-Jun-15 2:23 
AnswerRe: DB2 Please Help Here Pin
CHill608-Jun-15 22:25
mveCHill608-Jun-15 22:25 
AnswerRe: DB2 Please Help Here Pin
CHill6017-Jun-15 1:50
mveCHill6017-Jun-15 1:50 
QuestionSeparating names from a single column to 2 columns Pin
jkirkerx6-Jun-15 7:59
professionaljkirkerx6-Jun-15 7:59 
AnswerRe: Separating names from a single column to 2 columns Pin
Kornfeld Eliyahu Peter6-Jun-15 22:16
professionalKornfeld Eliyahu Peter6-Jun-15 22:16 
GeneralRe: Separating names from a single column to 2 columns Pin
jkirkerx7-Jun-15 7:11
professionaljkirkerx7-Jun-15 7:11 
GeneralRe: Separating names from a single column to 2 columns Pin
Kornfeld Eliyahu Peter7-Jun-15 9:56
professionalKornfeld Eliyahu Peter7-Jun-15 9:56 
QuestionHow to restore a DB with DATA and Schema generated through script ? Pin
Azam Niaz Ch.6-Jun-15 2:52
Azam Niaz Ch.6-Jun-15 2:52 
AnswerRe: How to restore a DB with DATA and Schema generated through script ? Pin
Eddy Vluggen6-Jun-15 5:13
professionalEddy Vluggen6-Jun-15 5:13 

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.