Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Getting data based on group

  First post so apologies for the etiquette. I'm trying to retrieve some data that is missing by…

  prefet

  6 replies

  8 years, 10 months ago

  By: prefet

• top 1000 added to linked server select taking forever to run

  We have a mysql database that we are referencing in sql server via linked servers. Our report guy h…

  Snargables

  7 replies

  8 years, 10 months ago

  By: Jeff Moden

• Msg 547, Level 16, State 0, Line 1 The INSERT statement conflicted with the FOREIGN KEY constraint "fkInventory_TagAlongs". The conflict occurred in database "sanroqued", table "dbo.Inventory".

  Insert into Inventory_tagalongs (itemnum, store_id, tagalong_itemnum, quantity)select itemnum, stor…

  chef423

  7 replies

  8 years, 10 months ago

  By: Sergiy

• Indexing Small Temp Tables used to JOIN based on a value being in a range...

  Just wondering if there's much I can do to improve a query that has to join about 70K rows to a tem…

  sgmunson

  14 replies

  8 years, 10 months ago

  By: sgmunson

• SSIS project fail to build - CPackage::LoadFromXML fails

  I have been trying to solve a SSIS project related problem for a week now.The SSIS solution/project…

  joakim.fenno

  11 replies

  8 years, 10 months ago

  By: Phil Parkin

• Worst execution times with indexes than without ?!?

  Hello, I get this surprising result with indexes: they don't help to improve performances. My envir…

  polytropic2310

  10 replies

  8 years, 10 months ago

  By: polytropic2310

• Joining INSERTED and UPDATED tables when PK column changes

  Hi SSC, First off, as should probably be as common as to need no explanation, I did not build the s…

  Xedni

  18 replies

  8 years, 10 months ago

  By: Sergiy

• XP_CMDSHELL & RS.EXE and access rights

  Hi I'm trying a solution where via a stored procedure I map some drives, the frist to store the SSR…

  chris.stuart

  9 replies

  8 years, 10 months ago

  By: John Mitchell-245523

• Searching for date and weekday counts within Nvarchar column

  Hi all, I have an NVarchar column containing assorted data including dates and times, typically in …

  JaybeeSQL

  13 replies

  8 years, 10 months ago

  By: Jeff Moden

• Instead of Update Trigger

  Hi , I created a instead of update trigger . Something like below. Can this be modified and in…

  komal145

  9 replies

  8 years, 10 months ago

  By: sgmunson

• SQLServer 2014 Visual Studio 2013/15 HTTP download Files with different URL's.

  I have the need to download a .zip file from an given URL that changes daily (File Name Chance by t…

  jjoseph 96114

  4 replies

  8 years, 10 months ago

  By: sgmunson

• Report Query

  Hi,     I have a table that is holding data like the following... when    …

  Suth

  9 replies

  8 years, 10 months ago

  By: sgmunson

• Where to put option Recompile in Dynamic SQL

  Hi SSC, I've got a procedure which performs  maintenance on a bunch of tables. It used to be a…

  Xedni

  10 replies

  8 years, 10 months ago

  By: Grant Fritchey

• Query Cost Relative to the Batch vs. statistics io vs. Extended Events

  I'm working on a performance issue and when I compare the original logic with the my proposed new l…

  SoCal_DBD

  5 replies

  8 years, 10 months ago

  By: Grant Fritchey

• Key Lookup to Index Seek?

  Hello All,I am trying to educate myself a little more about Index usage in regards to performance t…

  chris_barnhart

  10 replies

  8 years, 10 months ago

  By: Grant Fritchey