Viewing 15 posts - 8,926 through 8,940 (of 22,214 total)
It's possible the query is being run from more than one database.
The real problem is, this is an imprecise mechanism for identifying long running queries. It's completely dependent on the...
February 12, 2014 at 8:44 am
A NULL for the Object name would just imply that you're seeing ad hoc or prepared queries that don't have an object because they're not being called by a stored...
February 12, 2014 at 6:12 am
pmadhavapeddi22 (2/12/2014)
I have re written the query by joining the de norm table in from clause, but the no of
reads and cpu are high with the new query. Old query...
February 12, 2014 at 6:02 am
Another vote for the Enterprise Policy Management Framework. That really made Policy Based Management take off and be useful in our organization.
February 12, 2014 at 3:56 am
I just got in touch with Jorge Segara who wrote the book. He should be by here shortly to get you an answer.
February 11, 2014 at 5:47 pm
I explain how to do the multi-server execution on scripts in this article[/url] (it's focused on backups, but should work for you). Phil Factor talks about some other aspects of...
February 11, 2014 at 5:42 pm
That's not something I've seen before. And that's pretty straight forward code. Any chance the databases are marked as offline or something along those lines? Have they recently failed DBCC...
February 11, 2014 at 5:39 pm
Back when I was doing 2005 upgrades, I ran it against lots of production systems with no issues. Does it add to the load on the server? Absolutely. But it...
February 11, 2014 at 5:36 pm
SQLRNNR (2/11/2014)
Jeff Moden (2/11/2014)
pmadhavapeddi22 (2/11/2014)
Sorry for the late reply,
continuation of the above topic...
As you asked, the below is one of the update statements we are using in stored procedure
Update...
February 11, 2014 at 5:32 pm
Sean Lange (2/11/2014)
jcrawf02 (2/11/2014)
wolfkillj (2/7/2014)
ChrisM@Work (2/7/2014)
Anybody else seeing a kinky image of Koen, Gail and Grant wondering around without their tshirts?
Word is that there are photos of a shirtless Grant...
February 11, 2014 at 9:52 am
jcrawf02 (2/11/2014)
wolfkillj (2/7/2014)
ChrisM@Work (2/7/2014)
Anybody else seeing a kinky image of Koen, Gail and Grant wondering around without their tshirts?
Word is that there are photos of a shirtless Grant from SQL...
February 11, 2014 at 9:38 am
It's extremely unlikely that the second index will get used. It's possible it will get used if the optimizer determines that it needs to do a scan of the entire...
February 11, 2014 at 9:04 am
chetan.deshpande001 (2/11/2014)
It can be addressed using repair_allow_data_loss.. but you might loose some data ... Please read more on repair_allow_data_loss option that CHECKDB provides here http://technet.microsoft.com/en-us/library/ms176064.aspx
You do know that "some" in...
February 11, 2014 at 9:01 am
A dedicated account is a good idea. A SQL login is a little weak for it though. You can just so easily use secondary logins by right-clicking on the SSMS...
February 11, 2014 at 8:59 am
Sounds like your code is opening connections and then not closing them. I would focus there.
February 11, 2014 at 5:53 am
Viewing 15 posts - 8,926 through 8,940 (of 22,214 total)