SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• Count(*) output blank but required Zero

  HI All,  I had an requirement to create count of numbers  for every 30 min with few filte…

  Sangeeth Raj

  15 replies

  8 years, 12 months ago

  By: Thom A

• Backup details

  Is there an query to get backup location, retention days, db being backedup. Am looking for an easi…

  balasach82

  1 replies

  8 years, 12 months ago

  By: Igor Micev

• Re-indexing Job (Dynamic Management View permissions?)

  I am trying to configure an agent job run SQL that performs an analysis of fragmentation on all use…

  richardn-671816

  1 replies

  8 years, 12 months ago

  By: Eirikur Eiriksson

• SPROC Stored Proc vs SSIS for Enterprise Wide Dev

  Hi ...been awhile since I last signed in... new job back to my favorite db platform SQL Server 🙂&nb…

  sqlsurfing

  8 replies

  8 years, 12 months ago

  By: sqlsurfing

• Issue while inserting hardcode value into column

  I have declared a table  declare @Emp table (  no bigint identity(1,1) primary …

  mcfarlandparkway

  2 replies

  8 years, 12 months ago

  By: J Livingston SQL

• SQL Server Express and SQL Server Agent?

  I just installed SQL Server Express with Advanced Services but can't manage to get SQL Server Agent…

  Eric Mamet

  5 replies

  8 years, 12 months ago

  By: Jeff Braunstein-302643

• split time

  hi I have the following session columns AMPMDAY AM PM slots up as up to each 3:30 …

  joanna.seldon

  6 replies

  8 years, 12 months ago

  By: Thom A

• Automating linear regressions

  Good morning, I hope I'm on the right place to post my question ... I work on a project for resear…

  petitpere

  4 replies

  8 years, 12 months ago

  By: petitpere

• How to create a views with variable

  The code below can run in store procedure.How to create a views from this code? DECLARE @CODE VARCH…

  adonetok

  3 replies

  9 years ago

  By: Jeff Moden

• PLE drops to Zero every time do REORG of ALL DBS daily,

  This I am seeing on a particular SQL Instance . ( SQL 2012) It is a simple daily maintenance t…

  dvprao

  5 replies

  9 years ago

  By: Jeff Moden

• Lag and Lead Function - Populate Column with Values

  Good Morning, I have a table that contains precipitation accumulation values, but I need to populat…

  walter.dziuba

  10 replies

  9 years ago

  By: walter.dziuba

• Using Case When to Calculate a number of events

  I am needing to calculate the AVERAGE number of times a customer has delivered an order against the…

  Zososql

  2 replies

  9 years ago

  By: Lowell

• how to find Time Difference for different rows

  Hi I need to find the total time had spend by finding min time and max time between number of rows …

  Sangeeth Raj

  3 replies

  9 years ago

  By: Steve Jones - SSC Editor

• Queries Hung on Memory Request

  Server is an x64 VM with Win 2012 and SQL 2012, SP3. It has 32G of ram with 24,576 MB dedicated to …

  Stamey

  20 replies

  9 years ago

  By: Mike Good

• Best from Oscar

  Oscar Awards 2017Oscars 2017

  innuseni

  1 replies

  9 years ago

  By: drew.allen