Jeff Moden

Forum Replies Created

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

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
RE: hashbytes

First things first... stop using MD5. Seriously... stop using it NOW and pretend it never existed. Its old, it's slow, it's fairly easy for hackers to break especially if they're...
--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 1:53 pm

#2000285
RE: Bulk loads versus Bulk inserts (Oracle DB as data source)

Which one is faster??? Test it and find out because the answer is and always will be, "It Depends". 😉
--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 12:07 pm

#2000280
RE: Is SQL Server Mature?

99zardoz - Friday, August 3, 2018 10:11 AM
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 4, 2018 at 12:02 pm

#2000279

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