Viewing 15 posts - 35,086 through 35,100 (of 49,552 total)
Make sure that you've reviewed the 'laundry list' of requirements for Indexed views. There are a lot of requirements for the query used in the view.
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
December 28, 2009 at 10:23 am
river1 (12/28/2009)
I don't need to see if my SQL Server service is down...what i need to know is if the server it self is down
In that case, you don't want...
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
December 28, 2009 at 9:11 am
Bru Medishetty (12/28/2009)
I wonder how you guys get time to play these console games. 😛
What is this 'console' you speak of? Just about all of my games are for PC.
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
December 28, 2009 at 9:07 am
Grant Fritchey (12/28/2009)
I'm not even remotely a Star Wars fanboy
Aaahhh... Heresy!
😀
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
December 28, 2009 at 9:04 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
p.s. I see Nolocks. You sure you know what that means and what it does?
See - http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.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
December 28, 2009 at 8:55 am
Grant Fritchey (12/28/2009)
Fallout 3 has been a major distraction for a long time now. They keep coming out with new modules.
Game of the year edition comes with 5 modules. I...
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
December 28, 2009 at 8:50 am
manub22 (12/28/2009)
Hey!I also use Advantage CRM, which version do you use?
Which company you are in?
You did notice that this thread is 4 and a half years old...
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
December 28, 2009 at 8:36 am
I got Fallout 3 (Game of the Year edition) for birthday and just bought myself Dragon Age. Both going to have to wait though. Computer reinstall scheduled for this week.
Besides,...
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
December 28, 2009 at 8:31 am
Can you get the service packs the same on both servers and then try again. That'll tell us if it is version mismatch or another problem.
Please run this on both...
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
December 28, 2009 at 3:27 am
That almost looks like the error that you get when trying to restore the backup to an earlier version of SQL. Get the service packs and versions to be 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
December 28, 2009 at 2:31 am
MathiPrakash (12/27/2009)
In this case, I'm wondering why the optimizer doesn't do the key lookup, without me enforcing it.
Offhand, not sure, but I did say in the previous post why 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
December 28, 2009 at 2:31 am
MathiPrakash (12/27/2009)
Out of the 5 Million data pages, the optimizer completes the request in just 3000 records...
Not 3000 records. 3000 pages. (unless you have rows > 4000 bytes). Reads...
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
December 27, 2009 at 1:42 pm
Look up the Case Statement in SQL's Books Online (the electronic manual). That should do as you need
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
December 27, 2009 at 7:47 am
Homework? Interview?
Really, this is basic theory. Did you try looking in Books Online, perhaps under 'Function' and 'Stored Procedure'. Or even go and look at computer science theory for 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
December 27, 2009 at 6:25 am
Please read through this - Managing Transaction Logs[/url]
What's the output of this?
DBCC OPENTRAN
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
December 27, 2009 at 6:08 am
Viewing 15 posts - 35,086 through 35,100 (of 49,552 total)