SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Is there a way to exclude records from being loaded when using BULK INSERT?

  Hi everyone I have one record in the source CSV file that is not letting BULK INSERT load the file.…

  water490

  8 replies

  1 month ago

  By: Ken McKelvey

• are the caching messages in ssis for a lookup an indication of poor performance?

  Hi, i am curious if i made the best choices for a lookup component in ssis.    my head is saying 2.…

  stan

  1 replies

  1 month ago

  By: frederico_fonseca

• BULK INSERT messing up import of CSV file with a comma in it

  Hi everyone I am using BULK INSERT to load a CSV.  I have noticed a problem when a value has a comm…

  water490

  2 replies

  1 month ago

  By: frederico_fonseca

• Users Default Schema in a stored procedure.

  One of our systems contains data for multiple organizations.  OrgA should not be able to see OrgB's…

  Michael L John

  1 replies

  1 month ago

  By: Ed B

• Error converting data type varchar to float

  Hi everyone I have a bunch of CSV files that I need to import into SS using BULK INSERT.  One file …

  water490

  2 replies

  1 month ago

  By: water490

• How to convert this to datetime format?

  hi everyone I have a CSV that is storing date as "20180919T201400+0000".  I am using BULK INSERT to…

  water490

  2 replies

  1 month ago

  By: water490

• telephones and sql

  hi im pretty sure i could trigger a page on a pager if i had to from t-sql. but triggering a phone …

  stan

  5 replies

  1 month, 1 week ago

  By: stan

• average duration increasing inline with exec counts

  As the title says , I've got a handful of stored procs where the avg duration rises and falls prett…

  simon_s

  1 replies

  1 month, 1 week ago

  By: Site Owners

• can ssrs detect rls and cls thru proxy like user ids?

  Hi we often use non expiring windows and sql accounts to actually run (credential wise) ssrs report…

  stan

  1 replies

  1 month, 1 week ago

  By: Site Owners

• what etl tool are folks moving toward?

  Hi as we replace on prem machines , sometimes not with vm's, what should we be thinking about for e…

  stan

  30 replies

  1 month, 1 week ago

  By: stan

• Find Duplicate Rows

  What’s the best way to find duplicate rows in a sql query? I heard there is a way where RC is used …

  JP789

  3 replies

  1 month, 1 week ago

  By: rothj

• Is there an ISERROR equivalent in SS?

  Hi everyone I have a SP that just failed.  Format of SP is: Select symbol, date, …

  water490

  4 replies

  1 month, 2 weeks ago

  By: Steve Collins

• is there an elegant way for agent notification to show failure if any step fails

  hi our corp dw load sqlagent job goes to the next step on the 14+ erp loads if they fail.  but quit…

  stan

  7 replies

  1 month, 3 weeks ago

  By: stan

• isnull, coalesce overhead

  hi, one of our sister division's erp extract view is going thru at least one mod to do the equivale…

  stan

  2 replies

  1 month, 3 weeks ago

  By: stan

• Merge spans with Dates Logic

  --for a given member if the startdate and endate is continous we need to keep in single record and …

  dhanekulakalyan

  3 replies

  1 month, 3 weeks ago

  By: drew.allen