Viewing 15 posts - 5,881 through 5,895 (of 49,552 total)
Please don't post multiple threads for the same problem.
No replies here please, direct replies to http://www.sqlservercentral.com/Forums/Topic1686770-3412-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2015 at 4:09 am
Please don't post multiple threads for the same problem.
No replies here please, direct replies to http://www.sqlservercentral.com/Forums/Topic1686770-3412-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2015 at 4:09 am
cms9651 (5/19/2015)
GilaMonster (5/19/2015)
Declare @RangeStart varchar(20) = '01/01/2015 00:00:00', @RangeEnd varchar(20) = '01/01/2015 00:00:00' -- these come from the applicationWHERE toDate >= CONVERT (datetime,@RangeStart,103) and toDate < DATEADD(dd,1,CONVERT (datetime,@RangeEnd,103))
Even if...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2015 at 4:02 am
Why? If the patching is going to take the DB down, just fail the AG over to a secondary.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2015 at 3:47 am
Declare @RangeStart varchar(20) = '01/01/2015 00:00:00', @RangeEnd varchar(20) = '01/01/2015 00:00:00' -- these come from the application
WHERE toDate >= CONVERT (datetime,@RangeStart,103) and toDate < DATEADD(dd,1,CONVERT (datetime,@RangeEnd,103))
Even if you don't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2015 at 3:46 am
Ok, let's go back to the problem.
What, exactly, are you trying to do? What data do you have? What should be returned by the query?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2015 at 3:30 am
GilaMonster (5/19/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2015 at 3:28 am
cms9651 (5/19/2015)
AND doTableDate BETWEEN CAST('01/01/2014 00:00:00' AS DATE)
AND CAST('01/01/2014 00:00:00' AS DATE)
....
AND doTableDate >= CAST('01/01/2014 00:00:00'...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2015 at 3:10 am
Well the problem has the same form, same cause and same solution as the one you discussed in there.
Your upper and lower bounds of the between are the same. That...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2015 at 2:49 am
Is this the same problem as you're discussing in the BETWEEN thread? If so, please post there and not in a new thread. Thanks
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2015 at 2:42 am
GilaMonster (5/18/2015)
This is indeed normal behaviour for SQL, it will take all the memory it's allowed to have and not give it back.
30GB in use is not hard, especially...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2015 at 2:26 am
You're not looking for mapped drives, you're looking for local drives, like C:, D:, E:, etc
Maybe give the sysadmin the backup and ask him to restore it?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2015 at 9:52 am
p.a.petrov (5/18/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2015 at 9:07 am
TheSQLGuru (5/18/2015)
And I agree, what about the SORT makes it so bad you want to get rid of it?
Personally I can't even see where a merge join would be coming...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2015 at 9:01 am
Almighty (5/18/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2015 at 8:50 am
Viewing 15 posts - 5,881 through 5,895 (of 49,552 total)