Viewing 15 posts - 27,211 through 27,225 (of 49,552 total)
Take another backup.
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
March 22, 2011 at 4:43 am
I still don't understand what you're looking for.
Write well performing queries and don't interfere with SQL unless you know what you're doing.
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
March 22, 2011 at 4:42 am
Neeta Patil (3/22/2011)
I just tried an example...It refers to the column in the table mentioned in inner query...
Yup. Binding is first to the tables in the inner, then if no...
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
March 22, 2011 at 4:39 am
It's not about internal workings.
You did not qualify the column with the table name. Hence SQL had to look through all the available tables (both in the subquery and in...
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
March 22, 2011 at 2:59 am
Abrar Ahmad_ (3/22/2011)
1. Is there any performance benefit of segregating database files on different logical drives (physically single storage medium)?
In general, no. You need separate spindles to get IO-related...
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
March 22, 2011 at 2:56 am
Marvin Maralit (3/22/2011)
Is there a way to check the accumulative/total CPU & IO usage? instead of checking 1 by 1?
Profiler?
Most of our queries takes too long to finish, is 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
March 22, 2011 at 2:50 am
Costs are estimates, there are any number of things that can make them wrong, inaccurate cardinality estimates being the main one.
Focus your optimisation on duration, CPU and IO, don't focus...
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
March 22, 2011 at 2:11 am
Unfortunately the source of that error (column, variable, etc) is not exposed anywhere.
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
March 21, 2011 at 11:36 pm
What?
If you want answers for those, a quick google search will find many. If you want something else, please explain in detail.
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
March 21, 2011 at 11:35 pm
This article may be worth a read (part 3 of 3)
http://www.sqlservercentral.com/articles/Indexing/68636/
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
March 21, 2011 at 11:28 pm
If you copy the backup locally and then try and restore do you get the same errors?
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
March 21, 2011 at 3:22 pm
SQLkiwi (3/21/2011)
GilaMonster (3/21/2011)
Short trip... 😀 :hehe:Yes, it's not nearly as bad as I was expecting. Just around the corner really 😉
Quickest trip from here to Boston is 24 hours...
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
March 21, 2011 at 3:18 pm
Or a NOT EXISTS
http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/
http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/
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
March 21, 2011 at 2:26 pm
mail.pnreddy (3/21/2011)
You can try out something like this.SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'U'
order by modify_date desc
That will give you the date that the object's definition was changed, not...
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
March 21, 2011 at 2:23 pm
Patricia Johnson (3/21/2011)
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
March 21, 2011 at 1:49 pm
Viewing 15 posts - 27,211 through 27,225 (of 49,552 total)