Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by gbrian

  1. gbrian

    Access bread crumb values

    How can I access the current bread cumb values with JavaScript? I'm looking to populate some variables with these values to group content. Any ideas? I'm new to SharePoint sorry if this isn't enough detail.
  2. gbrian

    Capturing the document download events

    I used to capture downloads with event handlers on URLs that had extensions matching things like "pdf,doc" on my website for additional event processing. With SharePoint, it seems the web part acts independently from the DOM events and this no longer works. How can I capture the click event on...
  3. gbrian

    Daily logs contain 2 days of data?

    Hello, I'm looking at a set of IIS 6 log files and am seeing the following: #Software: Microsoft Internet Information Services 6.0 #Version: 1.0 #Date: 2008-10-02 04:00:00 The data starts and ends at 4am. Why is this? It means the log file for October 2nd will contain data from 4am October...
  4. gbrian

    Display information about any object on click

    Well, specifically, I just want to trap each MouseUp and MouseDown event, for all objects that exist on the page. This is possible? Where would you start, captureEvents? Ultimately, I would want to be able to record when and where a user clicks/releases the mouse, the timestamps, and whether...
  5. gbrian

    Display information about any object on click

    Is it possible to create a script that would return the information about an object that was clicked? IE - an alert that could return information such as ("Mouse Down on DIV NAME="test" OR "Mouse Up on IMG ALT="test image") without implementing events on each object? Just looking for a high...
  6. gbrian

    Deleted database, logs?

    Hello, Someone deleted one of our databases. Is there any way to find out when it was deleted and/or what host was connected to the server? Thanks, Brian
  7. gbrian

    My stored procedure is creating 20,000+ tempdb extent locks

    IDX_PAGELOGSID nonclustered, unique located on PRIMARY PageLogsID PK_PageLogs clustered, unique, primary key located on PRIMARY PageLogsID IDX_SESSIONID nonclustered, unique located on PRIMARY SessionID PK_SessionLogs clustered, unique, primary key located on PRIMARY SessionID
  8. gbrian

    My stored procedure is creating 20,000+ tempdb extent locks

    George, To show you a troublesome query that uses this non-indexed table: select count(distinct(userid)), 'ZOOM: get specs' from [mazda_at_logging_stats].dbo.sessionlogs WITH (NOLOCK) where sessionid in (select sessionid from [mazda_at_logging_stats].dbo.pagelogs WITH (NOLOCK)...
  9. gbrian

    My stored procedure is creating 20,000+ tempdb extent locks

    George, Thanks so much - I will try these things you have suggested. As far as indexing goes, the majority of the queries are searching a field [querystring] for a string. This field can be 100s of characters long and is searched using wildcards or specific substrings. This table has...
  10. gbrian

    My stored procedure is creating 20,000+ tempdb extent locks

    Hello...this is a nightmare, please help! I have a stored procedure that is a combination of 15 separate queries which each return a result in the form of 'description', count(some_field), and I am using UNION ALL to combine all of these. The result is something that might look like this...
  11. gbrian

    website tracking, server/client side

    Wasn't sure where to ask this but it's a pretty general question.. Obviously with web analytics you have IIS log analyzers (server-side tracking) and Javascript tagging (client-side tracking). However, if a company uses a "server-side" script to process details about your session and stores...
  12. gbrian

    regex, return all <a....> .... </a> from html

    Thanks for this, for some reason it is giving me an error: Unknown modifier 'a' in ... Any ideas?
  13. gbrian

    regex, return all <a....> .... </a> from html

    Hello, I need to create a regular expression so that I can replace anything in an html source file with blank if it does not match the criteria <a *> *</a> Example, <html> <strong><a href="asdf.com"> test1 </a></strong> <strong><a href="asdf.com"> test2 </a></strong> </html> would return: <a...
  14. gbrian

    read uncommitted / nolock, locks still showing up!

    Hello, I have a stored procedure that contains 30 queries all combined with UNION ALL (each query has the same columns and I could use UNION, but anyways..) It takes FOREVER (5 hours?). This data is input into the database monthly and is then never changed (no insert/update/delete going on)...

Part and Inventory Search

Back
Top