rss.livelink.posts-in-node

Avg duration in hrs

Suresh G — Thu, 14 Jun 2018 12:29:32 GMT

Hi all

i want to caluclate the

how to get in sql server am new to this

avg(SpeedToAnswerDurationSeconds) where interaction type Is Email

SQL Server Certifications

jonathan.graves — Tue, 12 Jun 2018 14:25:24 GMT

Running SQL 2005 on a Windows XP based Allen-Bradely HMI 1200P.

The "Client" that is being ran on the HMI has an alarm history log going to SQL database.

How can I access this log and place into either excel or just a .txt format.

Any help greatly appreciated.

Very inexperienced user.

Replication Publishing takes too long on SQL Server 2016

Christoph Schubert — Thu, 07 Jun 2018 12:15:41 GMT

Hi all,

I have configured a Merge Replication Publishment on SQL Server 2016.

The Database is just 900MB size.

But the publishment takes very long. The initial runtime is about 40 Minutes.

And the next start (just for differences, and there are none) takes 20 Minutes.

We have configured the same replication previously on SQL Server 2008. And there the DB is much larger and the publishment just takes seconds/few minutes for creating the delta.

Has something changed in the SQL versions, why it takes much longer now?

Are there any hints what can be configured additionally to come back to a shorter runtime for the publishment?

Thanks for any help

Christoph

Re: After insert trigger on a table that has a Primary Key

Ahmad Saleh — Tue, 05 Jun 2018 19:08:09 GMT

Thank you, for the suggestions

Error 15404

Alex Samad — Fri, 01 Jun 2018 06:08:21 GMT

New forum user. I am testing MS SQL 2017 on Linux.

I have attached my SQL install to MS AD using https://docs.microsoft.com/en-au/sql/linux/sql-server-linux-active-directory-authentication?view=sql-server-linux-2017

I have added a user (myself) and I can login but when I go to do anything run a query, look at logs or ...

I get error could not obtain information about Windows group/user

error 0x80090304 SQL Server Error 15404

help ?

Thanks

SSRS Reports: Date Parameters not filtering report data

balaji k — Thu, 31 May 2018 10:24:30 GMT

Hi,

I am working on SSRS Reports for which my source is a Tabular Model. when I create a dataset , an MDX query is generated automatically. Now my requirement is that I want to add two date parameters (Start and end dates) using a date picker and use them to filter records. Also I do not have date dimension table in my model. All I have is different date fields in our base tables and so would apply this filter on any required date fields.

This works fine if I use filters on dataset using the date parameters. But the draw back is it fails on bigger data sets as SSRS try to fetch all the records and then applies the filters.

so I am looking for a method to include these date parameters inside MDX query so that it filters the records and then fetches only qualifying records to SSRS. But I am unable to achieve this as of now. I have already posted this question in msdn forum and placing that thread here for reference.

https://social.msdn.microsoft.com/Forums/en-US/40d1c01a-20eb-4f86-9efe-64bfc9ea362b/ssrs-performance-issue-with-date-parameters?forum=sqlreportingservices&prof=required

can some one help me in achieving this?

Thanks and Regards,

Balaji

Error message "KEYSET DOES NOT EXIST" when inserting new node in Windows failover cluster.

Panos Tsapralis — Tue, 29 May 2018 08:55:29 GMT

This is a two (2) nodes Windows Failover Cluster on MS Azure cloud with a SQL Server 2014 Always-On Availability Group running on it. We need to insert 3rd node in the Failover Cluster (and the Always-On AG). When trying to insert new node (using Failover Cluster Manager on one of the existing nodes), I get this error message: "KEYSET DOES NOT EXIST". I have read some posts that this is related to permissions on directory "C:\PROGRAMDATA\MICROSOFT\CRYPTO\RSA\MACHINEKEYS\" and its contents and I have followed advice to modify these permissions - but this did not solve the problem.

Has anyone seen this before? Any ideas would be appreciated.

Thanks.

Panos Tsapralis.

Cloudera 5.14 supported with PolyBase SQL Server 2017?

Doug Bernhardt — Fri, 25 May 2018 18:49:15 GMT

Trying to connect to Cloudera 5.14 on Linux with Polybase but I've been unsuccessful. I noticed that 5.13 is the last version listed here....

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/polybase-connectivity-configuration-transact-sql?view=sql-server-2017

Should I be able to connect to 5.14?

Thanks!

Update exe not working for 17.7

Mordechai Zuber — Wed, 23 May 2018 16:46:08 GMT

Just a heads up for anyone updating SSMS to 17.7, the Upgrade exe seems to have a big where it thinks another installer is already running, so you have to use the other option

Master Data Service in a heterogeneous environment

frederic MICHALAK — Wed, 23 May 2018 12:05:16 GMT

Hello,

We need to implement a MDM (Master Data Management) solution on our data Platform, and I though about SQL Master Data Service (MDS) and Data Quality Service (DQS). The point is SQL Server is not the only data source. We also have HDFS Hortonworks, Postgres and MySQL.

Is MDS fully dedicated to "only MS" environment like I usually see on blogs, or can we plug heterogeneous DBs on that (typically HDFS with Polybase for example) ?

TIA for your help.

Fred.M.

Re: After insert trigger on a table that has a Primary Key

frederic MICHALAK — Wed, 23 May 2018 11:55:20 GMT

Hi Ahmad,

