Click here to Skip to main content
15,346,893 members
Home / Discussions / Database
   

Database

 
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 
GeneralRe: Grouping From & To continuous dates in SQL Server Pin
Jörgen Andersson12-Jan-15 21:30
professionalJörgen Andersson12-Jan-15 21:30 
Yes, it should be slow if you read all 50 million records. There are four full table scans for two NOT EXISTS and two sorts.
And on top of that you have two conditions with Functions in them. You could of course use a computed column index to solve that. But that would depend on which version of SQL Server you are using.

So, what version of SQL Server are you using?
Do you need all data in one go or is it enough to filter out one user at a time?
Wrong is evil and must be defeated. - Jeff Ello

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 
GeneralRe: mysql 1 to many ralationship Pin
PIEBALDconsult20-Dec-14 18:17
professionalPIEBALDconsult20-Dec-14 18: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.