Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,291 through 22,305 (of 59,098 total)

RE: Convert Integer to Time

craig.bobchin (12/3/2014)
Thanks that worked. How can I concatenate this with a date field. neither '&' nor '+' seem to work.
Is the date "field" an Integer, as well? If...
--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)

December 3, 2014 at 8:53 pm

#1762575
RE: Please vote for the "built in Tally Table" function.

CELKO (12/3/2014)
But SQL also has the goal of orthogonality and that means re-use of existing syntax constructs when possible. This table is not a function; it is a set, not...
--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)

December 3, 2014 at 8:23 pm

#1762570
RE: Select rows with AFTER INSERT trigger?

simflex-897410 (12/3/2014)
We have a vendor app that can't be modified.
However, we are allowed to manipulated what they call custom fields.
These custom fields are literally called field1, field2... up to filed5.
Right...
--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)

December 3, 2014 at 5:40 pm

#1762547
RE: Convert Integer to Time

craig.bobchin (12/3/2014)
Hi all,
I've got a column that holds a time value in Integer form as a number from midnight (IE military time) with no leading 0s or colons.
0 = 00:00
30...
--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)

December 3, 2014 at 5:33 pm

#1762546
RE: Last 30 days aggregate query

clayman (12/3/2014)
Thanks, figured it out. The second solution seems to run ~6-7 times faster.
Do you have the index that I recommended?
--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)

December 3, 2014 at 5:08 pm

#1762544
RE: xp_cmdshell issues

IO got lucky... or maybe my Yabingooglewho has gotten a lot better and I found it on the first shot.
http://www.sommarskog.se/grantperm.html
--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)

December 3, 2014 at 5:05 pm

#1762542
RE: xp_cmdshell issues

schleep (12/3/2014)
djj provided the link above. I'm looking into it now...
That's not one of Erland Sommarskogs articles, which I highly recommend.
I'm looking for his stuff on the subject now.
--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)

December 3, 2014 at 5:03 pm

#1762541
RE: xp_cmdshell issues

Emil Bialobrzeski (12/3/2014)
schleep (12/3/2014)
If you give someone ability to impersonate sa he would be able to execute any piece of scrip as sa
Exec 'drop table x' as login = 'sa'
Which...
--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)

December 3, 2014 at 5:01 pm

#1762540
RE: Please vote for the "built in Tally Table" function.

Probably not, Joe. There are already a whole bunch of workarounds that are as fast as or faster and certainly easier to use than a SEQUENCE, if I understand...
--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)

December 3, 2014 at 4:59 pm

#1762539
RE: xp_cmdshell issues

schleep (12/3/2014)
So, set the sa account to Disabled, but change db owner to sa (or is "SA" referring to something else?)? Counter-intuitive is right!
Yes. The owner of the database...
--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)

December 3, 2014 at 8:46 am

#1762417
RE: How to get DATETIME number?

CELKO (12/2/2014)
It has nothing to do with the physical storage like your silly IDENTITY. A file needs a unique physical storage locator, like a record number.
In SQL Server, 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)

December 3, 2014 at 8:17 am

#1762404
RE: xp_cmdshell issues

schleep (12/3/2014)
Hi Jeff,
To be clear, it's not her account that has privs on xp_cmdshell. And she is a trusted user.
Moreover, the sproc she's executing that's calling xp_cmdshell take no...
--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)

December 3, 2014 at 8:00 am

#1762398
RE: T-SQL Development Standards

MMartin1 (12/2/2014)
DonlSimpson (12/2/2014)
Jeff Moden (10/25/2008)
As soon as something needs to "go in in a hurry", all notions of standards and well intended code reviews will go by the wayside.
+1
You may...
--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)

December 2, 2014 at 10:39 pm

#1762267
RE: xp_cmdshell issues

I don't have time to elaborate right now and will try to do so tonight but giving an individual proxy privs to execute xp_CmdShell directly is one of the biggest...
--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)

December 2, 2014 at 2:31 pm

#1762231
RE: if we shrink log file daily after tlog backup ...will there any issue

dastagiri16 (12/2/2014)
if we shrink log file daily after tlog backup ...will there any issue
It's a total waste of time because it regrows every day. If you want it to...
--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)

December 2, 2014 at 8:43 am

#1762117

Viewing 15 posts - 22,291 through 22,305 (of 59,098 total)