Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,401 through 8,415 (of 59,091 total)

Reply To: Incorrect date from control table

I don't know much about SSIS but, if I had to guess, I'd say that the 1900 date has absolutely nothing to do with file names. I'd say that SSIS...
--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)

November 11, 2019 at 1:26 pm

#3696701
Reply To: Execute a procedure with parameter from table, one by one

p.s. You might want to post the stored procedure and the contents (or a least a sample of) the control table. See the first link in my signature line below...
--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)

November 11, 2019 at 1:21 pm

#3696699
Reply To: Execute a procedure with parameter from table, one by one

christoph.kauflin wrote:
thanks for your answer. I googled batch mode and I guess I need some more experience and knowledge before I'd be able to transform my code into batch mode.
Probably...
--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)

November 11, 2019 at 1:19 pm

#3696697
Reply To: How to Dynamically roll-up column results

shani19831 wrote:
Hi Jeff
Yes the datatype is represented that way within the DB.
I'm also worried about Policy and BatchMonth. I will talk to the Database Administrator as Policy should be Char while...
--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)

November 11, 2019 at 1:10 pm

#3696694
Reply To: Parameter pain

Short, sweet, and very much to the point. Nice job, Mike.
--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)

November 11, 2019 at 4:17 am

#3696593
Reply To: A Big Week for the Data Platform

Like Brent Ozar, I'm really excited about a lot of things coming out in 2019 but, once again, MS has produced a poop sandwich and, everyday, you must take 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)

November 10, 2019 at 7:10 pm

#3696569
Reply To: How to Dynamically roll-up column results

Are the datatypes for the sample table in the original post representative of what you have for the real table in production?
--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)

November 10, 2019 at 6:53 pm

#3696568
Reply To: How to Insert million of records into a table?

Thanks, Kev but... darn it all. I was hoping you remembered more details because it sounds like a wicked interesting problem and I was going to set something up to...
--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)

November 10, 2019 at 12:07 am

#3696510
Reply To: Are the posted questions getting worse?

jasona.work wrote:
Jeff Moden wrote:
Major congrats on the "term" to "perm" thing. They should rename the "term" position to "Damocles".
As for migrating SSIS packages, I've discovered a sure fire way to not...
--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)

November 9, 2019 at 3:51 pm

#3696482
Reply To: Replication help

jpnorman103 wrote:
Hi all,
I'm fairly new to the dba side of things, and wondered if you could give me some pointers as to a possible solution to an issue that's occurred...
--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)

November 9, 2019 at 3:35 pm

#3696481
Reply To: Managing Recursive Group on SSRS Reporting Services Reports

Mohamed I. wrote:
Hi
Thank you for your compliment
This will encourage me writing more article 🙂
It's good question about performance in large dataset when using recursive group
It will be nice to make 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)

November 9, 2019 at 3:33 pm

#3696480
Reply To: How to Insert million of records into a table?

p.s. The questions I asked above (and possibly more) would be the kind of questions (obviously not identical because there were no deletes) that I would have asked an interviewer...
--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)

November 9, 2019 at 3:21 pm

#3696479
Reply To: T-SQL query to get the latest available backup chain

ScottPletcher wrote:
Jeff Moden wrote:
Estimating the space requirement for database restores from the backup size can be really misleading. One of the largest problems in this area is that free space in...
--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)

November 8, 2019 at 10:12 pm

#3696411
Reply To: T-SQL query to get the latest available backup chain

This is a nice script and I thank you for taking the time to post it.
Just a couple of thoughts, though. Your article states...
This query can be helpful for knowing...
--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)

November 8, 2019 at 4:13 pm

#3696297
Reply To: Are the posted questions getting worse?

jasona.work wrote:
Well, I'm becoming a happier camper...
Sunday I officially flip from being a "Term" appointment (and thus needing to essentially compete for my job every couple years,) to a "Perm"...
--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)

November 7, 2019 at 11:54 pm

#3696134

Viewing 15 posts - 8,401 through 8,415 (of 59,091 total)