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: *

  1. SQLDenis

    error handling in sql server 2000

    read and learn http://www.sommarskog.se/error-handling-I.html http://www.sommarskog.se/error-handling-II.html Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQL Server Programming Hacks
  2. SQLDenis

    Simplest way to email a query result set

    SQL Server 2000 <> SSIS lookup xp_sendmail in BOL Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQL Server Programming Hacks
  3. SQLDenis

    Unions

    ' ' as PROJ08 can not be converted to decimal in the bottom query Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQL Server Programming Hacks
  4. SQLDenis

    SQL Server Log

    not that i know off, run it after hours if you think something might happen Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQL Server Programming Hacks
  5. SQLDenis

    SQL Server Log

    have you tried EXECUTE sp_cycle_errorlog Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQL Server Programming Hacks
  6. SQLDenis

    Percentile Calculation

    lookup case in BOL something like this case when col2=0 then 0 else col1/col2 end Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQL Server Programming Hacks
  7. SQLDenis

    SQL help - pull avg from TOP 3 for each customer in large Database

    take a look here: How Can I Select Multiple TOP N Data Sets With SQL Server (2000 and earlier) Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQL Server Programming Hacks
  8. SQLDenis

    Percentile Calculation

    In case you don't believe me select null * .75 Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQL Server Programming Hacks
  9. SQLDenis

    Percentile Calculation

    so what is 25 percent of NULL? is it N? what about 75% is it NUL? a percentage of null is NULL period! Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQL Server Programming Hacks
  10. SQLDenis

    Stored Procedure runs slow, but same code in query window runs fast.

    I am sorry...but it jst too big here is what you can do have the proc and the code in 1 window, hit CTRL + K (in query analyzer) then F5 this will execute the code and show you the execution plan graphically now look where the percentages are the most different focus on that code and post...
  11. SQLDenis

    Execution Plan Objects

    start here: http://www.sql-server-performance.com/tips/query_execution_plan_analysis_p1.aspx Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQL Server Programming Hacks
  12. SQLDenis

    replication with 200GB database

    Post here for a better answer forum962 Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQL Server Programming Hacks
  13. SQLDenis

    Anyone recommend a good sp book?

    The one and only The Guru's Guide to Transact-SQL Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQL Server Programming Hacks
  14. SQLDenis

    Stored Procedure runs slow, but same code in query window runs fast.

    set showplan_text on --put your code here set showplan_text of [code] set showplan_text on --exec your proc here set showplan_text of [code] first look at the differences in the plans and then paste the results here Denis The SQL Menace -------------------- SQL Server Code,Tips and...
  15. SQLDenis

    Stored Procedure runs slow, but same code in query window runs fast.

    read my previous reply show the execution plans of both Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQL Server Programming Hacks
  16. SQLDenis

    List Database names on server

    select name from sys.sysdatabases Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQL Server Programming Hacks
  17. SQLDenis

    join with no ID or NULL

    faq183-4785 Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQL Server Programming Hacks
  18. SQLDenis

    sp_addextendedproc

    Use this as a workaround for now Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQL Server Programming Hacks
  19. SQLDenis

    sp_addextendedproc

    example 5 might help you http://www.owasp.org/index.php/Testing_for_SQL_Server Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQL Server Programming Hacks
  20. SQLDenis

    Error Message (Microsoft.SqlServer.DTSRuntimeWrap)

    provide more detail Denis The SQL Menace -------------------- SQL Server Code,Tips and Tricks, Performance Tuning SQL Server Programming Hacks

Part and Inventory Search

Back
Top