Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,401 through 11,415 (of 59,095 total)

RE: The Best Days

I've not worked on anything that had the impact that Rod has described but my best days are when I know I've made a difference for someone either in code,...
--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 26, 2018 at 10:26 am

#2003355
RE: Database in Full recovery mode, with NO logbackups but logshipping setup

caz100 - Sunday, August 26, 2018 10:09 AM
Thanks Steve
Well the log backups are taking place as part of the log shipping process....
--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 26, 2018 at 10:14 am

#2003353
RE: Database in Full recovery mode, with NO logbackups but logshipping setup

caz100 - Friday, August 24, 2018 9:34 AM
Hi
I have encountered an instance in full recovery mode with NO logbackups but logshipping...
--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 26, 2018 at 10:12 am

#2003352
RE: Any way to reduce the execution time for 8mil + rows table with cross join

Cool2018 - Friday, August 24, 2018 8:10 PM
Dear All,
Do you think Clustered columnstored index is suit for my case? I read Internet...
--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 26, 2018 at 9:55 am

#2003349
RE: How to search in database for a specific data... Sometime you are given a screen shot of something and you don't know where it is in the data.

My first step would be to ask the people that created the screen where the data is. From what I've been made to understand, it's not that difficult to couple...
--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 26, 2018 at 9:45 am

#2003348
RE: Prevent duplicates in a table

andycadley - Friday, August 24, 2018 11:03 PM
jcelko212 32090 - Friday, August 24, 2018 12:29 PM
--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 26, 2018 at 9:38 am

#2003345
RE: 'Comedy Limited' with SQL Server

Great article and very appropriate rant, Phil. I look at the tag bloat for both XML and JSON and the relatively poor performance of both, especially when the data being...
--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 26, 2018 at 8:58 am

#2003344
RE: Need to modify the Update statement to include two new tables instead of one table

saptek9 - Sunday, August 26, 2018 4:25 AM
Currently, in existing system i do have following update statement:
Update ProdStg
set unit_cost=case when ci.totcstperacct<ci.cst1 then...
--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 26, 2018 at 8:40 am

#2003343
RE: millions of users hitting our database

p.s. Hopefully, management will also look at themselves and provide more lead time for such large events.
--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 26, 2018 at 8:27 am

#2003340
RE: millions of users hitting our database

coolchaitu - Sunday, August 26, 2018 8:17 AM
Jeff Moden - Sunday, August 26, 2018 8:03 AM
--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 26, 2018 at 8:25 am

#2003339
RE: millions of users hitting our database

coolchaitu - Sunday, August 26, 2018 7:30 AM
Jeff Moden - Sunday, August 26, 2018 7:19 AM
--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 26, 2018 at 8:03 am

#2003337
RE: millions of users hitting our database

coolchaitu - Sunday, August 26, 2018 1:37 AM
Jeff Moden - Saturday, August 25, 2018 8:47 PM
--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 26, 2018 at 7:19 am

#2003335
RE: Are the posted questions getting worse?

No need to pile on... I'm just venting a bit because I see this more and more and not just on this site.
Is it just me or do...
--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 25, 2018 at 9:05 pm

#2003327
RE: millions of users hitting our database

coolchaitu - Friday, August 24, 2018 10:25 PM
Good Morning Experts,
There is a mega sale on a TV for 5 days, starting...
--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 25, 2018 at 8:47 pm

#2003326
RE: PIVOT

TJ_T - Thursday, August 23, 2018 4:00 PM
Hi thanks,
hmmm â€¦ this looks rather complicated. I just need to make column into 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 25, 2018 at 8:22 pm

#2003325

Viewing 15 posts - 11,401 through 11,415 (of 59,095 total)