Viewing 15 posts - 991 through 1,005 (of 19,560 total)
David Atkinson (8/6/2015)
SQLRNNR (8/6/2015)
This certainly looks like a tool that can provide some good benefit. I will have to give it a test drive.
What problem do you think it might...
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
August 6, 2015 at 10:41 am
undo
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
August 6, 2015 at 10:36 am
This certainly looks like a tool that can provide some good benefit. I will have to give it a test 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
August 6, 2015 at 7:46 am
Jeff Moden (8/5/2015)
fnndala2 (8/5/2015)
CREATE FUNCTION fn_SelectTopEmployees ()
RETURNS TABLE
AS
RETURN
(
SELECT TOP(10) EmployeeID
FROM Employees
);
When I run the query, how many times between 1...
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
August 6, 2015 at 7:28 am
Luis Cazares (8/5/2015)
Grant Fritchey (8/5/2015)
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
August 6, 2015 at 7:26 am
Paresh Motiwala (8/6/2015)
Anybody can...
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
August 6, 2015 at 7:22 am
About the simplest method would be to do this:
sys.sp_MSforeachdb @command1 = N'use ?',
@command2 = N'EXECUTE [sourcedatabase].[sourceschema].SearchAllTables'
Or write a cursor that will call the execution of your stored procedure.
Or do...
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
August 6, 2015 at 6:36 am
WayneS (8/5/2015)
SSIS/DTS packages. Including maintenance plans. This is harder to change.
It's pretty easy to change. It's just a script.
If you try changing it otherwise, then yes it can become annoying.
and
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
August 5, 2015 at 4:48 pm
They can own a schema as well.
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
August 5, 2015 at 4:40 pm
We started with:
sqlinterset (8/4/2015)
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
August 5, 2015 at 2:23 pm
Luis Cazares (8/5/2015)
Ed Wagner (8/5/2015)
whereisSQL? (8/5/2015)
Eirikur Eiriksson (8/5/2015)
SQLRNNR (8/5/2015)
poopingPotty
Training
Wheels
Hot
Lips
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
August 5, 2015 at 2:10 pm
Ed Wagner (8/5/2015)
Lynn Pettis (8/5/2015)
Sean Lange (8/5/2015)
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
August 5, 2015 at 2:08 pm
And in "back to the countdown" news:
49,913 posts with this post:-D
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
August 5, 2015 at 1:32 pm
pooping
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
August 5, 2015 at 1:21 pm
Sean Lange (8/5/2015)
Ed Wagner (8/5/2015)
Just don't forget to drop the database when the interview is over. 😉
Or just create the objects in tempdb. :hehe:
Or better yet - don't forget to...
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
August 5, 2015 at 1:12 pm
Viewing 15 posts - 991 through 1,005 (of 19,560 total)