Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Integrating SQL 2014 with SQL 2000

  I have somewhat of a dilemma to overcome. Basically the company I look after runs SQL 2014 they rec…

  dave 92282

  1 replies

  10 years, 12 months ago

  By: ZZartin

• Transaction isolation level

  Dear friends. I need in your opinion. I use one russian ERP system. In this system documents like i…

  Elnur_gasan

  1 replies

  10 years, 12 months ago

  By: Grant Fritchey

• I need a list of best books on SSAS.

  I want to learn data mining, MDX, SSAS in detail and how it is used for reporting and help in busin…

  shamshad.ali

  2 replies

  11 years ago

  By: Alan Burstein

• Performance Issue with UNION ALL in View

  Hi Guys, I have a performance issue with one of the views when I join the view with a temp table I…

  arjuns911

  7 replies

  11 years ago

  By: joshdbguy

• SSIS doesn't drop table

  I have a T-SQL Statement Task to create table every time the package run. It doesn't return error b…

  ____ KD

  7 replies

  11 years ago

  By: Phil Parkin

• Minimizing Locking on Update statements

  Hi All, I have a main table called Stock for example. One process ( a service ) inserts data into…

  Stephen Knott

  12 replies

  11 years ago

  By: Stephen Knott

• Case sintax in a SQL Store Procedure evalauting 2 Query options

  what will be the best way to write this code? I have the following code: BEGIN declare status_sent…

  montserrat.deza

  2 replies

  11 years ago

  By: montserrat.deza

• SSIS packages are reporting complete before they've finished loading

  We've recently upgraded to SQL Server 2014, and are now using SSIS integrated with Visual Studio. W…

  trentos

  2 replies

  11 years ago

  By: trentos

• SEPARATE WORDS TO ROWS (Convert Comma Separated)

  I have a table Sample with data stored like below ID|STRING | ----------------------------…

  diogo.venturatomas

  4 replies

  11 years ago

  By: serg-52

• Spatial Import of Census Shapes

  Working within SQL Server 2014 the old standby of shape2sql doesn't seem to be working. I even trie…

  Grant Fritchey

  3 replies

  11 years ago

  By: Grant Fritchey

• Round(9.x,0) Error where x >=5 and x <= 9)

  The following statement select ROUND(9.5, 0) gives error: Msg 8115, Level 16, State 2, Line 1 Ar…

  arvind_rn

  3 replies

  11 years ago

  By: J Livingston SQL

• How can I rewrite this in better performance

  Hi How can I rewrite this in better performance : select *, ( SELECT TOP 1 Code FROM T2 WHERE …

  MotivateMan1394

  16 replies

  11 years ago

  By: Gail Shaw

• TRANSFORM VARIABLE - ADD OPERATOR OR

  I have a text box on a web application that allows the user to type what words they want to look. I…

  diogo_1984

  3 replies

  11 years ago

  By: Grant Fritchey

• Using "Try-Catch" and "Rollback" on read only stored procedure

  Hello All, I have a confusion on using "Try-Catch" and "Rollback" on stored procedures. In general …

  SQL_Hound

  14 replies

  11 years ago

  By: Eirikur Eiriksson

• Split and Transform Words

  I have a problem I'm having trouble solving. I have an application I write a textbox: 'SQL SQL' MIC…

  diogo_1984

  2 replies

  11 years ago

  By: Steve Jones - SSC Editor