Click here to Skip to main content
15,668,082 members
Home / Discussions / Database
   

Database

 
GeneralRe: Grouping From & To continuous dates in SQL Server Pin
Ashokraja V12-Jan-15 18:24
Ashokraja V12-Jan-15 18:24 
GeneralRe: Grouping From & To continuous dates in SQL Server Pin
Mycroft Holmes12-Jan-15 19:00
professionalMycroft Holmes12-Jan-15 19:00 
GeneralRe: Grouping From & To continuous dates in SQL Server Pin
Jörgen Andersson12-Jan-15 21:30
professionalJörgen Andersson12-Jan-15 21:30 
GeneralRe: Grouping From & To continuous dates in SQL Server Pin
Ashokraja V19-Jan-15 0:23
Ashokraja V19-Jan-15 0:23 
AnswerRe: Grouping From & To continuous dates in SQL Server Pin
Umer Akram11-Jan-15 19:56
Umer Akram11-Jan-15 19:56 
QuestionLong running queries. Pin
sathish487-Jan-15 2:38
sathish487-Jan-15 2:38 
AnswerRe: Long running queries. Pin
ZurdoDev7-Jan-15 3:33
professionalZurdoDev7-Jan-15 3:33 
AnswerRe: Long running queries. Pin
Mycroft Holmes7-Jan-15 13:34
professionalMycroft Holmes7-Jan-15 13:34 
Assuming it is SQL server AND you are using a stored procedure!
Use the execution plan to identify indexes that may be required and identify the high cost parts of the query.

You then need to look into the structure of your query.
Never underestimate the power of human stupidity
RAH

AnswerRe: Long running queries. Pin
Swinkaran7-Jan-15 16:26
professionalSwinkaran7-Jan-15 16:26 
QuestionYearly sales report Pin
pkfox5-Jan-15 20:26
professionalpkfox5-Jan-15 20:26 
AnswerRe: Yearly sales report Pin
Mycroft Holmes5-Jan-15 20:58
professionalMycroft Holmes5-Jan-15 20:58 
GeneralRe: Yearly sales report Pin
pkfox5-Jan-15 22:11
professionalpkfox5-Jan-15 22:11 
GeneralRe: Yearly sales report Pin
Umer Akram6-Jan-15 0:13
Umer Akram6-Jan-15 0:13 
GeneralRe: Yearly sales report Pin
pkfox6-Jan-15 6:39
professionalpkfox6-Jan-15 6:39 
GeneralRe: Yearly sales report Pin
pkfox10-Jan-15 22:20
professionalpkfox10-Jan-15 22:20 
GeneralRe: Yearly sales report Pin
Umer Akram11-Jan-15 19:18
Umer Akram11-Jan-15 19:18 
QuestionWhat is Schema of a Database Pin
King Fisher25-Dec-14 20:27
professionalKing Fisher25-Dec-14 20:27 
AnswerRe: What is Schema of a Database Pin
Kornfeld Eliyahu Peter25-Dec-14 21:10
professionalKornfeld Eliyahu Peter25-Dec-14 21:10 
Questionmysql 1 to many ralationship Pin
Raymart Calinao (AsthreA)20-Dec-14 17:34
Raymart Calinao (AsthreA)20-Dec-14 17:34 
GeneralRe: mysql 1 to many ralationship Pin
PIEBALDconsult20-Dec-14 18:17
professionalPIEBALDconsult20-Dec-14 18:17 
GeneralRe: mysql 1 to many ralationship Pin
Raymart Calinao (AsthreA)20-Dec-14 18:23
Raymart Calinao (AsthreA)20-Dec-14 18:23 
GeneralRe: mysql 1 to many ralationship Pin
PIEBALDconsult20-Dec-14 18:26
professionalPIEBALDconsult20-Dec-14 18:26 
QuestionMySQL Query Example/Solution of Oracle Query Pin
M Riaz Bashir19-Dec-14 5:08
M Riaz Bashir19-Dec-14 5:08 
QuestionRe: MySQL Query Example/Solution of Oracle Query Pin
Eddy Vluggen19-Dec-14 5:20
professionalEddy Vluggen19-Dec-14 5:20 
AnswerRe: MySQL Query Example/Solution of Oracle Query Pin
Jörgen Andersson19-Dec-14 7:17
professionalJörgen Andersson19-Dec-14 7:17 

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.