Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,796 through 21,810 (of 59,072 total)

RE: Please explain what this Trigger query does

Eirikur Eiriksson (1/19/2015)
Quick thought, if the table's content is only being maintained with the MERGE statement, it would be better to move the trigger's logic into that implementation, that's straight...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 19, 2015 at 11:17 pm

#1771294
RE: Find Affected Row Count from a Dynamic Query

danurbin (1/19/2015)
Use
[Code]
Set NoCount ON
[/code]
at the beginning of the script. for good measure, turn it back off when done...
Shouldn't need to turn it off. When the session closes, so...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 19, 2015 at 5:48 pm

#1771271
RE: How do I get a list of all the databases within the sever

mw112009 (1/19/2015)
use master
select top 100 * from sys.databases order by name
DONE! Do not reply
"Do not reply"??? What's up with that? Heh... DO NOT REPLY... it's a rhetorical question. 😛
Also,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 19, 2015 at 5:43 pm

#1771270
RE: Creating a trace to log values updates by job

It sounds more like you want "auditing" than a trace.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 19, 2015 at 5:40 pm

#1771268
RE: Query Returning Zero

kabaari (1/19/2015)
Alvin and Andrew,
Those both achieved my goal. I was having difficulty with querying against a getDate() Inserted value. The time is also captured at insert which had thrown some...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 19, 2015 at 5:33 pm

#1771267
RE: Please tel me any good books on profiler and query plan

Grant Fritchey (1/19/2015)
I am clearly biased, but check out the books below in my signature.
I'm clearly biased, as well. I only like good books and these are absolutely two...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 19, 2015 at 5:31 pm

#1771266
RE: Are the posted questions getting worse?

Jack Corbett (1/19/2015)
I'm not taking about Windows Azure SQL Databases, but spinning up a VM in Azure to work with a new feature of Windows/SQL/whatever. Or spinning...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 19, 2015 at 5:25 pm

#1771265
RE: Are the posted questions getting worse?

Eirikur Eiriksson (1/19/2015)
Jeff Moden (1/19/2015)
Jack Corbett (1/19/2015)
Jeff Moden (1/18/2015)
Grant Fritchey (1/18/2015)
WayneS (1/18/2015)
I'm curious...
How many folks have a home lab set up with servers?
How many folks just use...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 19, 2015 at 5:22 pm

#1771264
RE: Please explain what this Trigger query does

@lawlietdba,
I still need to know what the first 3 non-identity columns are in the EmployeeAudit table to be able to write a replacement for you.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 19, 2015 at 5:20 pm

#1771263
RE: Please explain what this Trigger query does

ScottPletcher (1/19/2015)
I still see no reason to risk @@ROWCOUNT if you just want to know if a row was modified or not -- that easy enough to check with EXISTS(),...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 19, 2015 at 5:17 pm

#1771262
RE: Rebuilding Indexes - Clustered v Non-Clustered

ScottPletcher (1/19/2015)
For best overall performance, review "missing index" and index usage stats from SQL Server, then determine first and by far the most important: do you have the best clustered...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 19, 2015 at 5:13 pm

#1771261
RE: Please explain what this Trigger query does

ScottPletcher (1/19/2015)
@@ROWCOUNT is no longer reliable in triggers and should not be used to determine if/how many rows were affected. You have an easy alternative anyway, since you just...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 19, 2015 at 1:58 pm

#1771236
RE: Please explain what this Trigger query does

ScottPletcher (1/19/2015)
@@ROWCOUNT is no longer reliable in triggers and should not be used to determine if/how many rows were affected. You have an easy alternative anyway, since you just...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 19, 2015 at 1:42 pm

#1771233
RE: Using GetDate() between two dates

Briceston (1/19/2015)
I'm using GetDate() in T-SQL. Below is the where portion of my script, which returns no data, there should be data for the intended dates.
WHERE [register _date ]...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 19, 2015 at 1:39 pm

#1771231
RE: Are the posted questions getting worse?

Jack Corbett (1/19/2015)
Jeff Moden (1/18/2015)
Grant Fritchey (1/18/2015)
WayneS (1/18/2015)
I'm curious...
How many folks have a home lab set up with servers?
How many folks just use virtual machines on a...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 19, 2015 at 12:06 pm

#1771199

Viewing 15 posts - 21,796 through 21,810 (of 59,072 total)