Viewing 15 posts - 10,741 through 10,755 (of 22,213 total)
Just to help you troubleshoot a bit in the future, take a look at the plan. Right click the SELECT operator and choose properties. For the plan run from a...
June 18, 2012 at 9:07 am
Yeah, no way I'm aware of either. The only way to remove the possibility for an index to be used is, drop it, disable it, or put an index hint...
June 18, 2012 at 5:35 am
Have you looked at the execution plan for the query? That will tell you what it's doing and will help you determine if there are further tuning opportunities available for...
June 18, 2012 at 5:33 am
Trying to break down the query from the execution plan, but it's too big. It's not all contained there.
You're getting an optimizer timeout on this query, so you can't trust...
June 15, 2012 at 8:04 am
ChrisM@Work (6/15/2012)
Brandie Tarvin (6/15/2012)
June 15, 2012 at 6:21 am
crazy4sql (6/15/2012)
If the backup file is of third party, you will get error which if you...
June 15, 2012 at 5:37 am
There isn't a mechanism that I'm aware to gather that information from MSDB or the backup headers. I've looked for it before and haven't found it. But I could be...
June 15, 2012 at 5:11 am
Brent's suggestion to use the DMO queries is the closest you can get. Just remember that you're querying against the cache. That means that you can miss information if it...
June 15, 2012 at 4:57 am
Other suggestions are to validate the memory configuration and the disk alignment. I've posted this to #sqlhelp on Twitter.
OK. Stepping back for a minute. What kind of monitoring do you...
June 15, 2012 at 4:30 am
You may want to look up the max value in the Books Online. They're pretty different between 32 & 64 bit OS.
June 14, 2012 at 8:38 pm
Hmmm.... Take a look at this article. It might help. They only use two servers. I'm using five, plus a domain controller.
June 14, 2012 at 11:59 am
Ah well, there you go. Something up with your quorum settings. Makes sense. Change that & you should be good to go.
June 14, 2012 at 11:10 am
In addition to my book (thanks for the reference) I write about execution plans a lot on my blog, scarydba.com. For lots of even more detailed information, low level stuff,...
June 14, 2012 at 10:33 am
Just remember that a CTE is nothing but a derived table, a select statement acting as a table. With that in mind, if you think a select statement will allow...
June 14, 2012 at 10:31 am
GilaMonster (6/14/2012)
A 32 bit OS cannot run a 64-bit SQL Server.
A 64-bit OS can run 32-bit code, but not the other way around.
For memory details, books...
June 14, 2012 at 8:38 am
Viewing 15 posts - 10,741 through 10,755 (of 22,213 total)