Viewing 15 posts - 3,316 through 3,330 (of 19,560 total)
http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html
That is probably the most common on the net 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
March 26, 2014 at 9:13 am
If you are using the same session you are probably using the same account. You didn't use a runas in the shortcut for bids or ssms did 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
March 26, 2014 at 9:08 am
You're welcome.
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
March 26, 2014 at 8:53 am
When you attempt to run this in BIDS, are you using the same account that you use to run SSMS?
Many people use different accounts to launch SSMS versus to launch...
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
March 26, 2014 at 8:50 am
You can do this.
SET DATEFORMAT YDM
declare @mindate datetime='2014-25-03 01:02:03'
declare @maxdate datetime='2014-26-03 02:03:04'
select cast(
(cast(cast(@maxDate as float) - cast(@minDate as float) as int) * 24) /* hours over 24 */
+ datepart(hh, @maxDate...
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
March 26, 2014 at 8:36 am
WayneS (3/26/2014)
SQLRNNR (3/25/2014)
Grant Fritchey (3/25/2014)
He got vehement about it. It was fun.I can imagine the fun that could be had. :ermm:
It could even be scary...
Don't poke the bear. 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
March 26, 2014 at 8:20 am
skanker (3/26/2014)
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
March 26, 2014 at 8:15 am
Thanks Andy. I enjoy this style of questions you have been doing.
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
March 26, 2014 at 8:09 am
Grant Fritchey (3/25/2014)
He got vehement about it. It was fun.
I can imagine the fun that could be had. :ermm:
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
March 25, 2014 at 7:44 pm
Dove
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
March 25, 2014 at 7:56 am
You are welcome.
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
March 20, 2014 at 11:18 am
hmbtx (3/20/2014)
Pardon my ignorance on this but I just want to make certain I understand you.
Are you saying that I can do the following:
Using SSMS connect to the remote 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
March 20, 2014 at 11:04 am
No.
You just add the sql agent job to execute each of your required scripts.
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
March 20, 2014 at 10:40 am
That should work.
I have installed EM on Win7 in the past and gotten it to work.
Another option would be to convert those MPs to script based routines.
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
March 20, 2014 at 9:17 am
The maintenance plans between versions are significantly different.
You won't be able to create those plans in that way.
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
March 20, 2014 at 8:55 am
Viewing 15 posts - 3,316 through 3,330 (of 19,560 total)