Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• if some old fucntions are not supported in version then how to chnage those functions?

  HI Champs, I want to upgrade sql server 2005 to sql server 2014 . In case if some old function may …

  ravi@sql

  5 replies

  10 years ago

  By: ravi@sql

• Newbie question - SQL server / development

  I would like to connect to real estate transaction data service (RETS), download data and do some c…

  sa02000

  7 replies

  10 years ago

  By: Jeff Moden

• Problems with duplicates

  Hi I am having some problems coding with sql. Very new at this. I'm using sql server 2014. Anyway, …

  fernando.arias

  19 replies

  10 years ago

  By: Eric M Russell

• SSMS 2014, Visual Studio 2013 and Windows 10 insights?

  I work for a small company that hasn't been accustomed to thinking about how desktop upgrades may a…

  pharmkittie

  2 replies

  10 years ago

  By: pharmkittie

• Rounding off issue.

  The number_value column from the source should be multiplied with two multiplier columns. The mult…

  nchellaaraam

  1 replies

  10 years ago

  By: Ant-Green

• Concatenating rows in a select horizontally...

  Hi, Can you help me please? I'm using the SQL indicated below: SELECT DISTINCT C.Field1 As 'Gr…

  jellybean

  3 replies

  10 years ago

  By: sam-1083699

• Trying to calculate running difference in values between days

  Hello, I am trying to write a query to calculate the running difference between data on different d…

  brianconner

  4 replies

  10 years ago

  By: LinksUp

• Memory-optimized queries using table scan instead of seek

  I've been having some trouble getting a single-column "varchar(5)" field to reliably use a table se…

  Wayne Erfling

  13 replies

  10 years ago

  By: Wayne Erfling

• Best way to find how much of my partition filegroup contains data?

  I have partitions that I have filled with data. I am not trying to figure out exactly how much data…

  kyagi.jo

  3 replies

  10 years ago

  By: kyagi.jo

• Persisted computed column not acting very persisted...

  The short version of the story is this... I have a Column called "BillID" that is a VARCHAR(20) dat…

  Jason A. Long

  20 replies

  10 years ago

  By: Eric M Russell

• multi-part identifier could not be bound

  Greetings Everyone, I scoured the forum and internet trying to figure out what is wrong with this q…

  cthorn112

  8 replies

  10 years ago

  By: kyagi.jo

• Indexed View not being used for Partitioned Clustered Columnstore Index

  I am trying to use an indexed view to allow for aggregations to be generated more quickly in my tes…

  kyagi.jo

  1 replies

  10 years ago

  By: Grant Fritchey

• Alter Table Add 2 Fields Takes Too Long

  Hello all. I have a strange one that i have never encountered and at this point am totally lost. We…

  zulmanclock

  4 replies

  10 years ago

  By: Eric M Russell

• Clarion Date Conversion

  The database for our software stores dates and times in clarion format. I'm trying to write some c…

  jason_in_mi

  2 replies

  10 years ago

  By: Jacob Wilkins

• Painful datetime conversion

  I have a very awful table structure that I have to deal with. This is in an ERP and I can't change …

  Sean Lange

  62 replies

  10 years ago

  By: Jeff Moden