Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Full Text Search equivalent to like operator

  Hi, I have some non sargable queries like below: select * from dbo.test where name like '…

  Srl832

  3 replies

  8 years ago

  By: Srl832

• Differential Restore Question

  SQL 2014My colleagues and I have been debating whether a Differential or Transactional backup (.bak…

  Daniel Tuma

  12 replies

  8 years ago

  By: Daniel Tuma

• AX 2012 MDS connection Access is Denied

  AX 2012 R3 installation with SQL Server 2014. When trying to set up the Master Data Services connec…

  fparker 20089

  1 replies

  8 years ago

  By: fparker 20089

• Stored Procedure Dynamic SQL using sp_executesql Not working

  I can successfully run a Stored Procedure (SP)  that uses dynamic SQL and Exec sp_executesql i…

  Charles_P

  9 replies

  8 years ago

  By: MMartin1

• dm_sql_referenced_entities view-mediated updates

  Hi SSC, Unfortunately I think I probably know the answer, but figured I'd ask anyway. I've been wri…

  Xedni

  3 replies

  8 years ago

  By: Xedni

• Issue with IS NOT NULL in a join

  If I use this: LEFT JOIN[TSI].[ZATS_BROKER_FEED] Z on L.Part_Num = Z.Composite_part and Z.[SUB_ORG]…

  jeffshelix

  4 replies

  8 years ago

  By: ChrisM@Work

• UPDATE() function in a trigger

  I have a database environment to support that features instead-of triggers on views (shudder!!).&nb…

  Aaron N. Cutshall

  11 replies

  8 years ago

  By: Jeff Moden

• How do I get the user login information from plan cache?

  I need to show Userid, numberofQueries they ran on the day and the averageruntime of the query in s…

  SQL_Surfer

  1 replies

  8 years ago

  By: Sue_H

• Grouping records with dynamic groups for report

  Hello All, I'm not sure what is the best what to do this.  I need to create groups for banding…

  Chuck S

  7 replies

  8 years ago

  By: Chuck S

• Finding Table Constraints With Column Level Detail

  Hi All, Could anyone please advise how to go about finding table constraints down to the column lev…

  daniness

  8 replies

  8 years ago

  By: Jack Corbett

• NULL quandry

  I have a situation where I'm trying to determine if a value has changed.  I expected to be abl…

  Aaron N. Cutshall

  2 replies

  8 years ago

  By: Aaron N. Cutshall

• View query was fast with literal in WHERE clause, but super-slow using a variable

  I would like to share my experience recently, in the hope that it helps someone else or that others…

  mbarash

  5 replies

  8 years ago

  By: ChrisM@Work

• Adding SSDT BI Templates in Visual Studio

  I have a new laptop with Visual Studio 2015 Enterprise and SQL Server 2016 CTP 3.1 installed on it.…

  loki70

  12 replies

  8 years ago

  By: Brad Feaker-195979

• Stored procedures from Access in MS SQL Server

  Hi Guys, In Access i have Query where I am using textboxes fields from form: SELECT tbl_Slownik.S…

  jaryszek

  4 replies

  8 years ago

  By: John Mitchell-245523

• Lookup Transformation in SSIS

  IN OLEDB Source I've something like  Select ContactID, NameFROM dbo.TableA  IN Lookup Tra…

  wweraw25

  4 replies

  8 years ago

  By: subramaniam.chandrasekar