Viewing 15 posts - 346 through 360 (of 463 total)
Yeah, OPTION(RECOMPILE) is the one I meant, should have said really!
What is the case where a recompile didn't work? I had a problem recently that a recompile...
February 23, 2008 at 11:04 pm
You keep a single backup job, but run the copy and restore jobs on each standby server.
February 23, 2008 at 9:51 am
colin Leversuch-Roberts (2/22/2008)
February 23, 2008 at 9:29 am
Gail is right on the mark. I wouldn't necessarily recommend "optimize for" though - you can use statement level recompile (new in 2005) to get the optional query plan...
February 23, 2008 at 9:08 am
When I try all the clean pages are removed, the remaining dirty pages all belong to system objects (I'm the only user on the server). If you ever find...
February 21, 2008 at 9:17 am
I installed the buffer space rdl and looked at the query ... it is accurate for the information it is reporting but it doesn't distinguish between clean and dirty pages...
February 21, 2008 at 8:20 am
I'm not sure that I quite understand your question, but ...
the SQL Server service account is the database engine service account. Each distinct SQL service can (but doesn't have...
February 19, 2008 at 3:25 pm
Well the question didn't say always, but OK.
You can still use plan guides, query hints etc to force a plan. Unless the schema has changed to make...
February 19, 2008 at 8:03 am
These are some of the questions I would ask:
What collation should be used?
Any unicode columns?
Anything that will interfere with replication or require a certain setup?
What is required in the way...
February 18, 2008 at 9:50 pm
No, you need to wait for SQL2008 for a query governor.
First you need to determine if the queries need tuning (either by changing the query or adding/modifying indexes)....
February 18, 2008 at 11:19 am
Although I chose no, sometimes the answer is yes; DMVs can give you the cached plan, which will be the actual plan if nothing forces a recompile and the statement...
February 18, 2008 at 8:39 am
It should work as long as the databases have distinct names. Bear in mind that the mirror server is going to do more work now (especially if any databases...
February 16, 2008 at 10:53 pm
General best practice would have the webserver doing just that and no more (ie https/ftp) ... it serves the webpages and talks to other servers through a firewall so that...
February 16, 2008 at 10:34 pm
Also, if you have other indexes on the table then they may benefit from lower fillfactor settings than the clustered index.
February 15, 2008 at 2:32 pm
Viewing 15 posts - 346 through 360 (of 463 total)