Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,891 through 25,905 (of 59,102 total)

RE: Granting select to all databases current and future?

lbrady (9/20/2013)
I have a user who needs select permissions to all databases on a server.
From a data security aspect, I'd really want to know why that's necessary. I'd also...
--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)

September 20, 2013 at 10:56 pm

#1652106
RE: Varchar to numeric ???

sqlnaive (9/20/2013)
🙂 No worries Sean. but thanks about the STR functionality. Was playing with it and had fun to know about some things. 🙂
Be a bit leary of the STR()...
--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)

September 20, 2013 at 10:31 pm

#1652105
RE: Are the posted questions getting worse?

CapnHector (9/20/2013)
Jeff Moden (9/20/2013)
hisakimatama (9/20/2013)
*Huff* *Wheeze* I... I did it! I managed to read the entirety of The Thread! That was... Interesting :-D. Been...
--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)

September 20, 2013 at 10:06 pm

#1652104
RE: Are the posted questions getting worse?

Greg Edwards-268690 (9/20/2013)
Jeff Moden (9/20/2013)
Are you good folks saying that any form of SELECT/INTO is bad? If so, why?
I sense a frozen pork chop being readied for launch! ...
--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)

September 20, 2013 at 9:50 pm

#1652101
RE: Are the posted questions getting worse?

wolfkillj (9/20/2013)
The filibustering member stops speaking during debate on the point of order but has to follow all the other rules, including remaining standing.
Sounds like some of the scrums I'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)

September 20, 2013 at 9:20 pm

#1652098
RE: Calculating age

gilbert delarosa (9/20/2013)
But they wouldn't be 1 until after their BDay
or you could just
DECLARE @DOB DATETIME
SET @DOB='01/01/2013'
SELECT FLOOR((DATEDIFF(DD,@DOB,'01/01/2014')+1)/365.25)
Still doesn't work. Last I heard, you gained a year 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)

September 20, 2013 at 5:01 pm

#1652084
RE: Are the posted questions getting worse?

So, could you do the following during a filibuster? Some people have labeled this as "Navy Training". I call it "A Brief History of the Life of 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)

September 20, 2013 at 4:08 pm

#1652075
RE: Calculating age

gilbert delarosa (9/20/2013)
This seems to work
DECLARE @DOB DATETIME
SET @DOB='9/19/2000'
SELECT FLOOR(DATEDIFF(DD,@DOB,GETDATE())/365.25)
Good try but it doesn't work...
DECLARE @DOB DATETIME
SET @DOB='01/01/2013'
SELECT FLOOR(DATEDIFF(DD,@DOB,'01/01/2014')/365.25)
Results:
---------------------------------------
0
(1 row(s) affected)
--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)

September 20, 2013 at 3:55 pm

#1652071
RE: Are the posted questions getting worse?

hisakimatama (9/20/2013)
*Huff* *Wheeze* I... I did it! I managed to read the entirety of The Thread! That was... Interesting :-D. Been lurking around here,...
--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)

September 20, 2013 at 12:47 pm

#1652013
RE: Automate Your Backup and Restore Tasks

Steve Jones - SSC Editor (10/5/2010)
SanjayAttray (10/5/2010)
Why do this task with VB script when you can do the whole process with T-SQL scripts?
Do you somehow think that T-SQL is "better"
Yes......
--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)

September 20, 2013 at 12:37 pm

#1652011
RE: Systems Engineer - is it a good career goal for DBA?

Jeff Atherton (9/20/2013)
I'm going the other way. I've been a windows admin for a long time with some DBA duties on the side. Now I'm working on the T-SQL ninja...
--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)

September 20, 2013 at 12:15 pm

#1652006
RE: Temp tables vs "permanent" temp table vs User Table Type

PiMané (9/20/2013)
Jeff Moden (9/20/2013)
Heh... you asked what the best way to store XML is. I suggested shredding it and storing it in normalized tables. Are you storing 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)

September 20, 2013 at 12:12 pm

#1652003
RE: Temp tables vs "permanent" temp table vs User Table Type

PiMané (9/19/2013)
Jeff Moden (9/19/2013)
PiMané (9/4/2013)
What's the best way to store the XML?
The best way, IMHO, is to shred it on receipt and store it as properly normalized 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)

September 20, 2013 at 7:11 am

#1651906
RE: Shift Column values to the left

eseosaoregie (9/20/2013)
I opted for the multiple update option. It is added to a larger clean up job that will run at night. It ran very quickly and gave the desired...
--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)

September 20, 2013 at 7:05 am

#1651902
RE: Are the posted questions getting worse?

Are you good folks saying that any form of SELECT/INTO is bad? If so, why?
--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)

September 20, 2013 at 7:02 am

#1651900

Viewing 15 posts - 25,891 through 25,905 (of 59,102 total)