Viewing 15 posts - 34,606 through 34,620 (of 49,552 total)
Yes, lots of ways. Start by optimising the queries and tuning indexes.
If you want more detail, you're going to have to give us a lot more to work with. As...
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
January 19, 2010 at 1:59 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic849529-360-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
January 19, 2010 at 1:58 am
It's the biggest problem when moving to 64 bit operating system and SQL. The thing is, there are no work arounds to make it work. 64 bit SQL Server cannot...
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
January 19, 2010 at 1:57 am
If those databases are used frequently then the data pages that are often used will be in cache.
There's no way to prioritise memory usage between databases on the same...
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
January 19, 2010 at 1:55 am
That's something I never do. I prefer to run the queries a couple of times and ignore the first run (which is the one that would be affected by the...
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
January 18, 2010 at 1:30 pm
GOC-481399 (1/18/2010)
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
January 18, 2010 at 1:04 pm
As you have it written there, no. There is no performance difference and it's easy enough to test. SQL's smart enough to see that you've just checking if a row...
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
January 18, 2010 at 1:00 pm
Ninja's_RGR'us (1/18/2010)
Errh, wrong thread Gail :hehe:.
I hate it when SSC does that. Answering 2 threads at the same time stuff often gets posted to wrong thread. Now where did the...
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
January 18, 2010 at 12:45 pm
I have the feeling this is less of a case of it not working on SQL 2008 than it simply isn't supported on SQL 2008. So it might run on...
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
January 18, 2010 at 12:44 pm
yankleber (1/18/2010)
Well, normally I find my SPs by looking at the left column (like in the Windows Explorer).
That's called Object Explorer
Anyway, it isn't showing up in any SP list...
Have you...
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
January 18, 2010 at 12:43 pm
What do you mean by 'where it is'?
Are you looking for it in the Object Explorer of Management studio?
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
January 18, 2010 at 12:29 pm
What do you want to bet that there's still a cursor or two in that.
I had a process a while back that deleted 2 million rows, did aggregations over 150...
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
January 18, 2010 at 12:23 pm
Yup, that's the SQL error log. It indicates exactly what I said earlier, the error was not in theDB integrity step (all the CheckDBs finished successfully), it was in one...
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
January 18, 2010 at 10:05 am
kingscriber (1/18/2010)
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
January 18, 2010 at 9:25 am
Patience, this isn't a chatroom, it's a forum. No need to bump your post after 2 hours. Give it time.
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
January 18, 2010 at 9:18 am
Viewing 15 posts - 34,606 through 34,620 (of 49,552 total)