Viewing 15 posts - 10,006 through 10,020 (of 19,560 total)
Dup post
post answers here
http://www.sqlservercentral.com/Forums/Topic1114288-169-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
May 24, 2011 at 12:14 pm
NP.
One could also do a logon trigger using this info from MS.
http://msdn.microsoft.com/en-us/library/bb326598.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
May 24, 2011 at 10:59 am
Yes. It was based on knowledge that the newest version had been optimized several times over.
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
May 24, 2011 at 10:50 am
Gianluca Sartori (5/24/2011)
Almost forgot: you can only track the host name, not the IP Address.I guess you can perform the translation later from the app side if you need it.
Just...
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
May 24, 2011 at 10:44 am
Interesting topic today. I know of some shops that adhere to the principle of get it out and come back and enhance later. They aren't shooting for perfection...
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
May 24, 2011 at 10:38 am
Whisper9999 (5/24/2011)
This is for a large server 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
May 24, 2011 at 10:35 am
gdraghetti (5/24/2011)
Thanks for your response.My goal is to keep track in a table of IP addresses of all those who are connected to a sql database.
Have you considered doing that...
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
May 24, 2011 at 10:23 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
May 24, 2011 at 10:06 am
Easy enuf. Thanks for the 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
May 24, 2011 at 10:01 am
This should be better for you.
SELECT PKeyItem,
ItemName,
IsUserItem = CASE WHEN SS.itemuser = ua.pkeyuser THEN 1 ELSE...
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
May 24, 2011 at 10:00 am
jcrawf02 (5/24/2011)
Brandie Tarvin (5/24/2011)
WayneS (5/24/2011)
What's up with all the old threads being resurrected lately? I've seen several this week already... 🙁
Are they "Did you ever find a solution" resurrections, spam...
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
May 24, 2011 at 9:50 am
WayneS (5/24/2011)
What's up with all the old threads being resurrected lately? I've seen several this week already... 🙁
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
May 24, 2011 at 9:21 am
Research
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
May 24, 2011 at 9:19 am
Are you trying to execute the query on a second server against the first server via linked server?
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
May 23, 2011 at 10:48 pm
I am finding this to be somewhat intriguing. I am running these queries and not seeing the same results. Consistently the force order is taking longer to run...
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
May 23, 2011 at 10:46 pm
Viewing 15 posts - 10,006 through 10,020 (of 19,560 total)