Click here to Skip to main content
15,352,594 members
Home / Discussions / Database
   

Database

 
QuestionGrouping From & To continuous dates in SQL Server Pin
Ashokraja V7-Jan-15 17:34
MemberAshokraja V7-Jan-15 17:34 
AnswerRe: Grouping From & To continuous dates in SQL Server Pin
Mycroft Holmes7-Jan-15 20:58
professionalMycroft Holmes7-Jan-15 20:58 
GeneralRe: Grouping From & To continuous dates in SQL Server Pin
Ashokraja V7-Jan-15 21:13
MemberAshokraja V7-Jan-15 21:13 
GeneralRe: Grouping From & To continuous dates in SQL Server Pin
Mycroft Holmes7-Jan-15 21:20
professionalMycroft Holmes7-Jan-15 21:20 
AnswerRe: Grouping From & To continuous dates in SQL Server Pin
Richard Deeming8-Jan-15 2:55
mveRichard Deeming8-Jan-15 2:55 
GeneralRe: Grouping From & To continuous dates in SQL Server Pin
Mycroft Holmes8-Jan-15 12:02
professionalMycroft Holmes8-Jan-15 12:02 
GeneralRe: Grouping From & To continuous dates in SQL Server Pin
Ashokraja V12-Jan-15 18:24
MemberAshokraja 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 
Run the execution plan and see if it recommends any indexes, look for high cost bottle necks.

You also need to make sure you want to work with all the 50m records, can you filter out some that are not relevant to your query.
Never underestimate the power of human stupidity
RAH

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
MemberAshokraja V19-Jan-15 0:23 
AnswerRe: Grouping From & To continuous dates in SQL Server Pin
Umer Akram11-Jan-15 19:56
MemberUmer Akram11-Jan-15 19:56 
QuestionLong running queries. Pin
sathish487-Jan-15 2:38
Membersathish487-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 
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
MemberUmer 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
MemberUmer 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
MemberRaymart Calinao (AsthreA)20-Dec-14 17:34 

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.