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!

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

Search results for query: *

  • Users: djj55
  • Order by date
  1. djj55

    Survey says: Most annoying word of the 2016.

    Whatever. djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!
  2. djj55

    Vanity Plates "XVII"

    On newer SUV 80S METL djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!
  3. djj55

    Looping through a table to find records

    I assume your table has a indexed time column as SQL Server does not always store records in the order they are created. djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!
  4. djj55

    Vanity Plates "XVII"

    On a lime green Ford Festiva KRYPTN djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!
  5. djj55

    Vanity Plates "XVII"

    On a Mercedes-Benz SUV B U TFUL djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!
  6. djj55

    Deadlocks

    Have you looked at fragmentation and last update of statistics? djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!
  7. djj55

    Business Titles

    Or he wanted to shade his neck. [wink] djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!
  8. djj55

    Vanity Plates "XVII"

    On a motorcycle VAPE1 The person was wearing a shirt for an electronic cigarette store. djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!
  9. djj55

    Way to switch to a different database from queries.

    You will need dynamic SQL for this, if I am reading your post correctly. By using johnherman suggestion you can create the code you need djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!
  10. djj55

    Vanity Plates "XVII"

    On a pickup truck 3TWO1 GO djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!
  11. djj55

    ifnull

    There is also the NULLIF function NULLIF djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!
  12. djj55

    Use of Get vs Gets

    Get it, got it, good. It would help if there were fewer exceptions in English. I believe this has been discussed before. Not sure though. djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!
  13. djj55

    Vanity Plates "XVII"

    Not real sure what this means but I like to think back at IT: BK AT IT djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!
  14. djj55

    Select latest status with condition... help please

    May not be the best way but... WITH cte AS ( SELECT Network_id, Status_Code, Status_Time, ROW_COUNT() OVER(PARTITION BY Network_id ORDER BY Status_Time DESC) AS rcnt ) SELECT Network_id, Status_Code, Status_Time FROM cte WHERE rcnt = 1; djj The Lord is my shepherd (Psalm 23) - I need someone...
  15. djj55

    Percentage Question Total Records Issue

    If I understand you might try COUNT(DISTINCT Owner) djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!
  16. djj55

    Percent Calculation

    Hello, what exactly are you trying to show the percent of? Most times percent is (somevalue/total) * 100 djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!
  17. djj55

    Heavens to Betsy

    Never thought to find the roots. I actually have not heard the statement for many years and since the only language I am remotely familiar with is American English, I cannot help you. :-) djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!
  18. djj55

    Large transaction log file

    As SQLBill indicated check the size restrictions, then during off hours, after a full backup you can do as you thought. Change to simple, shrink, change to full. This should shrink the size, however you will need to watch the size over the next few days to see if there is excessive growth...
  19. djj55

    Large transaction log file

    1) how much does your database change? this includes rebuilding indexes 2) is the database in log shipping? 3) does it matter if point in time restore is lost for that period? 4) are there uncommitted transactions? I see you are backing up the log file and the database both so that is a good...
  20. djj55

    Vanity Plates "XVI"

    AWY WE GO djj The Lord is my shepherd (Psalm 23) - I need someone to lead me!

Part and Inventory Search

Back
Top