Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,641 through 11,655 (of 59,102 total)

RE: A "safe" replacement for xp_CmdShell - for test purposes

glen205 - Monday, August 6, 2018 3:34 AM
Hi,
I'm currently reverse-engineering a system which makes use of xp_cmdshell to move files around 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)

August 6, 2018 at 6:14 am

#2000397
RE: Are the posted questions getting worse?

Thom A - Monday, August 6, 2018 2:29 AM
Are you saying you don't use SSMS and stick to SOS or SQLCMD...
--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)

August 6, 2018 at 5:48 am

#2000394
RE: Will Terminators Be Required?

scoan - Monday, August 6, 2018 1:53 AM
F%$#)ing semicolons
Heh... even though I use them all the time and very consistently so I...
--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)

August 6, 2018 at 5:34 am

#2000391
RE: SQL Authentication Via AD Groups Part II: Who has what access?

KenpoDBA - Thursday, February 18, 2016 7:11 AM
Yeah, I make a product that does this and also expands all the subgroups as...
--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)

August 5, 2018 at 9:09 pm

#2000356
RE: Cursor object running when @@FETCHSTATUS 0

Apologies... I apparently hit the go button without completing the thought. I absolutely agree that it doesn't matter how fast something is if it doesn't work or produces incorrect answers......
--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)

August 5, 2018 at 4:18 pm

#2000351
RE: Joining dates to calculate payment month dates

jcelko212 32090 - Sunday, August 5, 2018 3:52 PM
Secondly, the only display format allowed in ANSI/ISO standard SQL is based 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)

August 5, 2018 at 4:06 pm

#2000350
RE: Transaction Log when FIXED size, does it hang?

If you're deleting more than about a third of the data, it would be much better to copy what you want to keep to another table that's been created 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)

August 5, 2018 at 4:03 pm

#2000349
RE: Finding a String Anywhere in Another String

Eirikur Eiriksson - Sunday, August 5, 2018 8:48 AM
Jeff Moden - Sunday, August 5, 2018 8:11 AM
--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)

August 5, 2018 at 11:31 am

#2000342
RE: Cursor object running when @@FETCHSTATUS 0

Eirikur Eiriksson - Sunday, August 5, 2018 9:11 AM
Jeff Moden - Sunday, August 5, 2018 8:22 AM
--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)

August 5, 2018 at 10:37 am

#2000338
RE: Why QUOTENAME is important

Great article on QUOTENAME, Thom, especially with the considerations given for SQL Injection, which is still rampant in the industry.
Andy also brings up a great point. A lot...
--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)

August 5, 2018 at 8:53 am

#2000329
RE: Cursor object running when @@FETCHSTATUS 0

p.s. Andy posted while I was typing... that's the basic idea of what I'm talking 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)

August 5, 2018 at 8:22 am

#2000326
RE: Cursor object running when @@FETCHSTATUS 0

Arsh - Sunday, August 5, 2018 3:16 AM
Dear All,
I've attached the SP in this file for reference in case the code...
--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)

August 5, 2018 at 8:19 am

#2000325
RE: Finding a String Anywhere in Another String

Eirikur Eiriksson - Sunday, August 5, 2018 7:12 AM
Jeff Moden - Sunday, August 5, 2018 5:39 AM
--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)

August 5, 2018 at 8:11 am

#2000324
RE: Finding a String Anywhere in Another String

Eirikur Eiriksson - Sunday, August 5, 2018 3:40 AM
The Azure S tier instances are very low spec and are no match 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)

August 5, 2018 at 5:39 am

#2000317
RE: Unused space; shrink or not shrink

rpeters76 - Thursday, August 2, 2018 11:54 PM
Thank you all!!
With the log file, I don't have an issue because we use 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)

August 4, 2018 at 2:05 pm

#2000286

Viewing 15 posts - 11,641 through 11,655 (of 59,102 total)