Viewing 15 posts - 15,331 through 15,345 (of 19,560 total)
Interesting Query. I like what you have done with it.
Here is something that should work for you.
SELECT
I.NTUserName,
I.loginname,
I.SessionLoginName,
I.databasename,
Min(I.StartTime) as first_used,
Max(I.StartTime) as last_used,
S.principal_id,
S.sid,
S.type_desc,
S.name
,EC.client_net_address
FROM
sys.traces T CROSS Apply
...
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 5, 2010 at 4:32 pm
GregoryF (4/5/2010)
declare @IPAddress as varchar(15)declare @data XML
set @data = EVENTDATA()
set @IPAddress = @data.value('(/EVENT_INSTANCE/ClientHost)[1]', 'nvarchar(15)')
This is the method that I recommended on the other post on the same topic - but...
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 5, 2010 at 4:22 pm
I didn't see that this question was a duplicate post.
Here is the other version of this question.
http://www.sqlservercentral.com/Forums/Topic896983-146-1.aspx
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 5, 2010 at 4:20 pm
Do you know the query that is being executed by the proc sp_executesql?
That proc is really what is being deadlocked. That proc is held inside the resource database 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
April 5, 2010 at 4:17 pm
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
April 5, 2010 at 4:15 pm
You will need to convert these to strings (varchar) in order to place a 0 in front of or behind an int.
To append or prepend the number with 0's, 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
April 5, 2010 at 4:10 pm
Henrico Bekker (3/23/2010)
MS 70-452http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab1
I would go with this one 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
April 5, 2010 at 4:02 pm
thinknight (3/19/2010)
Hi All,On Tuesday I passed 70-450 by studying Microsoft SQL Server 2008 Administrator's Pocket Consultant. It is the best choice.
Now i am preparing to 70-433.
Regards
Congrats.
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 5, 2010 at 4:01 pm
Sounds like a good plan.
Good luck to you and Fred.
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 5, 2010 at 3:58 pm
I think another important thing that needs to be done with this information is to disseminate it.
dma-669038 has taken the idea to her UG. I think following that example...
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 5, 2010 at 3:48 pm
WayneS (4/5/2010)
CirquedeSQLeil (4/5/2010)
I think the next viable topic would be to hash out how the review board should be handled.
So, how will...
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 5, 2010 at 3:46 pm
Something from the old thread that should be ported over.
WayneS (4/5/2010)
CirquedeSQLeil (4/5/2010)
I think the next viable topic would be to hash out...
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 5, 2010 at 3:45 pm
I have started a new thread on this topic.
http://www.sqlservercentral.com/Forums/Topic897076-10-1.aspx
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 5, 2010 at 3:44 pm
Have you taken any other certifications?
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 5, 2010 at 3:26 pm
dma-669038 (4/5/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
April 5, 2010 at 3:20 pm
Viewing 15 posts - 15,331 through 15,345 (of 19,560 total)