|
In a SQL Server Execution plan plans what is the difference between an Index Scan and an Index Seek
I'm on sql server 2005
Started by cindi on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
In this case SQL Server has to scan multiple pages to find a range of rows which satisfy the search predicates....
Regarding the specifics of each of these operators within a SQL Server Execution plan see to satisfy search predicates.
|
|
Can anyone explain how to read a execution plan in SQL Server With Example Please?
Started by Anoop on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
To look for in a graphical execution plan to help you better understand how SQL Server uses indexesSQL Server graphical execution plans in action
In this article, I identify a few basic things query execution plans ....
|
|
I've looked all over for this command....what's the command to reset the SQL Server's execution plan?
Started by Brandon on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
If you want will result in a new execution....
WITH RECOMPILE is going to generate a new plan EVERY time you execute it.
Or you can restart SQL and that will clear the entire execution plan cache.
Query plan and recompile the procedure.
|
Ask your Facebook Friends
|
We're using SQL Server database mirroring and we're trying to create a db maintenance plan to backup the database. The problem is that when the server is not the primary database the plan fails. I was wondering what the best-practice is in this situation...
Started by Darren on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
And dependencies on the mirror server with the jobs disabled
Then use a WMI alert on the DATABASE_MIRRORING, having a T-SQL Statement Task in the Maintenance Plan performing:
declare @primary bit = 0 select.
|
|
We have one particular SQL Server 2008 query (not a stored proc, but the same SQL string -- executes every 5 minutes) that intermittently caches a very bad query plan.
This query normally runs in a few milliseconds, but with this bad query plan, it takes...
Started by Jeff Atwood on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
You cannot remove a specific cache can get the cache name of a bad query plan if you have the plan handle (from sys.dm_exec on cp.memory_object_address = ce.memory....
If you know how the good plan looks like, just use a plan hint .
|
|
Currently, if I want to output a SQL script for a table in my database, in Management Studio, I can right click and output a create script.
Is there an equivalent to output an SQL script for a database's maintenance plan?#
Edit
The company I work for ...
Started by Lord Future on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You can then right click on the plan and select import they are called SSIS (SQL Server....
You can't export them as scripts, but if your intention is to migrate them between server instances Packages>MSDB>Maintenance Plans.
|
|
Hello,
I'm having a problem with a maintenance plan in SQL Server 2005. It's a very basic maintenance plan - it has one 'Execute T-SQL Statement Task' which simply inserts a row into a table.
When I execute the maintenance plan the T-SQL statement is ...
Started by Gavin on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
I don't have a definitive....
When I create the Maintenance Plan on my machine (connected to the server), it fails the results there.
When I create the Maintenance Plan on the server (through Terminal Services), it runs successfully.
|
|
I am trying to create a maintenance plan that will run automatically and back up my SQL Server 2005 databases automatically. I create a new maintenance plan and add a "Back Up Database Task", select all databases, and choose a path to back up to. When...
Started by Stephen Jennings on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
Some builds of SQL 2005 and all of maintenance plans....
The log that a maintenance plan generates defaults to c:\program files\microsoft sql server\mssql and might need SQL Server Integration Services installed on the server.
|
|
Is there any way for a DBA to peek in on the execution plan of a long-running query in SQL Server 2000? I know how to get the SQL being run using fn_get_sql(). And yes, theoretically if open a new connection and set the environment flags the same, it ...
Started by entaroadun on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
The best you can do is run DBCC INPUTBUFFER analyzer and get an execution plan.
No you cannot.
I don't think you can do such a thing, it needs to be submitted to the server with the original and get the estimated execution plan.
|
|
Hi guys. Could you briefly say about recommended backup plans depending on database size and backup/restore time.
Currently I have database that is about 1GB in uncompressed state but I expect it will grow very fast so I think it is important to be prepared...
Started by Jenea on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
Your backups are going to a different drive/array or are getting copied to another off server location.
|
