Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Permission - Execute as - Issue

  Hi, Having some trouble seeing where the issue is here:  alter PROCEDURE pec.jpwPermissionTes…

  krypto69

  1 replies

  7 years, 1 months ago

  By: Sue_H

• Truncate Table Over Linked Server to Oracle

  Is there any way to do a table truncation across an oracle linked server?  I have looked up me…

  amy26

  1 replies

  7 years, 1 months ago

  By: frederico_fonseca

• Recursive CTE for Supervisor Hierarchy WITH Effective Date of Reporting Relationship - Updated with DDL and Sample Data

  Okay, I'm editing my request per Lynn's suggestion. Below, in the comments, I'm posting the DDL to …

  DBAless

  18 replies

  7 years, 1 months ago

  By: DBAless

• Combining Two Queries into Single Query

  The view  gives the below output. CREATE VIEW V1 AS SELECT SELECT DISTINCT   PT.PRO…

  jkramprakash

  8 replies

  7 years, 1 months ago

  By: jkramprakash

• SQL Query Help - PIVOT or CROSS APPLY?

  Hi, I have a dataset that looks like this:CREATE TABLE [dbo].[PivotData](    [P…

  amy26

  7 replies

  7 years, 1 months ago

  By: amy26

• Different Index size value for Indexed View

  Hi, I have one indexed view. when I checked it through SP_SPACEUSED and DMVs, it gave me different …

  Mahesh Bote

  1 replies

  7 years, 1 months ago

  By: Jeff Moden

• Inside out on my Where clause logic

  WHERE (B.ELIGIBILITY_FLG <>'Y' or B.ELIGIBILITY_FLG is NULL) and DM.ELIGIBILITY_FLG <>'…

  jeffshelix

  10 replies

  7 years, 1 months ago

  By: Phil Parkin

• When will entire Procedure get Re-Compiled

  Working on a legacy procedure with multiple select statements . From dm_exec_query_stats was able t…

  deepufrancis

  1 replies

  7 years, 1 months ago

  By: Grant Fritchey

• Checking Fulfillment of Prerequisites That Can Contain Elaborate AND/OR Relationships

  I am working with a system in which I can query prerequisites for course enrollment in a query like…

  cranberry

  11 replies

  7 years, 1 months ago

  By: cranberry

• Ways to search Faster In Ms SQL Server

  I want to know the different ways to search fast, efficiently in MS SQL Server. Someone please help…

  Bright@Hanson

  2 replies

  7 years, 1 months ago

  By: Jeff Moden

• Update trigger

  I have insert trigger for inserting records from T_PDF table into T_WV_RESULT Table.…

  jkramprakash

  6 replies

  7 years, 1 months ago

  By: Jeff Moden

• Let SQL do the work ?

  Long time reader, 1st time poster here. I'm trying to build a stored procedure that creates a table…

  onemangathers

  10 replies

  7 years, 1 months ago

  By: onemangathers

• View Query Taking more time

  I have created a view using below tables. This view takes a lot of time for returning output. I am …

  jkramprakash

  9 replies

  7 years, 1 months ago

  By: jkramprakash

• How do I insert into a table that only has a single (identity) column?

  I have a table with only 1 column "fldID". That column is a primary key (to ensure uniqueness), ide…

  Rob

  5 replies

  7 years, 1 months ago

  By: Eddie Wuerch

• Statistics on memory optimized tables

  I am creating the following statistics on a memory-optimized table: CREATE STATISTICS STATS_MyMemO…

  N_Muller

  2 replies

  7 years, 1 months ago

  By: N_Muller