Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,351 through 13,365 (of 59,101 total)

RE: Graph DB edge tables

I'll admit that it's a totally different take on the answer to this but, like many things, I find that the built in functionality is just totally bloated and would...
--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)

December 21, 2017 at 9:24 am

#1973111
RE: Help with aggregate function

ger_serrano - Wednesday, December 20, 2017 7:34 AM
Awesome Jeff!!. Thanks a lot. I think the following query is also rdbms agnostic:
with newtab...
--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)

December 21, 2017 at 7:53 am

#1973086
RE: Ola's maintenance solution taking too long on VLDB's

Ah... almost forgot the most important part...
If you have indexes that have a FILL FACTOR of 0 or 100 and the average percent of page fullness decreases and...
--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)

December 20, 2017 at 9:49 am

#1972941
RE: Ola's maintenance solution taking too long on VLDB's

ffarouqi - Tuesday, December 19, 2017 10:10 AM
Is there a way I can cut down the run time and still complete 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)

December 20, 2017 at 9:35 am

#1972935
RE: SQL 2012 - Interview Questions (Sample)

Grant Fritchey - Wednesday, December 20, 2017 5:23 AM
Jeff Moden - Tuesday, December 19, 2017 1:49 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)

December 20, 2017 at 9:14 am

#1972925
RE: Restore full backup at first and restore diff backup later, can I?

Perry Whittle - Wednesday, December 20, 2017 5:08 AM
Jeff Moden - Tuesday, December 19, 2017 6:25 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)

December 20, 2017 at 8:56 am

#1972919
RE: Executing HUGE scripts with SQLCMD

v.bartosh - Wednesday, December 20, 2017 3:15 AM
Jeff Moden - Tuesday, December 19, 2017 9:32 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)

December 20, 2017 at 8:48 am

#1972914
RE: Difference between dates displayed in days, hours, minutes and seconds

ScottPletcher - Tuesday, December 19, 2017 8:28 AM
Below is alternative method that's closer to the original technique (for good or ill). Btw,...
--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)

December 19, 2017 at 9:56 pm

#1972837
RE: Executing HUGE scripts with SQLCMD

v.bartosh - Tuesday, December 19, 2017 2:15 AM
We've got a system which generates an SQL script to be executed against some test...
--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)

December 19, 2017 at 9:32 pm

#1972836
RE: Please get rid of this constant, useless job alert!!!!!!!

dave.convery@red-gate.com - Tuesday, December 19, 2017 10:35 AM
Re: the forum changes, we had hoped to work on the upgrade in November, 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)

December 19, 2017 at 9:12 pm

#1972835
RE: To Index a Computed Column...

The "Deterministic" rules are pretty nasty when it comes to CONVERT and implicit converts. That's one of the many reasons why dates represented as integers are so frowned upon. Here...
--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)

December 19, 2017 at 8:20 pm

#1972832
RE: HOw to get Automatic Email notification for High CPU Utilization >80 % with the query which is causing the high CPU usage

Ivan Mohapatra - Wednesday, February 13, 2013 12:22 AM
thanks look like i get what i was looking for........ will post 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)

December 19, 2017 at 4:44 pm

#1972825
RE: How many workers can I use and how many are active?

kevaburg - Tuesday, December 19, 2017 6:54 AM
Jeff Moden - Tuesday, December 19, 2017 6:13 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)

December 19, 2017 at 2:09 pm

#1972802
RE: SQL 2012 - Interview Questions (Sample)

Lynn Pettis - Tuesday, December 19, 2017 10:20 AM
Jeff Moden - Tuesday, December 19, 2017 8:31 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)

December 19, 2017 at 1:49 pm

#1972793
RE: Is there any obvious performance difference between updating 1 column in a 4 column wide table vs 1 columns in a 1000 column wide table ?

xsevensinzx - Tuesday, December 19, 2017 8:30 AM
Jeff Moden - Monday, December 18, 2017 11:09 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)

December 19, 2017 at 1:46 pm

#1972792

Viewing 15 posts - 13,351 through 13,365 (of 59,101 total)