Jeff Moden

Forum Replies Created

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

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
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 1:18 pm

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

subramaniam.chandrasekar - Monday, December 18, 2017 9:30 PM
Lynn Pettis - Monday, December 18, 2017 10:17 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 8:31 am

#1972704
RE: bcp changing high ascii values

Stephen Grimshaw - Tuesday, December 19, 2017 2:39 AM
Thank you very much. That seems to do the trick.
Now that I have...
--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 6:31 am

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

dave.convery@red-gate.com - Tuesday, December 19, 2017 2:52 AM
Job alerts are controlled by a third-party company, so there's no button I can press...
--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 6:29 am

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

Perry Whittle - Tuesday, December 19, 2017 4:05 AM
Jeff Moden - Monday, December 18, 2017 6:57 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 6:25 am

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

kevaburg - Monday, December 18, 2017 8:00 AM
We are trying to troubleshoot a problem that seems to be the result of too...
--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 6:13 am

#1972666

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