Click here to Skip to main content
13,708,247 members
   

Database

 
GeneralRe: Equivalent of the following query without FOR XML PATH Pin
indian14317-May-18 14:56
memberindian14317-May-18 14:56 
RantLatest Oracle Connection method Pin
Mycroft Holmes6-May-18 14:56
professionalMycroft Holmes6-May-18 14:56 
GeneralRe: Latest Oracle Connection method Pin
Jörgen Andersson16-May-18 0:20
protectorJörgen Andersson16-May-18 0:20 
GeneralRe: Latest Oracle Connection method Pin
Mycroft Holmes16-May-18 0:27
professionalMycroft Holmes16-May-18 0:27 
GeneralRe: Latest Oracle Connection method Pin
Jörgen Andersson16-May-18 0:37
protectorJörgen Andersson16-May-18 0:37 
QuestionSQL 2016 Optimization ... Pin
4-May-18 1:10
member4-May-18 1:10 
RantRe: SQL 2016 Optimization ... Pin
CHill604-May-18 1:13
protectorCHill604-May-18 1:13 
AnswerRe: SQL 2016 Optimization ... Pin
Eddy Vluggen5-May-18 1:14
professionalEddy Vluggen5-May-18 1:14 
Member 13806085 wrote:
Perform Write and Read as fast as possible using all the hardware resources.
"As fast as possible" will take some experimenting and reading, will depend on your data-structure, indexes, triggers, and a bunch more - a bit much for a single forum-post.

Member 13806085 wrote:
I have configured Always On Read Routing, how can I test it?
Check if the routing-URL is invoked and run a SQL-trace.

Configure Read-Only Routing for an Availability Group (SQL Server) | Microsoft Docs[^]
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

QuestionSQL 2016 Optimization ... Pin
4-May-18 1:10
member4-May-18 1:10 
QuestionHow to stop execution of other tasks in SSIS if a script task gets Dts.TaskResult = (int)ScriptResults.Failure; Pin
indian1432-May-18 14:12
memberindian1432-May-18 14:12 
AnswerSelf answered just if somebody has similar problem it would be helpful. How to stop execution of other tasks in SSIS if a script task gets Dts.TaskResult = (int)ScriptResults.Failure; Pin
indian1433-May-18 8:41
memberindian1433-May-18 8:41 
QuestionInsert dynamic SQL Values into Temp Table Pin
indian14326-Apr-18 7:03
memberindian14326-Apr-18 7:03 
AnswerRe: Insert dynamic SQL Values into Temp Table Pin
Richard Deeming26-Apr-18 8:00
mvpRichard Deeming26-Apr-18 8:00 
GeneralRe: Insert dynamic SQL Values into Temp Table Pin
indian14326-Apr-18 10:09
memberindian14326-Apr-18 10:09 
Questionmysql query Pin
25-Apr-18 16:47
member25-Apr-18 16:47 
AnswerRe: mysql query Pin
Jörgen Andersson25-Apr-18 21:48
protectorJörgen Andersson25-Apr-18 21:48 
GeneralRe: mysql query Pin
26-Apr-18 10:56
member26-Apr-18 10:56 
GeneralRe: mysql query Pin
Jörgen Andersson26-Apr-18 21:22
protectorJörgen Andersson26-Apr-18 21:22 
QuestionShipping tracking Link output to google search from MYSQL Database Pin
25-Apr-18 4:51
member25-Apr-18 4:51 
AnswerRe: Shipping tracking Link output to google search from MYSQL Database Pin
Eddy Vluggen25-Apr-18 5:37
professionalEddy Vluggen25-Apr-18 5:37 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
25-Apr-18 7:19
member25-Apr-18 7:19 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
Eddy Vluggen25-Apr-18 8:19
professionalEddy Vluggen25-Apr-18 8:19 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
25-Apr-18 8:31
member25-Apr-18 8:31 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
Eddy Vluggen25-Apr-18 8:38
professionalEddy Vluggen25-Apr-18 8:38 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
Richard Deeming25-Apr-18 9:46
mvpRichard Deeming25-Apr-18 9:46 

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.


Advertise | Privacy | Cookies | Terms of Service
Web04-2016 | 2.8.180920.1 | Last Updated 24 Sep 2018
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid