What does 'exclude rows that do not contain values' checkbox do in SQL Profiler?

Clash Royale CLAN TAG#URR8PPP

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0;

up vote
1
down vote

favorite

I want to filter a trace and wonder what does 'exclude rows that do not contain values' checkbox exactly do? Is it to filter all the data columns that are not selected in any event class?

Thanks.

sql-server profiler

share|improve this question

asked 7 hours ago

Eleonora Grigoryan

36911

add a comment | 

up vote
1
down vote

favorite

I want to filter a trace and wonder what does 'exclude rows that do not contain values' checkbox exactly do? Is it to filter all the data columns that are not selected in any event class?

Thanks.

sql-server profiler

share|improve this question

asked 7 hours ago

Eleonora Grigoryan

36911

add a comment | 

up vote
1
down vote

favorite

up vote
1
down vote

favorite

I want to filter a trace and wonder what does 'exclude rows that do not contain values' checkbox exactly do? Is it to filter all the data columns that are not selected in any event class?

Thanks.

sql-server profiler

share|improve this question

asked 7 hours ago

Eleonora Grigoryan

36911

I want to filter a trace and wonder what does 'exclude rows that do not contain values' checkbox exactly do? Is it to filter all the data columns that are not selected in any event class?

Thanks.

sql-server profiler

sql-server profiler

share|improve this question

asked 7 hours ago

Eleonora Grigoryan

36911

share|improve this question

asked 7 hours ago

Eleonora Grigoryan

36911

share|improve this question

share|improve this question

asked 7 hours ago

Eleonora Grigoryan

36911

asked 7 hours ago

Eleonora Grigoryan

36911

asked 7 hours ago

Eleonora Grigoryan

36911

36911

add a comment | 

add a comment | 

1 Answer
1

active

oldest

votes

up vote
4
down vote



accepted

It's basically this

WHERE .. AND TheValue NOT NULL

Like/Not like filters only works on values that exist for that event.

No value is always true and passes the filter: this checkbox removes that

For example:

• You want to see SQL:BatchStarting events


• You filter on Duration

Duration is not valid for SQL:BatchStarting, so the filter is ignored

share|improve this answer

answered 7 hours ago

gbn

62.5k7133209

• 
  
  
  

  
  

  
  
  
  
  
  

  
  Thanks, actually I have one question, if Duration is not valid for SQL:BatchStarting event, if I set a filter on Duration and do not check 'exclude rows that do not contain values' checkbox, isn't it going to be ignored anyway?
  – Eleonora Grigoryan
  7 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  No, the filter would always be true. Which makes sense, in one way: don't filter on something that can't be filtered. This checkbox lets you change that
  – gbn
  6 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  And if I check the box, how is it going to filter Duration for SQL:BatchStarting if that event does not have Duration tracing available?
  – Eleonora Grigoryan
  6 hours ago
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  @EleonoraGrigoryan because other events you filter (SQL:BatchCompleted) might have Duration. I've almost never filtered to one Event type
  – gbn
  4 hours ago
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "182"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: false,
noModals: false,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

 

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name Email

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f217477%2fwhat-does-exclude-rows-that-do-not-contain-values-checkbox-do-in-sql-profiler%23new-answer', 'question_page');

);

Post as a guest

Name Email

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

active

oldest

votes

active

oldest

votes

up vote
4
down vote



accepted

It's basically this

WHERE .. AND TheValue NOT NULL

Like/Not like filters only works on values that exist for that event.

No value is always true and passes the filter: this checkbox removes that

For example:

• You want to see SQL:BatchStarting events


• You filter on Duration

Duration is not valid for SQL:BatchStarting, so the filter is ignored

share|improve this answer

answered 7 hours ago

gbn

62.5k7133209

• 
  
  
  

  
  

  
  
  
  
  
  

  
  Thanks, actually I have one question, if Duration is not valid for SQL:BatchStarting event, if I set a filter on Duration and do not check 'exclude rows that do not contain values' checkbox, isn't it going to be ignored anyway?
  – Eleonora Grigoryan
  7 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  No, the filter would always be true. Which makes sense, in one way: don't filter on something that can't be filtered. This checkbox lets you change that
  – gbn
  6 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  And if I check the box, how is it going to filter Duration for SQL:BatchStarting if that event does not have Duration tracing available?
  – Eleonora Grigoryan
  6 hours ago
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  @EleonoraGrigoryan because other events you filter (SQL:BatchCompleted) might have Duration. I've almost never filtered to one Event type
  – gbn
  4 hours ago
  

  
  
  
  

add a comment | 

up vote
4
down vote



accepted

It's basically this

WHERE .. AND TheValue NOT NULL

Like/Not like filters only works on values that exist for that event.

No value is always true and passes the filter: this checkbox removes that

For example:

• You want to see SQL:BatchStarting events


• You filter on Duration

Duration is not valid for SQL:BatchStarting, so the filter is ignored

share|improve this answer

answered 7 hours ago

gbn

62.5k7133209

• 
  
  
  

  
  

  
  
  
  
  
  

  
  Thanks, actually I have one question, if Duration is not valid for SQL:BatchStarting event, if I set a filter on Duration and do not check 'exclude rows that do not contain values' checkbox, isn't it going to be ignored anyway?
  – Eleonora Grigoryan
  7 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  No, the filter would always be true. Which makes sense, in one way: don't filter on something that can't be filtered. This checkbox lets you change that
  – gbn
  6 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  And if I check the box, how is it going to filter Duration for SQL:BatchStarting if that event does not have Duration tracing available?
  – Eleonora Grigoryan
  6 hours ago
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  @EleonoraGrigoryan because other events you filter (SQL:BatchCompleted) might have Duration. I've almost never filtered to one Event type
  – gbn
  4 hours ago
  

  
  
  
  

add a comment | 

up vote
4
down vote



accepted

up vote
4
down vote



accepted

It's basically this

WHERE .. AND TheValue NOT NULL

Like/Not like filters only works on values that exist for that event.

No value is always true and passes the filter: this checkbox removes that

For example:

• You want to see SQL:BatchStarting events


• You filter on Duration

Duration is not valid for SQL:BatchStarting, so the filter is ignored

share|improve this answer

answered 7 hours ago

gbn

62.5k7133209

It's basically this

WHERE .. AND TheValue NOT NULL

Like/Not like filters only works on values that exist for that event.

No value is always true and passes the filter: this checkbox removes that

For example:

• You want to see SQL:BatchStarting events


• You filter on Duration

Duration is not valid for SQL:BatchStarting, so the filter is ignored

share|improve this answer

answered 7 hours ago

gbn

62.5k7133209

share|improve this answer

share|improve this answer

answered 7 hours ago

gbn

62.5k7133209

answered 7 hours ago

gbn

62.5k7133209

answered 7 hours ago

gbn

62.5k7133209

62.5k7133209

• 
  
  
  

  
  

  
  
  
  
  
  

  
  Thanks, actually I have one question, if Duration is not valid for SQL:BatchStarting event, if I set a filter on Duration and do not check 'exclude rows that do not contain values' checkbox, isn't it going to be ignored anyway?
  – Eleonora Grigoryan
  7 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  No, the filter would always be true. Which makes sense, in one way: don't filter on something that can't be filtered. This checkbox lets you change that
  – gbn
  6 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  And if I check the box, how is it going to filter Duration for SQL:BatchStarting if that event does not have Duration tracing available?
  – Eleonora Grigoryan
  6 hours ago
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  @EleonoraGrigoryan because other events you filter (SQL:BatchCompleted) might have Duration. I've almost never filtered to one Event type
  – gbn
  4 hours ago
  

  
  
  
  

add a comment | 

• 
  
  
  

  
  

  
  
  
  
  
  

  
  Thanks, actually I have one question, if Duration is not valid for SQL:BatchStarting event, if I set a filter on Duration and do not check 'exclude rows that do not contain values' checkbox, isn't it going to be ignored anyway?
  – Eleonora Grigoryan
  7 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  No, the filter would always be true. Which makes sense, in one way: don't filter on something that can't be filtered. This checkbox lets you change that
  – gbn
  6 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  And if I check the box, how is it going to filter Duration for SQL:BatchStarting if that event does not have Duration tracing available?
  – Eleonora Grigoryan
  6 hours ago
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  @EleonoraGrigoryan because other events you filter (SQL:BatchCompleted) might have Duration. I've almost never filtered to one Event type
  – gbn
  4 hours ago
  

  
  
  
  

Thanks, actually I have one question, if Duration is not valid for SQL:BatchStarting event, if I set a filter on Duration and do not check 'exclude rows that do not contain values' checkbox, isn't it going to be ignored anyway?
– Eleonora Grigoryan
7 hours ago

Thanks, actually I have one question, if Duration is not valid for SQL:BatchStarting event, if I set a filter on Duration and do not check 'exclude rows that do not contain values' checkbox, isn't it going to be ignored anyway?
– Eleonora Grigoryan
7 hours ago

No, the filter would always be true. Which makes sense, in one way: don't filter on something that can't be filtered. This checkbox lets you change that
– gbn
6 hours ago

No, the filter would always be true. Which makes sense, in one way: don't filter on something that can't be filtered. This checkbox lets you change that
– gbn
6 hours ago

And if I check the box, how is it going to filter Duration for SQL:BatchStarting if that event does not have Duration tracing available?
– Eleonora Grigoryan
6 hours ago

And if I check the box, how is it going to filter Duration for SQL:BatchStarting if that event does not have Duration tracing available?
– Eleonora Grigoryan
6 hours ago

@EleonoraGrigoryan because other events you filter (SQL:BatchCompleted) might have Duration. I've almost never filtered to one Event type
– gbn
4 hours ago

@EleonoraGrigoryan because other events you filter (SQL:BatchCompleted) might have Duration. I've almost never filtered to one Event type
– gbn
4 hours ago

add a comment | 

 

draft saved

draft discarded

 

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name Email

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f217477%2fwhat-does-exclude-rows-that-do-not-contain-values-checkbox-do-in-sql-profiler%23new-answer', 'question_page');

);

Post as a guest

Name Email

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name Email

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name Email

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name Email

Name Email

Name

Email

Name Email

Name

Email