Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• OLAP SSAS

  Hello, I am new with OLAP I have almost followed all steps to create cube in BI. But when i click o…

  sparikh

  4 replies

  11 years, 11 months ago

  By: Koen Verbeeck

• Best way to build a partitioned clustered columnstore

  I am building three partitioned, clustered column store tables. I was researching whether it was f…

  douglar

  2 replies

  11 years, 11 months ago

  By: douglar

• question about conut in sql

  hello, i have one question thanks for answering select conut(*) as type from tblname where group=a…

  bbf.kurd

  3 replies

  11 years, 11 months ago

  By: ChrisM@Work

• Does anyone have efficient SQL paging code?

  I have the code below, but it seems to be a little slower than i would like, even though the SQL DE…

  isuckatsql

  1 replies

  11 years, 11 months ago

  By: Sean Pearce

• Help in displaying parent and child objects

  Hi, I would appreciate any help in displaying a list of parent and child objects in a certain way, …

  ZombieRick

  2 replies

  11 years, 11 months ago

  By: ZombieRick

• query help needed

  I have one table that contains members, and a query which contains related records of payments made…

  cwalrobinson

  14 replies

  11 years, 11 months ago

  By: Ed Wagner

• Does running multiple SQL queries in the same SP cause latency ?

  I have the following: (a) One Dynamic SQL Query that takes 37 ms when run as a single query or in a…

  isuckatsql

  16 replies

  11 years, 11 months ago

  By: isuckatsql

• Clustered Column Store Indexes vs. Nonclustered Column Store Indexes

  I apologize if this has been talked about previously, but my question should be a relatively simple…

  dmcnair1881

  5 replies

  11 years, 11 months ago

  By: dmcnair1881

• How to automate reports and send them to customers?

  I have been looking for solution to automate the reports. I have many customers and many reports. e…

  shamshad.ali

  3 replies

  11 years, 11 months ago

  By: shamshad.ali

• Since Triggers are a contentious subject, can someone please tell me if mine is written correctly?

  /****** Object: Table [dbo].[TriggerCB] Script Date: 5/12/2014 9:20:12 PM ******/SET ANSI_NULL…

  isuckatsql

  9 replies

  11 years, 12 months ago

  By: Jeff Moden

• Sql Trigger Question on existing table - will an insert trigger populate the counts?

  Can you create a SQL Trigger on an existing table to populate count values, or do you have to creat…

  isuckatsql

  4 replies

  11 years, 12 months ago

  By: isuckatsql

• Generating Auto Relationship

  Hi Team, I would like to create a auto relationship between tables. Currently i am using Northwind …

  madhukars 32911

  11 replies

  11 years, 12 months ago

  By: Grant Fritchey

• Is a SQL View the fastest way to manage multiple count fields, or does SQL 2014 have something better ?

  I need to do lots of filtered counts, similar to the counting done on Ebay or Amazon. eg. Cars(3450…

  isuckatsql

  26 replies

  11 years, 12 months ago

  By: isuckatsql

• Selecting Records Based on Date

  So let's say I have a table Orders with columns: Order# and ReceiptDate. Order#'s may be duplicated…

  jamesheslin123

  9 replies

  12 years ago

  By: David Burrows

• Can you count columns from sys.partition table, if not is select count(1) the fastest way ?

  Can you count columns from a variation of the following query ? set statistics time on SELECT OBJE…

  isuckatsql

  1 replies

  12 years ago

  By: Gail Shaw