SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• SSMS Ctrl+U Shortcut

  For as long as I can remember, Ctrl+U takes you to the list of databases on the server, allowing yo…

  Adam McArdle

  9 replies

  4 years, 12 months ago

  By: tmbr_wulf

• How long will a view stay cached in memory?

  I've inherited a stored procedure that is using a view several times to load temp tables. I'm think…

  dndaughtery

  2 replies

  5 years ago

  By: Grant Fritchey

• How can I improve its query speed?

  Hi, I am facing an extremely slow result from below script. Can anyone advise how can I improve its…

  AhTu_SQL2k+

  9 replies

  5 years ago

  By: Sergiy

• Reorder rank upon condition

  What  i like to do is to rank that when a customer address come more than once ( like 1390 des Rosi…

  Matrix_you

  31 replies

  5 years ago

  By: Eirikur Eiriksson

• spill to tempdb problem

  Hello I have a problem with spill to tempdb.  I've Update Statistics and try to create suitable ind…

  zamani 41951

  24 replies

  5 years ago

  By: zamani 41951

• Exclude square bracket and text from start or end of string

  Hi, I want to remove square brackets and text from either start of string or end of string . Requir…

  PSB

  9 replies

  5 years ago

  By: PSB

• Replace cpecial characters from SharePoint

  Hi, I want to remove ;# coming from SharePoint . The first and last occurrences should be removed a…

  PSB

  11 replies

  5 years ago

  By: PSB

• Convert Access IIF with Switch in MSACCESS to SQL Server

  I am in the process of converting an access query to T-SQL. There is an IIf statement which I am ha…

  Bomac8

  3 replies

  5 years ago

  By: t. Bleadorn

• How to compare strings by letters in certain places

  Hello All, I need help to compare strings, please. For example, I have two strings with various wor…

  BOR15K

  40 replies

  5 years ago

  By: Jason A. Long

• Same code but one is faster and another one is slower

  Do you know why the query 1 runs for hours as  opposed to the query 2 with runs in seconds.? and ho…

  SQLAddict01

  7 replies

  5 years ago

  By: sgmunson

• Fill in missing Dates for Shift

  Hi, I have two tables DimCalendar and DimPersonShift, I want a SQL query which will fill in the mis…

  SQL_Kills

  2 replies

  5 years ago

  By: pietlinden

• Table in sql server 2017 takes alot of time to update/insert few rows

  Hello I have a table in sql server 2017 that has around half million records and it is constantly u…

  mahagh

  4 replies

  5 years ago

  By: Grant Fritchey

• smtp in store procedure

  vDear Team, it is regarding store procedure query for sending an email. i am unable to find the smt…

  Shree23

  6 replies

  5 years ago

  By: Shree23

• How to calculate future CostPrice value based on two other columns please...

  Hello All Good Evening, Can you please help with this Issue --- Sample Data Begins Create Table #…

  asita

  1 replies

  5 years ago

  By: asita

• Fixing a project that was built under the wrong SQL Server version

  Hey everyone, we are running SQL Server 2016. We are using VS SSDT 2017. Recently someone built the…

  dndaughtery

  1 replies

  5 years ago

  By: Mike01