Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,086 through 32,100 (of 59,099 total)

RE: Isthere any function in T-SQL to get day of week using?

ulfemsoy (10/12/2011)
If you only want to get the day index, you should check the following description:
MS SQL: Day of Week
You don't need a UDF for this...
SELECT (DATEDIFF(dd,'17530101',GETDATE())-1) %7
--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 31, 2011 at 10:05 pm

#1401410
RE: Isthere any function in T-SQL to get day of week using?

kpao (4/1/2006)
I've found that there is a function called "trftime" in Sqlite. However, I cannot find any function like this in T-SQL. Is there any function to do this?
You 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)

October 31, 2011 at 10:02 pm

#1401409
RE: What minimum rights do you need?

drew.georgopulos (10/25/2011)
We have a programmer who has been experimenting with reporting services, but making this individual a server administrator is creating great anxiety among the database admins.
Don't do 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 31, 2011 at 9:58 pm

#1401408
RE: Gold in the Execution Plan hills

GREAT editorial, Tony. People just don't know what they miss by not going to PASS or other SQL Server events. Lots of good technical info, especially for an...
--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 31, 2011 at 9:55 pm

#1401407
RE: Removing Redundant Records from Table

What I'm even more interested in is that the data appears to be a "hierarchical path" structure. It also appears to be incorrect. Lines 7 and 14 should...
--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 31, 2011 at 9:49 pm

#1401406
RE: Happy Halloween 2011

I just saw the picture for the article and it looks like even the pumpkin got dressed up for Halloween... it looks like one of Steve's Hawaiian shirts. 😛
Ok... OLD...
--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 31, 2011 at 9:27 pm

#1401404
RE: Happy Halloween 2011

Alan Vogan (10/31/2011)
Going as a computer geek is good, but add some reality...go as a Zombie Computer Geek! Extra bloodshot eyes, white rotting flesh, coffee stained teeth....oooooooo!
Hey HEY! C'mon......
--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 31, 2011 at 9:12 pm

#1401403
RE: Maximum flow from continuous flow rate

Brian Ki (10/31/2011)
that doesn't sound quite right, though I'm not sure. There doesn't really need to be any parameters. If I assume a table is filled with 86,400 records (1...
--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 31, 2011 at 9:07 pm

#1401402
RE: Need Charindex to Pick Up the Second Instance

sdownen05 (10/31/2011)
You are right, Lynn. I didn't give you enough sample data. However, I have figured out a way around it. Thank you for your help.
Steve
Two way street here, Steve....
--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 31, 2011 at 8:56 pm

#1401401
RE: Knowledge capicity of a DBA

RuanK (10/31/2011)
...but the thing is, the more I learn, the more I realise what I don't know and this actually scares me.
You, good Sir, have just explained one of 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 31, 2011 at 8:53 pm

#1401400
RE: Subquery in quirky update

Evil Kraig F (10/31/2011)
Correllated subqueries back to itself however... that's pretty much never going to work. Between having to do dirty reads, needing to keep row control, and a...
--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 31, 2011 at 8:48 pm

#1401398
RE: Help with performance - aggregating a lot of data

Evil Kraig F (10/31/2011)
That's what I thought you meant at first, but I can't see how combining those into this will give performance gains when you still end up working...
--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 31, 2011 at 8:38 pm

#1401395
RE: Are the posted questions getting worse?

Evil Kraig F (10/31/2011)
You guys are looking at a race.;-)
Nah... no race here. I've just been a regular poster for 7 or 8 years. If it's 8 years,...
--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 31, 2011 at 7:38 pm

#1401389
RE: Help with performance - aggregating a lot of data

Evil Kraig F (10/31/2011)
Jeff Moden (10/31/2011)
Kiara (10/31/2011)
Jeff Moden (10/29/2011)
Kiara,
Any interest in a bit of table redesign that will greatly improve performance for this particular query? One that will give...
--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 31, 2011 at 7:28 pm

#1401386
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

gcresse (10/31/2011)
Am I expecting too much?
I believe so. What you're trying to do is actually breaking Rule 5 which stipulates "No Joins". The Sub-queries you're running are correlated...
--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 31, 2011 at 7:22 pm

#1401383

Viewing 15 posts - 32,086 through 32,100 (of 59,099 total)