Forum Replies Created

Viewing 15 posts - 256 through 270 (of 1,838 total)

  • Reply To: sql server connectivity

    vsamantha35 wrote:

    Error message from application log from app team

    =====================================================

    Error connecting to database [

    [Informatica][ODBC 20101 driver]7505

    Database driver error...

    Function Name : Connect

    Database driver error...

    Function Name : Connect

    Database Error: Failed to connect to...

  • Reply To: Max window function with order by

    if you compare the results with the ORDER BY t.start_Date and without, it might be clearer.  Just having PARTITION BY t.customer_id will get the MAX(end_date) for each customer_id and return...

  • Reply To: Outer Joins

    An example is below, say you want to query how many orders your customers have, but include in the output customers who don't have any orders at all:

                

    October 15, 2019 at 9:12 pm

    #3689083

  • Reply To: CPU Usage high

    If you aren't sure if the CPU usage is by SQL Server or something else, you can look in the ring buffer to see recent history:

    DECLARE @ms_ticks...
  • Reply To: different state on the same error message

    DamianC wrote:

    Does it store these states anywhere though?

    State is not really a part of the error itself, but extra information that is added when RAISERROR is called that can help...

  • Reply To: @@TRANCOUNT

    I think what may be more important is to understand when to use transactions and how nested transactions affect the script.  Typically you wouldn't put a single command within a...

  • Reply To: Why no posts?

    Where I'm at we do about 80% of our data warehouse work on premises and 20% in the cloud.  I've worked in IT for 25 years, and it's important to...

  • Reply To: Are the posted questions getting worse?

    Sean Lange wrote:

    LOL pretty much. It really is shocking how many people still use varchar for dates and sql injection.....

    Ugh... you had to bring up that memory for me!  I had...

  • Reply To: GUID vs SID

    I believe those are separate attributes of the user in active directory, they don't directly translate back and forth to each other, other than looking up the account by one...

  • Reply To: SQL Server Logs Export

    I believe that SQL Server logs are already text files.  On your server, take a look at the following or equivalent folder:

    C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Log

    The files named:  ERRORLOG.*  are the...

  • Reply To: Extended event - Capture blocking only when stored procedure is running?

    The Blocked Process Threshold in SQL Server is measured in seconds, so the minimum would be 1 second.  You'd have to shred the XML in the Blocked Process Report to...

  • Reply To: SQL Licencing and a move to Opensource RDBMS'

    I doubt they will do that, but I was honestly surprised when they upped it to 10 GB.  The biggest problem I see with on-site software licensing these days from...

  • Reply To: syadmin verus server admin

    It is possible the database was upgraded to 2008 R2 from an older version that did already have BUILTIN\Administrators as a login.  I don't think there is anything in the...

  • Reply To: SQL Licencing and a move to Opensource RDBMS'

    In my opinion, for most people's purposes any RDBMS will suffice and they won't miss those extra features of Microsoft.  If they have a new system they are evaluating what...

  • Reply To: SQL Server Failover Cluster vs Failover Cluster Instance

    I suppose the best way to think about it, WSFC is at the operating system level, and FCI is at the SQL Server level.  You can have WSFC without FCI,...

Viewing 15 posts - 256 through 270 (of 1,838 total)