Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Somebody explain Checkpoint to me

  I'm using the below SQL to delete about 110million rows in batches of 100,000 It's working fine in …

  planetmatt

  7 replies

  11 years ago

  By: Luis Cazares

• Remove memory optimized filegroup

  I read this: http://www.sqlservercentral.com/Forums/Topic1568262-32-1.aspx Which says you must drop…

  Josh Rotert

  3 replies

  11 years ago

  By: Grant Fritchey

• Can I get the user windows login when using Sql server login authentication ?

  Hi everyone, Oracle and Teradata are able to capture the windows/client login that connects to thei…

  Matrixman

  2 replies

  11 years ago

  By: Grant Fritchey

• DDL AND DML STATEMENTS IN SSIS

  I have a situation to write this code in SQL to used in SSIS. if table1.username in (table2.usernam…

  Sangeeth Raj

  5 replies

  11 years ago

  By: Sangeeth Raj

• Creating Mutliple Logins

  I had a need to test something recently and wanted to create multiple logins. Other than using a ba…

  Steve Jones - SSC Editor

  6 replies

  11 years ago

  By: Eirikur Eiriksson

• Find double records within DateTime range

  Hi, thanks for reading my topic. I have a query question. Consider a table with the following struc…

  sirokinl

  11 replies

  11 years ago

  By: Robert-378556

• Access to SQL Server - How to Auto Update Multiple Tables Daily

  I have got 4 MS Access Database Files, which have got 3 Tables each, means Total 12 Tables which ge…

  tlp6327

  4 replies

  11 years ago

  By: tlp6327

• Help with troubleshooting performance

  Hi I have been looking at a SQL agent job that runs. The issue is that it joins a lot of tables as …

  SG87

  2 replies

  11 years ago

  By: Grant Fritchey

• Is there an easier way to do this than to use a CTE?

  Here's the code, followed by the explanation of what I'm wanting to do: --alter view vwStudentsAPHQ…

  Wayne West

  5 replies

  11 years ago

  By: Wayne West

• Trigger on a view

  Hi, I have a situation where I have Table A, Table B. View C is created by joining table A and tabl…

  ajvkumar

  2 replies

  11 years ago

  By: ajvkumar

• Trying to Avoid Dynamic SQL

  I am constructing a query. It will pull data from 10 different databases. Rather than write the cod…

  ducksql@gmail.com

  11 replies

  11 years ago

  By: ducksql@gmail.com

• Add new column with default value

  Hi There, I want to set a default value to a column while adding it. Create table test(id int ) …

  vignesh.ms

  6 replies

  11 years ago

  By: John Mitchell-245523

• TSQL dense rank type question - finding the first date of a budget change (budget values can bounce back and forth in values)

  I am trying to write a query to give me all "budget changes" (and the day they happened) per custom…

  bperrello

  4 replies

  11 years ago

  By: Eirikur Eiriksson

• Connect to SQL Server 2014 from SSMS 2008R2

  Has anyone connected to Server 2014 from SSMS 2008R2? I've seen issues before connecting to Server …

  nick.latocha

  6 replies

  11 years ago

  By: sql-lover

• How to chose delta columns in ssis

  Hi experts, i would like to know the best practices to choose the columns which should be used for …

  vijay.sap1255

  1 replies

  11 years ago

  By: manub22