Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,731 through 11,745 (of 59,099 total)

RE: Variable assignments

David Burrows - Tuesday, July 24, 2018 6:25 AM
Jeff Moden - Tuesday, July 24, 2018 12:01 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)

July 24, 2018 at 8:44 am

#1998796
RE: float error in t-sql scalar function

Thom A - Tuesday, July 24, 2018 2:04 AM
The problem there, however, isn't the decimal type itself, it's the precision 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)

July 24, 2018 at 8:32 am

#1998791
RE: Variable assignments

LongDriver - Monday, July 23, 2018 5:58 PM
To prevent an overflow you can do an exclusive OR instead (apologies for the formatting):
--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)

July 24, 2018 at 12:01 am

#1998717
RE: SSRS need to take dashes from a string

marin88321 - Monday, July 23, 2018 8:50 PM
Hello
I'm newby in SSRS and I am trying to take the dashes from this field...
--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)

July 23, 2018 at 11:53 pm

#1998716
RE: dm_db_index_physical_stats - LIMITED or DETAILED

Leo.Miller - Monday, July 23, 2018 8:59 PM
I'm interested to hear what most DBAs do to evaluate fragmentation using dm_db_index_physical_stats.
Using this web site...
--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)

July 23, 2018 at 11:46 pm

#1998715
RE: float error in t-sql scalar function

Sergiy - Monday, July 23, 2018 7:37 PM
Thom A - Wednesday, July 18, 2018 5:12 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)

July 23, 2018 at 9:22 pm

#1998712
RE: Backup blocked by system SPID

ReamerXXVI - Monday, July 23, 2018 8:00 PM
Thanks for your reply Jeff. I'm no closer to getting to the bottom of this...
--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)

July 23, 2018 at 8:46 pm

#1998711
RE: Need Help to convert DATETIME result into DATE on SQL Server

Sergiy - Monday, July 23, 2018 6:53 PM
Jeff Moden - Wednesday, July 18, 2018 12:11 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)

July 23, 2018 at 8:41 pm

#1998710
RE: Need Help to convert DATETIME result into DATE on SQL Server

Sergiy - Monday, July 23, 2018 3:52 PM
I'm curious as to how this will affect dates prior to 1753 mentioned in history...
--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)

July 23, 2018 at 4:29 pm

#1998700
RE: How much database normalization is enough?

Japie Botma - Monday, July 23, 2018 5:43 AM
I agree Ben. Small systems usually have limited resources on hardware. Joining 6 tables...
--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)

July 23, 2018 at 3:47 pm

#1998696
RE: identify failing ssrs

newbie389 - Monday, July 23, 2018 9:23 AM
hi
we have over 600 ssrs reports in sql 2012 over time some reports started 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)

July 23, 2018 at 1:59 pm

#1998677
RE: Variable assignments

lmalatesta - Monday, July 23, 2018 10:20 AM
Keep in mind that this trick relies on behavior that is not only undocumented 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)

July 23, 2018 at 1:46 pm

#1998674
RE: Retrieving distinct values from two tables in vb.net

JohnPapa - Monday, July 23, 2018 12:03 AM
Thanks regarding your comments for injection.
The column headings are field names.
I include below the 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)

July 23, 2018 at 6:09 am

#1998572
RE: Find the memory consumetion by each database

francesco.mantovani - Sunday, July 22, 2018 9:49 PM
Hello @jeff, I was thinking this was a good idea for monitoring SQL Server on...
--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)

July 23, 2018 at 5:42 am

#1998568
RE: Find the memory consumetion by each database

p.s. I'm not sure why someone would write a PoSh script for this when it's so easy to do in T-SQL and requires no special handling.
--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)

July 22, 2018 at 9:18 pm

#1998543

Viewing 15 posts - 11,731 through 11,745 (of 59,099 total)