Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,666 through 22,680 (of 59,102 total)

RE: Conversion of varchar to datetime

ramana3327 (10/7/2014)
It gave 2005. Sorry wrong place. I will post in the right place
Nah... no need now. Keep it here so that we don't lose any of the suggestions...
--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 7, 2014 at 5:32 pm

#1750806
RE: Help avoiding temp table with string of IDs passed into stored procedure

TheSQLGuru (10/7/2014)
Try your XML method under stress and see how it holds up. Or with lots of rows.
There are some very nice threads here on SSC.com about...
--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 7, 2014 at 5:25 pm

#1750805
RE: Why CTE should begin with semicolon or Go

I'll also add that you should start changing any code you touch for maintenance or any new code to include semi-colons for ALL statements that can take them because MS...
--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 7, 2014 at 9:29 am

#1750629
RE: Work Pattern Calendar Tables

itwhiz (10/5/2014)
Hi,
I need to prove that there is a speed issue with one of our stored procs/functions but to do this I need to create a large static work pattern...
--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 5, 2014 at 11:59 pm

#1750217
RE: Are the posted questions getting worse?

rodjkidd (10/5/2014)
Jeff Moden (10/4/2014)
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...
--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 5, 2014 at 8:03 am

#1750185
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

Viewing 15 posts - 22,666 through 22,680 (of 59,102 total)