Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,466 through 30,480 (of 59,101 total)

RE: Function to set start and end date @variables

schillingt (4/4/2012)
I had already dropped the miliseconds due to this issue. I agree that I should drop the time stamp however even though all our date fields are defined...
--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)

April 4, 2012 at 7:51 pm

#1469264
RE: Function to set start and end date @variables

ColdCoffee (4/4/2012)
True, Jeff. Thats why in my code, i used -3 for milliseconds. OP posted this in 2008 forums, so i think its better to ask him to use DATETIME2..
I'm...
--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)

April 4, 2012 at 7:50 pm

#1469263
RE: Function to set start and end date @variables

schillingt (4/3/2012)
The output from the stored proc [dbo].[rpt_sp_get_date_range] looks like this.
StartDate EndDate
2012-04-01 00:00:00.0002012-04-07 23:59:59.999
Boy, are you in for...
--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)

April 4, 2012 at 6:32 pm

#1469246
RE: query for consecutive alphabets

Zero based wouldn't make a difference here. What may be making the difference is that you're working on a machine with less memory than I am and my Tally...
--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)

April 4, 2012 at 7:11 am

#1468808
RE: query for consecutive alphabets

p.s.
I used a million GUIDs, seemed the easiest way of generating a million random strings:
Great minds think alike. That's what I did, as well, and I apologize for...
--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)

April 4, 2012 at 6:17 am

#1468778
RE: query for consecutive alphabets

Craig,
Does your Tally table have a clustered index on it? If not, that may explain the results you got.
--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)

April 4, 2012 at 6:14 am

#1468776
RE: query for consecutive alphabets

Cadavre (4/3/2012)
You could get the results you want like this: -
SELECT name
FROM yourTable a
CROSS APPLY (SELECT TOP 1 CASE WHEN a.name LIKE strings THEN 1 ELSE 0 END
...
--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)

April 3, 2012 at 11:17 pm

#1468627
RE: Raw Data

Christi Wilson (4/3/2012)
Hi! I hope everyone is doing well.
I have started my own company developing business applications for small businesses in my local area. I am currently in 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)

April 3, 2012 at 7:23 pm

#1468601
RE: Dallas Tornados

yowch! Nasty stuff down there. I agree... hope all you folks down there are ok.
--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)

April 3, 2012 at 7:19 pm

#1468600
RE: The SQLServerCentral.com 3000

Ran across this old article again. 3,000 seems like such a very long time ago. It's no longer a lot of water that's passed under the bridge... they've...
--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)

April 3, 2012 at 6:36 pm

#1468589
RE: Bye Bye to the RAISERROR Function?

Thanks for the "warm fuzzies" and facts on the plight (or lack of, I should say) of RAISERROR especially considering the name of this article. I finally had 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)

April 3, 2012 at 5:47 pm

#1468576
RE: Subtotals in t-sql

You bet. Thank you for the thoughtful feedback. Really appreciate 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)

April 3, 2012 at 11:33 am

#1468379
RE: Bye Bye to the RAISERROR Function?

Steve Jones - SSC Editor (4/3/2012)
Jeff Moden (4/3/2012)
The "advantages" you have for THROW are actually disadvantages for me especially when it comes to THROW having fewer parameters. I really...
--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)

April 3, 2012 at 11:32 am

#1468376
RE: Are the posted questions getting worse?

Evil Kraig F (4/2/2012)
GSquared (4/2/2012)
GilaMonster (4/2/2012)
Evil Kraig F (3/30/2012)
GilaMonster (3/30/2012)
I read the end of that and I am not getting involved...
Initial gut feel - improper transaction management (leaves transactions open)...
--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)

April 3, 2012 at 5:45 am

#1468147
RE: Subtotals in t-sql

Ah... the VIEW might explain it. It's actually being executed twice if you're using it directly in the code I wrote. You'll get much better performance if you...
--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)

April 3, 2012 at 5:39 am

#1468144

Viewing 15 posts - 30,466 through 30,480 (of 59,101 total)