Viewing 15 posts - 19,501 through 19,515 (of 19,560 total)
You can create some procs that will take care of your reindexing needs. When creating the procs you can set them up as startup procs so they will run...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 10, 2009 at 10:29 am
Nice article. This could prove very useful.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 10, 2009 at 10:19 am
That should have done it for you. I have seen though that the freeprocindb sometimes doesn't clear it like we would want. Though all plans would be removed...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 9, 2009 at 6:55 pm
Please provide us a sample query that might be using this structure (provide a sample of the schema too please).
Do you have clustered indexes on the underlying tables?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 9, 2009 at 6:03 pm
If you were on sql2k5, I would suggest creating a ddl trigger to help monitor for this.
The DDL trigger in 2k5 can monitor for create, alter and drop events related...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 9, 2009 at 5:48 pm
Select job type as cmdexec from within a new job / job step properties.
Give it a command such as :
DTSRun /S"Servername" /E /N"DTSPackageName"
It should be able to do it without...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 9, 2009 at 5:38 pm
have you looked at the gui options?
tools - options - query execution - SQL Server - Advanced
and
tools - options - query execution - SQL Server - ANSII
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 9, 2009 at 4:31 pm
Good List by Michael. Excellent point by Jeff concerning the code review.
Review, review, and review some more the developer code.
I would like to throw in to the mix a...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 9, 2009 at 1:18 pm
try dbcc freeproccache
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 9, 2009 at 12:50 pm
Maple data is better than honey data 🙂
Of the last two supplied queries, my preference would be for the first. That said, it would be best to do as...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 9, 2009 at 11:15 am
I would definitely use the first two questions for an entry level type position.
Based on recent experience, we have encountered 50+ candidates who could not answer questions such as these....
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 9, 2009 at 11:09 am
http://msdn.microsoft.com/en-us/library/bb677167.aspx
this microsoft provided link states that they were erroneous in which versions support automatic page repair.
both standard and Enterprise editions support it.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 9, 2009 at 10:16 am
http://msdn.microsoft.com/en-us/library/bb677167.aspx
this microsoft provided link states that they were erroneous in which versions support automatic page repair.
both standard and Enterprise editions support it.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 9, 2009 at 10:16 am
http://msdn.microsoft.com/en-us/library/bb677167.aspx
this microsoft provided link states that they were erroneous in which versions support automatic page repair.
both standard and Enterprise editions support it.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2009 at 3:55 pm
http://msdn.microsoft.com/en-us/library/bb677167.aspx
this microsoft provided link states that they were erroneous in which versions support automatic page repair.
both standard and Enterprise editions support it.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2009 at 3:13 pm
Viewing 15 posts - 19,501 through 19,515 (of 19,560 total)