Here are two more queries, somewhat self explanatory, first one is

CATEGORY-TYPE-NAME-COLOUR-COUNT(COLOUR)

and the second is

CATEGORY-TYPE-NAME-COLOUR-SUBTYPE-COUNT(SUBTYPE)

With a small set of 2000000 records, these are returning in 0.1-0.2 sec on my mediocre...

thomashohner (5/10/2014)

---

Any solutions on using a Laptop with a dual setup? I cant use a docking station. I would like to use two 24" monitors and keep the laptop lid...

Have you looked at Phil Factor's article on string search[/url]?

😎

In my opinion it is not optimal to hard code the data hierarchy in this way. If an attribute is added, it would mean revisiting the code!

The window functions can...

Thanks David for...

This has nothing to do with the Connection MRU (Most Recently Used), the registry keys for 2012/2014...

This query is somewhat self explanatory and answers in most parts your question

😎

USE master;

GO

SELECT

*

FROM

(

SELECT

ROW_NUMBER() OVER

...

Same in slightly different flavor

😎

USE tempdb;

GO

DECLARE @SAMPLE TABLE

(

PERSON VARCHAR(25) NOT NULL

,VAL_1 INT NOT NULL

,VAL_2 INT...

A suggestion, use a Script Component in the Data Flow instead of the Derived Column.

😎

Check out sys.dm_exec_connections and sys.dm_exec_sessions

😎

SELECT COUNT(*) AS SESSION_COUNT

FROM sys.dm_exec_connections

SELECT COUNT(*) AS SESSION_COUNT

FROM sys.dm_exec_sessions SS WHERE SS.host_name IS NOT NULL

Thank you Geoff for this fine and informative articles.

😎

Quick question, what is the driver for improvements if this works?

😎

Phil Parkin (5/9/2014)

---

Eirikur Eiriksson (5/9/2014)

---

Hadrian (5/9/2014)

---

Hi,

I have a folder which receive the CDR and CMR files sended by Cisco.

There is no datetime for them,but I wish to move on another...

Hadrian (5/9/2014)

---

Hi,

I have a folder which receive the CDR and CMR files sended by Cisco.

There is no datetime for them,but I wish to move on another folders separated CDR from...

sqlguy-736318 (5/8/2014)

---

Thanks Eirikur, that's the basic N:N implementation I had in mind. My question was, is N:N the correct relationship for the scenario I'm describing, and under what scenario would...