Viewing 15 posts - 17,311 through 17,325 (of 19,560 total)
Jeff Moden (2/15/2010)
Percentages? Even on Tera-byte drives?
Yeah - kind of archaic I know. More of a precaution for me though. I like to be alerted when that drive...
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
February 15, 2010 at 6:52 pm
Within the query as is - I can't either. However, I was thinking something more along the lines of dumping that data into a temp table and then using...
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
February 15, 2010 at 6:08 pm
Being "average" sometimes might just be a matter of circumstance or lack of enjoyment in the job. I venture to say that sometimes time plays an important factor on...
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
February 15, 2010 at 5:14 pm
All i have to say about the SPs is woohoo.
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
February 15, 2010 at 5:04 pm
And I am yet another one of the many in the work queue today.
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
February 15, 2010 at 5:02 pm
I agree with Elliott.
Here is a link on how to do that
http://www.codeproject.com/KB/database/foreachadossis.aspx
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
February 15, 2010 at 4:59 pm
I find it interesting that the question has only been answered correctly 10% of the time. And 70% of the people missing the question all missed it selecting the...
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
February 15, 2010 at 4:58 pm
You may consider using a combination of substring, left and right string functions.
http://msdn.microsoft.com/en-us/library/ms181984.aspx
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
February 15, 2010 at 4:52 pm
This article is more specific to the task at hand.
http://www.codeproject.com/KB/database/foreachadossis.aspx
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
February 15, 2010 at 4:38 pm
timscronin (2/15/2010)
So you are saying if I go across db's in the stored procs then I need to use Execute as to get around this?
That is one option.
I would add...
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
February 15, 2010 at 4:27 pm
Here is an article that performs a similar task
http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64014/
This is to give you an idea of how to create an ssis package that can query each DB server.
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
February 15, 2010 at 4:25 pm
For the record, I get the same sort of results as Gus.
This would be a really nice thing to be able to find - help my automated inventory efforts 😉
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
February 15, 2010 at 3:01 pm
Has it worked in the past?
Has anything changed?
Can you setup logging on the package and show us the error as it shows in the package log? (Not from SQL...
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
February 15, 2010 at 2:57 pm
There a few methods to do that. One of which is to associate that user with the second database.
Another option includes the use of certificates.
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
February 15, 2010 at 2:53 pm
Create a script and run that from an ssis package that loops through all of your servers and executes the script against each one.
options
1) USE [master]
GO
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master],...
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
February 15, 2010 at 2:51 pm
Viewing 15 posts - 17,311 through 17,325 (of 19,560 total)