Viewing 15 posts - 10,381 through 10,395 (of 19,560 total)
I see that one can register to be mentored, and that you have a list of Mentors. Is there a process to expand on the list of mentors?
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
April 20, 2011 at 6:56 pm
GilaMonster (4/20/2011)
LutzM (4/20/2011)
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
April 20, 2011 at 12:38 pm
This should get you what you need.
select DB_NAME(database_id) as DBName, COUNT(database_id) as NumConnections
From sys.dm_exec_requests
Group by DB_NAME(database_id)
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
April 20, 2011 at 11:23 am
I would just go with the index rebuild and keep the free space in the file. This will help overall performance down the road by decreasing the likelihood of...
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
April 20, 2011 at 10:58 am
Abacus
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
April 20, 2011 at 10:52 am
You're welcome. I had run into a similar thing many moons ago.
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
April 20, 2011 at 10:51 am
Brandie Tarvin (4/20/2011)
LutzM (4/20/2011)
bitbucket-25253 (4/19/2011)
opc.three
The SSMS Tools Pack rocks! and so do RAR files
Care to share the link for the Tools Pack?
Is there anything wrong with the link...
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
April 20, 2011 at 10:44 am
you should be able to follow this and add in the pieces that you need.
with emp_schedule as (
Select shift_start_time = '2011-04-01 07:00:00'
...
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
April 20, 2011 at 10:40 am
You didn't have all of that info included in your first posts.
I provided two sample queries to help you figure out what needs to be done. Add in 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
April 20, 2011 at 10:13 am
Excellent straight forward question.
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
April 20, 2011 at 8:18 am
bitbucket-25253 (4/19/2011)
opc.three
The SSMS Tools Pack rocks! and so do RAR files
Care to share the link for the Tools Pack?
Not a direct link but I have it linked in...
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
April 19, 2011 at 7:42 pm
Jeff Moden (4/19/2011)
GaMusicMan (4/19/2011)
Here is the solution if anyone else has a similar project....
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
April 19, 2011 at 7:33 pm
SELECT * FROM sys.configurations
ORDER BY name ;
GO
The only one you will see though is xp_cmdshell - because the others do not have a setting that is configurable on or off.
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
April 19, 2011 at 7:11 pm
What are the metrics you are trying to include in those rows? Knowing the metrics or desired data affects the answer.
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
April 19, 2011 at 6:51 pm
just xp_cmdshell is a configurable option of those xp's listed.
These xp's listed do not exist in sql 2008, those were sql 7 (maybe 2000 too)
xp_dsninfo
xp_enumdsn
xp_getfiledetails
xp_eventlog
The others...
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
April 19, 2011 at 6:42 pm
Viewing 15 posts - 10,381 through 10,395 (of 19,560 total)