Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,636 through 22,650 (of 59,067 total)

RE: The Next Five Years

To be honest and despite the best intentions of people doing such things, I'm afraid... very afraid.
Look at what went on just this last year. How many companies data...
--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)

October 4, 2014 at 11:30 pm

#1750170
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (10/4/2014)
Jeff Moden (10/3/2014)
I'm in Pittsburgh for SQL Saturday 315 and I just got a PM from "Luke L" (one of the older members of SQL...
--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)

October 4, 2014 at 10:10 pm

#1750166
RE: Are the posted questions getting worse?

rodjkidd (10/4/2014)
So in Utrecht, for SQL Sat Holland.
Early start, have coffee, seen some familiar faces, so going well so far!
Any one got a heckle for Grant? 🙂
Jeff talking of wanting...
--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)

October 4, 2014 at 10:08 pm

#1750165
RE: Conversion of varchar to datetime

Probably not. And, you don't usually need to use CONVERT to cast a VARCHAR to a DATETIme when you're using things like DATEDIFF.
What you do need to do, though,...
--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)

October 3, 2014 at 10:32 pm

#1750119
RE: fast_forward cursors are read only but are they insensitive?

gyerena (10/2/2014)
Hello,
I have this doubt. I've found different answers for this question in the web. A fast_forward cursor is read only by definition, meaning the rows can't 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)

October 3, 2014 at 9:49 pm

#1750115
RE: What's the right way to "test" a SQL Service Pack?

Not everyone can afford the luxury of multiple boxes even if they're VM but I keep a Dev, Staging, and Prod systems up and running at all times. My...
--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)

October 3, 2014 at 9:46 pm

#1750114
RE: Row limits

Steve Jones - SSC Editor (10/3/2014)
Jeff Moden (10/3/2014)
Heh... the correct answer isn't actually listed. Answer "D" should be "During the mandatory peer review, you get a trip to 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)

October 3, 2014 at 9:12 pm

#1750113
RE: Row limits

stephen.long.1 (10/3/2014)
Steve, thanks for the easy question to end the week. I prefer TOP for my queries because its effects don't persist, but several of my peers use SET ROWCOUNT.
Jeff,...
--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)

October 3, 2014 at 9:10 pm

#1750112
RE: Are the posted questions getting worse?

I'm in Pittsburgh for SQL Saturday 315 and I just got a PM from "Luke L" (one of the older members of SQL Server Central that's been laying low lately)...
--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)

October 3, 2014 at 8:55 pm

#1750111
RE: Row limits

Heh... the correct answer isn't actually listed. Answer "D" should be "During the mandatory peer review, you get a trip to the woodshed for a porkchop dinner for writing...
--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)

October 3, 2014 at 7:43 am

#1749983
RE: Login Trigger Causing Deadlocks

Ok.... I've studied your code and tables a bit. Let's peel one potato at a time...
First, I see no need for the explicit transaction. Getting rid of that...
--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)

October 3, 2014 at 12:24 am

#1749872
RE: Login Trigger Causing Deadlocks

Stamey (10/2/2014)
Jeff,
In a perfect world this never would have happened. In my world, ruled by management, I can only be as heavy-handed as they will allow me. My first suggestion...
--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)

October 2, 2014 at 10:45 pm

#1749870
RE: Remove non alpha chars from a column

dwain.c (10/2/2014)
DonlSimpson (10/2/2014)
Maybe I'm missing something here, but this is simple and fast:
declare @t varchar(5000) = 'RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row." This-divided-by,that|&/multiplied\by(100)give*you,%;<percent>.'
declare @s-2...
--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)

October 2, 2014 at 10:37 pm

#1749869
RE: Table creation policies. Is this silly or is it just me?

Thanks for the feedback, Tom. And, yeah... I wish more managers "got it".
--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)

October 2, 2014 at 10:28 pm

#1749868
RE: db_owner or not

You bet. Thank you for the feedback. They should be able to do everything they need to with those privs.
--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)

October 2, 2014 at 9:55 am

#1749726

Viewing 15 posts - 22,636 through 22,650 (of 59,067 total)