Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,781 through 21,795 (of 59,098 total)

RE: Please explain what this Trigger query does

First, look at your EmployeAudit table. You cannot have two columns named the same.
Look at your Employee table. There is nothing to guarantee that the ChangeUserId will be...
--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 22, 2015 at 7:00 pm

#1772458
RE: Horizontal Axis Order

I don't even know how to spell "SSRS" or "MATRIX" in SSRS, but the following article is how I'd do it in T-SQL. Perhaps it will help your situation.
http://www.sqlservercentral.com/articles/T-SQL/71511/
--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 22, 2015 at 5:17 pm

#1772444
RE: how to read contents of flat file in SSIS and extract from it just one value for use in variable?

KoldCoffee (1/13/2015)
From the attached txt file, I need to be able to extract the rowcount for the file having the name '2014-06-20_1403294747_settings_placement.txt.zip' and place it into a variable but...
--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 22, 2015 at 5:04 pm

#1772442
RE: Bending strings

Steve Jones - SSC Editor (1/22/2015)
bump
<HeadDesk> My apologies. Major side tracks and I forgot about it. I'll resurrect it this weekend.
--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 22, 2015 at 1:51 pm

#1772396
RE: Are the posted questions getting worse?

WayneS (1/22/2015)
Any Threadizens going to either the Austin or Cleveland SQL Saturday? I'd love to meet up with you!
I've need seen you since you got your MCM. I'm presenting...
--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 22, 2015 at 1:50 pm

#1772395
RE: Where can I find the definistion of this table value function

mw112009 (1/22/2015)
I mean I know how to get that by going through the menu and drilling down , right click and select "SCRIPT...."
That's not what I really want. ...
--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 22, 2015 at 1:48 pm

#1772394
RE: Database size growth after Rebuild/reorganize job.

Tac11 (1/22/2015)
Hi,
I have a VLDB and have setup 'Rebuild' and 'Reorganize' index job every week. after completion of the 'Rebuild'/'Reorganize' job log generates 100+ GB. And after that another job...
--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 22, 2015 at 10:53 am

#1772334
RE: Use of Function with update

My recommendation is to not mess with this even for formatting the output of rows never mind doing an update to the table with homegrown code.
Instead, by a CASS Certification...
--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 22, 2015 at 10:44 am

#1772330
RE: Where can I find the definistion of this table value function

mw112009 (1/22/2015)
ScottPletcher: Your SQL worked. It happens to be a VIEW.
My Next question: How do I get the definition of a view
j
Apologies for being brutally honest but if you don't...
--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 22, 2015 at 10:40 am

#1772326
RE: What is the best practice about maintain and using Big Log Database

KenpoDBA (1/22/2015)
Or if you don't have Ent then you can use SPs to query the tables and split them up into dated ranged.
When you call the SP you can make...
--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 22, 2015 at 10:37 am

#1772325
RE: Anyone tried "DBA Job Interview Question & Answer Kit"?

@yoshii,
So, did you buy it? And if so, was it worth it?
--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 22, 2015 at 12:20 am

#1772068
RE: Please explain what this Trigger query does

Nope. No error. I kept thinking that MERGE would fire triggers simultaneously if it did both an UPDATE and a DELETE. It doesn't. They're treated as...
--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 22, 2015 at 12:02 am

#1772064
RE: Using a cursor in Sql trigger

dwain.c (1/21/2015)
dopydb (1/21/2015)
Yea only 100 or so inserts a day, otherwise i wouldnt use a trigger at all
Any tips for making it more efficient? 🙂 always interested in other approaches
The...
--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 21, 2015 at 11:39 pm

#1772061
RE: What is the best practice about maintain and using Big Log Database

Yes. Use the SQL Server Enterprise Edition and do Table Partitioning.
--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 21, 2015 at 11:20 pm

#1772060
RE: Please explain what this Trigger query does

Sorry. Spotted a bug in my code and had to take it down. I'll be back.
--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 21, 2015 at 10:34 pm

#1772057

Viewing 15 posts - 21,781 through 21,795 (of 59,098 total)