Viewing 15 posts - 15,331 through 15,345 (of 19,564 total)
Jeff Moden (4/5/2010)
CirquedeSQLeil (4/5/2010)
I have started a new thread on this topic.http://www.sqlservercentral.com/Forums/Topic897076-10-1.aspx
Nah.... I'd rather see this discussion continue here instead of essentially double posting. Sorry Jason.
I can continue to...
April 5, 2010 at 4:38 pm
Jeff Moden (4/5/2010)
I'd rather see the discussion continue on the thread which started it all rather than essentially double posting. Sorry Jason.
I know. There are reasons to move...
April 5, 2010 at 4:36 pm
Jeff Moden (4/5/2010)
Heh... everyone forgot how to eliminate all contention for the table immediately... rename the table. 😛
That is too friendly - drop it altogether 😛
Then again, the contention would...
April 5, 2010 at 4:34 pm
Jeff Moden (4/5/2010)
if 234 is 02:34 then why on Earth would 1 be anything but 00:01???? :blink:
Nice catch there Jeff.
April 5, 2010 at 4:33 pm
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
...
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...
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
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...
April 5, 2010 at 4:17 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...
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.
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.
April 5, 2010 at 4:01 pm
Sounds like a good plan.
Good luck to you and Fred.
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...
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...
April 5, 2010 at 3:46 pm
Viewing 15 posts - 15,331 through 15,345 (of 19,564 total)