Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Easier Way to Access Extended Events?

  We have extended event definitions on all our non-prod servers, primarily to aid with debugging and…

  Treehouse

  7 replies

  9 years, 1 months ago

  By: Treehouse

• SSAS Calc measure on filtering multi-members

  Hello I am trying to create a formula in Calculated measure Dimension Cell has multiple members inc…

  ashish.shevale

  2 replies

  9 years, 1 months ago

  By: ashish.shevale

• Turn Column into Rows

  Hello, I am looking to take 1 column and take that data and turn it into a row. Basically, I want …

  rjjh78

  2 replies

  9 years, 1 months ago

  By: rjjh78

• want no header row in output

  Is there a way to call a sql select w/o it returning the column header row? Is there some sort of s…

  Snargables

  3 replies

  9 years, 1 months ago

  By: TheSQLGuru

• Query optimization

  Hi all, I've been searching for a tool that would take a query (sql server) and generate alternativ…

  ram302

  6 replies

  9 years, 1 months ago

  By: HanShi

• Questions on filetables

  Currently we have a process that dumps 20 million records into regular tables in database every 15 …

  N_Muller

  6 replies

  9 years, 1 months ago

  By: N_Muller

• An aggregate may not appear in the WHERE clause

  Hi, Having trouble with this one: SELECT * FROM [SQLNODEBSTAGE].[PEC_PROD].[DBO].[Staging_Eligibil…

  krypto69

  7 replies

  9 years, 1 months ago

  By: Joe Celko

• sp_prepexec failing to get the handle

  Hi, my colleagues have a problem where IBM DataPower acts as the gateway between SqlServer and thei…

  WilburSmith

  2 replies

  9 years, 1 months ago

  By: WilburSmith

• HASHBYTES MD5 - problem

  Hi, I run into a problem while loading data into DataVault. I create my dv key with HASHBYTES('MD5'…

  WilburSmith

  5 replies

  9 years, 1 months ago

  By: WilburSmith

• Raging Lion

  Raging Lion[/url] :-Strengthens sexual stamina that makes you stay longer in bed and helps you hold…

  affydatty

  1 replies

  9 years, 1 months ago

  By: Stuart Davies

• Strategy to Move incremental data from Migration Server to Target System in migration

  Hi All, We want to migrate data from Migration SQL server database from final layer to Target(Sql …

  getalok_akg

  8 replies

  9 years, 1 months ago

  By: Jeff Moden

• Copy/Insert Data to another table with different number of columns

  Hello guys, This would be me example. I have some query and my final table looks like: |Country|Re…

  tocy1980

  7 replies

  9 years, 1 months ago

  By: Jeff Moden

• Query Stuck causing Locks, but I see SP:StmtCompleted in SQL Profiler

  Hi, I am experiencing an lock issue. The head blocker query is the following: INSERT INTO DIMENSION…

  Gamleur84

  6 replies

  9 years, 1 months ago

  By: Gamleur84

• CREATE STORE PROCEDURE OPENQUERY

  Dear Friends, I have Syntax like this : INSERT INTO DATABASE_A.DBO.TABLE_A ----THIS IS THE LOCAL …

  Deny Christian

  1 replies

  9 years, 1 months ago

  By: Deny Christian

• check if record exists then update else insert

  i have to check if record exists in table , if there is record then update else insert. Stg_table I…

  hegdesuchi

  12 replies

  9 years, 1 months ago

  By: Gail Shaw