Jeff Moden

Forum Replies Created

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

Reply To: Very large t-log with backups

Greg Goss wrote:
@JeffModen,
Okay, I know it took longer than expected, but I finally got my hands on the code that updates that table. Here's the process. Once a record has been...
--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 9:07 pm

#3696867
Reply To: Relational Table SQL Query Optimization/Performance Issue?

ScottPletcher wrote:
To help resolve this problem across the board, for all your queries, you really need to re-cluster the CommoditySupplier table. This is a classic case of the "default clustering...
--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:23 pm

#3696777
Reply To: Need Split delimiter string into columns Solution

Jeff Moden wrote:
satishrao wrote:
Hi Jeff ,
I'm using SQL Server 2012. I just need to split the values and bring in a select statement. I don't want to insert them anywhere.
The see...
--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:10 pm

#3696771
Reply To: CPU frequently Maxing out 100%

Prior to doing a fail over, see if there are any Killed/Rolled Rollbacks.
If there are, I'd say there's a 99.5 % chance that you've been bitten by a problem with...
--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:04 pm

#3696768
Reply To: Always on In PC

Thomas Rushton wrote:
Yes, you can do it using something like VirtualBox on your PC - but you'll need to have plenty of RAM and spare disk space. There are various...
--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 3:45 pm

#3696756
Reply To: Need Split delimiter string into columns Solution

satishrao wrote:
Hi Jeff ,
I'm using SQL Server 2012. I just need to split the values and bring in a select statement. I don't want to insert them anywhere.
The see 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)

November 11, 2019 at 3:12 pm

#3696747
Reply To: Need Split delimiter string into columns Solution

satishrao wrote:
Hi Guys ,
I have column with Values like 1111\123132\34342323\1212. I used the above code to split it . But this doesn't work. The code returns blank. Can you please...
--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:54 pm

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

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