Viewing 15 posts - 19,186 through 19,200 (of 19,560 total)
Those aren't server roles. Those roles are Database roles within the MSDB database. You will need to grant the user access in the msdb database and then 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
November 6, 2009 at 9:54 am
I typically do it from the file system and haven't tried to do that directly from the msdb store.
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
November 6, 2009 at 9:48 am
Jpotucek (11/6/2009)
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
November 6, 2009 at 9:46 am
What are the results of the following queries?
DECLARE @db_id TINYINT
SELECT @db_id = DB_ID('northwind')
SELECT page_latch_wait_count, page_latch_wait_in_ms, page_io_latch_wait_count, page_io_latch_wait_in_ms
5.
FROM sys.dm_db_index_operational_stats (@db_id, null, NULL,...
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
November 6, 2009 at 9:35 am
is there any chance they are running this job even though it is disabled? Maybe some other job calls this job, or some code somewhere calls and executes this...
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
November 6, 2009 at 9:20 am
Luke L (11/6/2009)
jcrawf02 (11/6/2009)
So then we've finally found a definitive benefit of RBAR - environment control
Jeff's gonna be pissed...
Though I suppose if you get it to raise the temps enough...
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
November 6, 2009 at 9:17 am
chill, socialize, and fly home.
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
November 6, 2009 at 9:14 am
If you don't have the sln, create a new project. Once the project is created and open, right click packages from solution explorer, select add existing package. This...
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
November 6, 2009 at 9:07 am
Open the package from within BIDS.
It is safest to try to do it when opening the .sln file instead of the .dts file that was exported from SQL 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
November 5, 2009 at 11:41 pm
This is a common behavior for which the only solution, I have been able to get to work or seen posted on the net as a solution, is to use...
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
November 5, 2009 at 11:36 pm
within a single script task you could use the if exists condition and then perform an insert if records exist from that table
if exists (select tableid from tablea)
begin
...
end
else
if exists...
Otherwise you...
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
November 5, 2009 at 11:32 pm
SPs only require the latest SP.
For the security updates between SPs, you will need to apply each of those (i.e. there are two separate security updates to apply for SP3...
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
November 5, 2009 at 11:22 pm
Thanks Bob. Having been to PASS in the past, I already knew what I was missing. It really sucks to not be able to go this year -...
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
November 5, 2009 at 10:45 pm
That kind of query should return much quicker. As the others said though, post more info and we can help more effiiciently.
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
November 5, 2009 at 10:22 pm
Tuning the UDFs will gain you a little. I would look somewhere else in the UDF to try for performance improvement. Maybe an index has been missed or...
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
November 5, 2009 at 5:02 pm
Viewing 15 posts - 19,186 through 19,200 (of 19,560 total)