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.
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...
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.
December 28, 2009 at 9:07 am
Grant Fritchey (12/28/2009)
I'm not even remotely a Star Wars fanboy
Aaahhh... Heresy!
😀
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
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...
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...
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,...
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...
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...
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...
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...
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
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...
December 27, 2009 at 6:25 am
December 27, 2009 at 6:08 am
Viewing 15 posts - 35,086 through 35,100 (of 49,552 total)