I'm not sure to fully understand your need, but please consider the following bullet :

- From performance perspective, triggers are not the best way to go.

- Why don't you allow your Order record to be childless, and then add a record into the Delivery table after, via user interface typically ?

Finally, to keep your solution in place :

- Define your DeliveryID column as a BigInt, and enable the Identity property to True (ref your screenshot). Then the value of your DeliveryID column will be automatically incremented for each new record.

- Define your DeliveryID column as a UniqueIdentifier, and define a default value as new_sequentialid().

Hope this helps.

Fred.M.

After insert trigger on a table that has a Primary Key

Ahmad Saleh — Tue, 22 May 2018 13:36:31 GMT

Hi All

I have the following 2 tables:

Order with the following columns: OrderID as PK, Order Name, etc.
Delivery with the following columns: DeliveryID as PK, OrderID, date, etc.

I wrote after update trigger on the Order table that inserts a new row to the Delivery table and fills it with the OrderID:

create Trigger CopyOrderID_To_DeliveryTableon Order
for insert 
as 
begin
    declare @ID int

    select @ID = REQUESTID from inserted  

    insert into Delivery (OrderID) 
    values (@ID)
end

This should work fine but the issue here is that the DeliveryID column in the Delivery table is a non-nullable PK. So whenever I try to update the Order table, I get an error message that DeliveryID in the Delivery table doesn’t allow nulls!

How to get rid of this message without altering the DeliveryID column?

A screenshot shows the DeliveryID column properties :

Thank you,

Ahmad

Seeking contributors for SQL Operations Studio Localization

Alan Yu — Wed, 16 May 2018 23:19:59 GMT

SQL Operations Studio is opened for community localization, you can contribute now at https://aka.ms/fjr6sk. For more information https://aka.ms/Cmh14o

SQL Operations Studio is a data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. Check us out on GitHub

Here’s the screenshot the latest localization status:

SQL Operations Studio Localization Status

SQL Server 2017 Tabular Data Model

Raymond Boone — Thu, 03 May 2018 15:56:56 GMT

I've created a tabular data model in Analysis Services. The model is set to update nightly from two SharePoint lists. I can't get the credentials to stick, so the nightly refresh fails.

When I go in and set credentials in SSMS, I can process the model fine. I had another admin process the model and it worked fine. I can even trigger the scheduled job and that works fine as well--regardless of who runs the job. Why won't the credentials stick overnight? Has anyone seen this? Any ideas?

Re: SQL Server 2017 evaluation Full software download

Paul Wong — Thu, 03 May 2018 04:04:45 GMT

It should be a downloader and you can download the ISO with the downloader in your pc and the put the ISO to the target server

SQL Server 2017 evaluation Full software download

Sudhir Ch — Wed, 02 May 2018 15:31:05 GMT

Hi,
I want a full download of SQL Server 2017 evaluation software so that I can transfer that to one of our test servers on the network and install it there. Those servers will not be having internet connection for the installer.exe to download and install.

All I want to do is an offline install. I need full software. All I'm getting from the download page is a 5MB installer. I cannot use that installer on our network servers because they will not be connected to the internet.

I contacted Microsoft support on chat and even that person don't know what to do in this case.

Can anyone help me.

Thanks & Regards,
Sudhir

Installation of SQL Server Express fails due to "password policy"

Boyd IT — Mon, 30 Apr 2018 07:06:41 GMT

I'm attempting to install SQL Server Express 2017 to a Server 2016 Essentials server that is acting as a domain controller, and it's failing when trying to create a "local" SQLEXPRESS00 account, due to a "password policy"

The password policy is default, but may have been modified by the Essentials experience configuration wizard when connecting to Azure. The wizard mentioned something about having to change the password policy to be compatible with Azure.

I attempted to install from the command line, specifying a configuration file and hard-coding the service account passwords (4 different command line flags, all the same password, the password does comply with the policy) but that failed as well.

Anyone know how to install SQL Express on a 2016 Essentials box, hopefully one that's been configured to connect to Azure?

SQL Server DatabaseMetaData getcolumns is not returning column default value

Sreedevi Tankala — Fri, 27 Apr 2018 17:54:50 GMT

I am using the mySQL version 6.0.1 with Spring. I have a stored procedure defined with default values in my SQL server 2014 standard version.

SQLServerDatabaseMetaData get columns method returns all columns information except default value which is always null. Appreciate if i can get some insight on it

@event_id varchar(25) = 'INITIATED',

reading default value of a column

rs.getString("COLUMN_DEF")

what am i missing here

FullText Search with phrases

Sanjeev Kumar Moloye — Fri, 27 Apr 2018 13:59:45 GMT

Hi,

I've set up a FullText search (for French language) on an SQL DB and i'm querying the index using phrases like the following : "BAER module batterie réversible CAD HR basic XL 130"

I'm using CONTAINSTABLE function and i believe its trying to match the whole phrase rather than getting the most suitable match using combination of words in the phrase.

So i believe i need to somehow build a search text using AND, OR etc... to get the best match out of the index or is there some other way to tackle this?

Use SQL Server 2017 Developer edition as UAT server

Paul Wong — Wed, 25 Apr 2018 08:04:15 GMT

Hi,

My company will buy SQL Server 2017 Standard as a production server.

At the same time, we need to have a UAT server for end users to do testing, for this case can we just use the developer edition which is free?

Thanks,

Paul