alfred.h.hernandez (11/7/2016)

---

When I run that query and display the results as text I goes on and on for over a minute, then I stopped. Displaying over 40K rows.

If I run...

Deny Christian (11/7/2016)

---

hi All,

I have a Supplier data :

COMPARE:

SERVER A : V, ...

alfred.h.hernandez (11/7/2016)

---

Thank you for your reply!

Unfortunally I can't see wierd with memory och I/O.

But I just saw that if I display the results to text instead of grid there is...

Don Halloran (11/6/2016)

---

I've used extended events sparingly for admin purposes, but never as a normal developer resource. I wasn't even aware there was a "data change" type of extended event...

Quick suggestion that concatenates all step messages into a single column

😎

SELECT

sj.name

,sj.enabled

,STUFF(

(

...

For fun, here is an alternative method

😎

USE TEEST;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(CID,C1,C2,C3) AS

( SELECT CID,C1,C2,C3

FROM (VALUES

(1,'aa', '100', 'vv')

...

Have you looked into using Extended Events for i.e. triggering a poll etc.?

😎

sqlfriends (11/4/2016)

---

I have a productCase table that we created cases for some products. Then there are some other tables related with this productCase table such as productCaseNotes, ProductCaseNotifications etc.

I would...

Forgot to mention the MSDN online tutorials Tabular Modeling (Adventure Works Tutorial)

😎

berryber (11/5/2016)

---

Normally, googling and messing around, solves 99.999% of my IT (or relationship) problems. This one however, is giving me massive headaches.

Situation:

I have a package which runs over a selection...

alfred.h.hernandez (11/6/2016)

---

Hi,

I recently discovered that when I query a table (anyone I've tested) and the results are more than 1000 rows, Management Studio keeps hanging/lagging.

The more rows the result shows...

I know some of you pretend like you already have some knowledge, when you don't. You act or talk in a conversation like you understand what is being discussed. Then...

Jeff Moden (11/6/2016)

---

To be honest, I'm starting to get really pissed off at people and their "new improved shinny bobbles". I've spent countless hours listening patiently and doing due...

quinn.jay (11/6/2016)

---

Hello, I have Google and Amazon searched foe books and training materials for SQL Server SSAS Tabular, and I find 2012 SSAS Tabular, and pre-order for 2017 materials. Is...

Which SQL Server version(s) and edition(s) are you using?

😎