Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,751 through 21,765 (of 59,072 total)

RE: Are the posted questions getting worse?

WayneS (1/22/2015)
Jeff Moden (1/22/2015)
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....
--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 9:30 pm

#1772477
RE: compress existing backup file?

ericb1 (1/22/2015)
any help is appreciated, I have a SQL 2012 enterprise server, and I'm using Commvault as my backups. So commvault can restore a .bak file to my server,...
--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 8:15 pm

#1772469
RE: Custom Aggregations (Measuring Headcount Attrition).

Perhaps a simplified version of the method in the following article would do. It would also help a lot with other things you might ask of the hierarchical data.
http://www.sqlservercentral.com/articles/T-SQL/94570/
--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 8:01 pm

#1772466
RE: Please explain what this Trigger query does

To add to my suggestions on the Employee table, I just don't understand the need for a "ChangeType" column in the Employee table unless it means something totally different than...
--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:55 pm

#1772463
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

Viewing 15 posts - 21,751 through 21,765 (of 59,072 total)