Viewing 15 posts - 15,991 through 16,005 (of 19,560 total)
repent_kog_is_near (3/24/2010)
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 24, 2010 at 11:17 am
Jack Corbett (3/24/2010)
Les Cardwell (3/24/2010)
Steve Jones - Editor (3/24/2010)
I'd like to see this start going, though I think we need a forum, and a long debate on the PASS site....
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 24, 2010 at 11:14 am
I would like to see the Summit move around. It might give me an opportunity to see different cities.
Holding it in Seattle is fine by me, I like 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
March 24, 2010 at 11:11 am
Nice article. Thanks for the other articles in the series 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
March 24, 2010 at 10:58 am
cclark-1005023 (3/24/2010)
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 24, 2010 at 10:57 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 24, 2010 at 10:48 am
Gianluca Sartori (3/24/2010)
You definitely have to check out this[/url] and this.Very funny.
Ah yes, it is all coming back to me now. I remember a blog about tibbling and then...
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 24, 2010 at 10:47 am
The Dixie Flatline (3/24/2010)
Just to be cruel... go into query options (on someone else's machine) and change the batch separator from "GO" to "SELECT".
That is totally rotten.
I like it.
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 24, 2010 at 10:46 am
srivishiva (3/24/2010)
Thanks. This query also returns "dbo", not the NT login or the database userid of the user
You will note that I specified that it will return the schema owner....
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 24, 2010 at 10:43 am
For me, it did run better. I have seen it not perform as well. That is due to improper configurations or code.
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 24, 2010 at 10:42 am
You need to find what is causing the query you pasted to execute. Find what is causing that query to run, and then change it so that query is...
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 24, 2010 at 10:40 am
To find out the schema_owner for each table, you could do the following:
Select o.name, schema_name(o.schema_id)
From sys.objects o
To find out further permissions, I have a blog post on the topic at:
http://jasonbrimhall.info/?p=391
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 24, 2010 at 10:36 am
IROFLOL
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 24, 2010 at 10:23 am
back
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 24, 2010 at 10:20 am
Tom Brown (3/24/2010)
Paul White NZ (3/24/2010)
Tom Brown (3/24/2010)
Finally put IE out of its misery after it had swallowed 1.5Gb and showed no sign of return after 5 mins.
Is...
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 24, 2010 at 10:19 am
Viewing 15 posts - 15,991 through 16,005 (of 19,560 total)