Viewing 15 posts - 16 through 30 (of 114 total)
Sorry gail, but this are the normal queries that should be executed on my production db pointing to this weird dbid...
...ah maybe this is correlated tp the sp_executesql-usage?
April 23, 2013 at 8:36 am
Because this is the database the statements should refer?
April 23, 2013 at 7:06 am
Fernando Jacinto Alvarez (4/23/2013)
You should use http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html and schedule for run weekly or dayly for keep your used objects updated
Thanks, but you definitely missed the point!
April 23, 2013 at 7:05 am
Could you explain this a bit more in detail, what the system resource db is and why it is used?
But then I ask myself why allmost 99% have not dbid...
April 23, 2013 at 3:04 am
Thanks Gail, I just wanted to post, that I found your articles...to complete it...I found the answers here :
This Why the DMVS are not a replacement for sql trace[/url] led...
April 23, 2013 at 2:26 am
But how do you collect all queries on a table to decide which field is selected the most and interesting for a clustered index? Through long lasting Profiler traces? Or...
April 22, 2013 at 1:59 am
Just remembered the articles (e.g. http://sqlinthewild.co.za/index.php/2011/11/11/sql-university-advanced-indexing-indexing-strategies/) of Gail, because Sean gave me links to other posts on her blog...I gonna recheck them and come back with my questions
April 19, 2013 at 1:58 pm
It's not a stored proc. You could be right concerning parameter sniffing. Do you know any article etc. explaining me why parameter sniffing could be so costly. 300ms to 8000ms,...
April 19, 2013 at 1:16 pm
Yeah you got it! How do I get the balance over a long time? How can I decide in consideration of all queries fired on a table which are the...
April 19, 2013 at 1:10 pm
Oh man...if it wouldn't take me so long to obfuscate it. It's a normal query using cte to gather some values of 3 joined tables and the results get aggregated....
April 19, 2013 at 1:05 pm
Which MaxValue needs to be set, if I got Analysis Services running on the same machine?
April 19, 2013 at 3:53 am
Seems to be gone...weird...I'd come back with all the info, when the problem would emerge again. Thanks!
March 11, 2013 at 10:01 am
With no warranty : AFAIK the LSN is unique for the database, anything else would be horror :P!
March 4, 2013 at 3:12 am
I wrote/modified a check script running every hour which keeps looking after certain keywords in the errorlog I predefined. If it finds something, I send me an email. But email...
March 4, 2013 at 2:53 am
There are severel ways to accomplish this :
- using a database trigger, triggering if any DDL-Statements get fired
- automatic scripting of your database objects to files which you compare
- use...
February 28, 2013 at 1:05 am
Viewing 15 posts - 16 through 30 (of 114 total)