Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,936 through 19,950 (of 59,098 total)

RE: Making Guesses

Everyone I know keeps saying that "Disk space is cheap". I know better but it's still cheaper than having to work within ridiculously small confines on an unknown project....
--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 11, 2015 at 7:36 am

#1818944
RE: script to list all database level permissions in a Database

Perry Whittle (8/6/2015)
This is my script, feel free to use it, I'm constantly updating and improving it
Oddly enough, I just started looking for such a thing. Timing couldn't be...
--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 10, 2015 at 12:36 pm

#1818683
RE: Is there a tool that inventories SQL Server instances?

Perry Whittle (8/10/2015)
MAP is about as useful as a chocolate saucepan.
Heh... I tried MAP about 6 months ago just to see what it was all about. I couldn't think...
--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 10, 2015 at 10:52 am

#1818638
RE: Comparing a column between two tables with a wildcard

j.kalkowski (8/9/2015)
I have a table containing records of criminal convictions. There are over 1M records and the only change is additions to the table on a monthly basis. ...
--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 9, 2015 at 4:48 pm

#1818410
RE: Old brain, new question

You did good! Just wanted to make sure because you're the one that has to support it.
And thank you very much for explaining what it was for. Worthy...
--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 9, 2015 at 4:20 pm

#1818409
RE: Old brain, new question

Thanks for the feedback and glad it worked for you.
Actually, the code was on "one line" to begin with. The method I used is known as a CTE and...
--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 9, 2015 at 12:41 pm

#1818406
RE: Varchar size change

That's a great question and is the subject of many a battle between front-end developers that are supposedly avoiding the evils of "pre-optimization" and DBAs. As with all else...
--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 9, 2015 at 12:31 pm

#1818405
RE: Compatibility Mode causes query not to finish

NP. It IS one of the many reasons why I prefer to not be on the bleeding edge.
--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 9, 2015 at 11:03 am

#1818402
RE: Restricting Sysadmins from adding new sysadmins

Greg Edwards-268690 (8/9/2015)
SQLRNNR (8/8/2015)
Jeff Moden (8/8/2015)
Something like CyberArk is absolutely wonderful for making auditors and soccer Moms happy but it always boils down to the root problem and no software...
--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 9, 2015 at 10:04 am

#1818401
RE: Old brain, new question

No problem and please pardon my manners. I did notice you were new and meant to say "Welcome aboard" and here's a helpful hint but it was getting late...
--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 9, 2015 at 10:00 am

#1818400
RE: What can I do to speed it up? Thanks.

halifaxdal (8/8/2015)
Jeff Moden (8/8/2015)
That answers my questions #2 and #5. Still looking for answers on #1, 3, and 4. Those may also make a difference.
1. Is this 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 8, 2015 at 8:42 pm

#1818380
RE: Old brain, new question

Please see the first link under "Helpful Links" in my signature line below for future posts.
Here's the readily consumable test data for this problem.
--===== Create the test tables and populate...
--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 8, 2015 at 8:37 pm

#1818379
RE: What can I do to speed it up? Thanks.

That answers my questions #2 and #5. Still looking for answers on #1, 3, and 4. Those may also make a difference.
--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 8, 2015 at 7:24 pm

#1818377
RE: Old brain, new question

The location of the new post is http://www.sqlservercentral.com/Forums/Topic1709703-338-1.aspx. Please respond there instead of on this post to help keep any answers together. Thanks, folks.
--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 8, 2015 at 7:02 pm

#1818375
RE: What can I do to speed it up? Thanks.

halifaxdal (8/7/2015)
I just got a table with 16736580 records. Index is created.
A test shows a query like
select * from table where charindex(column, keyword) > 1
costs 14 minutes to return result.
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 8, 2015 at 11:40 am

#1818359

Viewing 15 posts - 19,936 through 19,950 (of 59,098 total)