Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,586 through 6,600 (of 59,102 total)

Reply To: When updating INT to BIGINT do rows with nulls matter

migurus wrote:
Table has 30 million rows, 11 GB in size, I need to alter one column from INT into BIGINT. I need to keep downtime to 10 min max.
Presently there...
--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)

August 22, 2020 at 6:35 pm

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

david.edwards 76768 wrote:
Not sure if this has been done, but I thought I'd have a little fun on a rare day off:
The MSSQL DBA's Prayer:
Our Master, which art in DataCenter
Two-part 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)

August 22, 2020 at 1:45 am

#3782456
Reply To: Setting Start Date

Jeffrey Williams wrote:
The problem with this approach is that you no longer have a dynamic report where the user can select the date range. You have a fixed report for 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)

August 22, 2020 at 1:42 am

#3782455
Reply To: Setting Start Date

Jeffrey Williams wrote:
Jeff Moden wrote:
Jeffrey Williams wrote:
@JeffModen - although your code works in SQL Server, it will not work in an expression in an SSRS report.
Missed the fact that this was an SSRS...
--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)

August 20, 2020 at 10:33 pm

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

Greg Edwards-268690 wrote:
Male mosquitoes do not suck blood anyways, so that statement means nothing. Why don’t they just experiment in the UK?
Hope it gets blocked. If something goes wrong, or horribly...
--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)

August 20, 2020 at 10:13 pm

#3782098
Reply To: Setting Start Date

Jeffrey Williams wrote:
@JeffModen - although your code works in SQL Server, it will not work in an expression in an SSRS report.
Missed the fact that this was an SSRS forum. Thanks...
--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)

August 20, 2020 at 10:07 pm

#3782097
Reply To: SQL Script Help

You won't find many folks that will click on a link on this site. Also, if that other site drops off the face of the planet, then the answer is...
--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)

August 20, 2020 at 10:04 pm

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

Lordy... absolutely nothing could go wrong with this little test, right?
https://www.yahoo.com/news/jurassic-park-experiment-750-million-132816442.html
Apparently they didn't watch the part in the original movie where "nature found a way".
--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)

August 20, 2020 at 7:54 pm

#3782068
Reply To: Job that runs slow how to use more CPU

sqlfriend wrote:
Thanks, I also heard complex logic should handle in business layer not on database layer. Is that just some people's preference?
Personally, I've found that people's opinion of what 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)

August 20, 2020 at 6:00 pm

#3782036
Reply To: Setting Start Date
```
 SELECT  StartDate = DATEADD(wk,-11,DATEADD(dd,DATEDIFF(dd,0,GETDATE())/7*7,0)) --Monday, 11 Weeks ago
        ,EndDate   = DATEADD(wk,  1,DATEADD(dd,DATEDIFF(dd,6,GETDATE())/7*7,6)) --This coming Sunday
;
```
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)
August 20, 2020 at 2:22 pm

#3781971
Reply To: Job that runs slow how to use more CPU

sqlfriend wrote:
There are SSIS packages for other purpose of this project, but not for this process.
Heh... there's no way that I'm even coming close to suggesting SSIS for this or...
--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)

August 20, 2020 at 2:04 pm

#3781967
Reply To: smtp in store procedure

I'll start off by saying that, once you've eliminated the double spacing, the first 463 lines of code are all a part of the dbo.sp_send_dbmail stored procedure, which is 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)

August 20, 2020 at 1:13 am

#3781846
Reply To: Job that runs slow how to use more CPU

Getting back to the original question, the reason why it's not using so much CPU is because it seems to be IO bound (IMHO) due to the RBAR nature of...
--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)

August 19, 2020 at 11:36 pm

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

Speaking of pork chop cannons... here's one that needs about a 9 course dinner. I'll never understand such requests.
https://www.sqlservercentral.com/forums/topic/cutting-out-the-middleman-dba-how-to-give-access-without-involving-dba
--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)

August 19, 2020 at 7:30 pm

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

Greg Edwards-268690 wrote:
Amazing!
Is there a guide for in flight cooking? Frozen, thawed, and properly cooked would be good to know.
The rules for in flight cooking are simple... Frozen only... it makes...
--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)

August 19, 2020 at 7:27 pm

#3781750

Viewing 15 posts - 6,586 through 6,600 (of 59,102 total)