Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Execute a query on DB in Full Recovery Model without write to ldf/log file

  Hi,Is it possible to execute a query on a database which is in full Recovery Model without write to…

  amns

  8 replies

  8 years, 11 months ago

  By: Jason A. Long

• What's the best way of getting this to work?

  Hi All, I'm working on an SP that will be run as part of an SSIS package and I'm not sure of the be…

  craig.bobchin

  11 replies

  8 years, 11 months ago

  By: Phil Parkin

• Query help for getting Hierarchy data

  Need help on a query getting hierachy data.I have the following table and data arranged as below. d…

  s-sql

  3 replies

  8 years, 11 months ago

  By: Thom A

• SELECT timestamp in 20 second intervals

  Hello, I have been tasked with the assignment of searching for BOTs in our database. I have 1 SQL t…

  Lord Slaagh

  5 replies

  8 years, 11 months ago

  By: Lord Slaagh

• Error: Msg 529, Level 16, State 2, Line 4 Explicit conversion from data type datetime2 to float is not allowed.

  Hello, Any assistance would be much appreciated! We just upgraded to SQL Server 2014 but when I tr…

  Tn37355

  7 replies

  8 years, 11 months ago

  By: DesNorton

• How to get MIN,MAX and AVG time

  I have a logic in my Stored procedure ,where I want to check the timings of min,max and avg ti…

  mcfarlandparkway

  7 replies

  8 years, 11 months ago

  By: pietlinden

• Table Valued Function with primary key and spatial index - is this possible?

  Good morning, I have tried to find documentation of it but have been unable to. Can someone please …

  olibbhq

  3 replies

  8 years, 11 months ago

  By: drew.allen

• Issue with while loop

  I have a while loop simple loop - where I am retrieving 10000 records.When I ran in sql server - it…

  mcfarlandparkway

  8 replies

  8 years, 11 months ago

  By: Ed Wagner

• Exporting multiple rows to 1 CSV column using BCP

  Hello, I am working on a data export where I want to export my SQL query to CSV.  I have a row…

  rjjh78

  2 replies

  8 years, 11 months ago

  By: rjjh78

• Long running insert

  Hi! Having problem with an insert that take very long time to complete, there is a warning about Ty…

  Johan Fredin

  9 replies

  8 years, 11 months ago

  By: whenriksen

• Copying Data

  Hi, i have daily job which copies data from production to uat.i want to know know what are chnages …

  Diyas

  4 replies

  8 years, 11 months ago

  By: sgmunson

• Point Stored Procs At Read-only Instance of AG Group

  I am migrating from a SQL 2005 to a SQL 2014 Always on EnvironmentWe have a set of stored procedure…

  swoozie

  4 replies

  8 years, 11 months ago

  By: swoozie

• Combining 2 different datasets

  Hi combine 2 datasets that have different column names, different data and different number of colu…

  Trybbe

  3 replies

  8 years, 11 months ago

  By: John Mitchell-245523

• Dynamic SQL Help needed: Why doesn't this work?

  All, I'm working on a proc to do a recordcount of all tables and views in a database to compare to …

  craig.bobchin

  7 replies

  8 years, 11 months ago

  By: Luis Cazares

• Identify objects that do not use an Identity Column but a Lookup Table to generate an Unique Identifier

  I need to Identify objects that do not use an Identity Column but a Lookup Table to generate a…

  Welsh Corgi

  33 replies

  8 years, 11 months ago

  By: drew.allen