Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,746 through 11,760 (of 59,102 total)

RE: Retrieving distinct values from two tables in vb.net

JohnPapa - Monday, July 23, 2018 12:03 AM
Thanks regarding your comments for injection.
The column headings are field names.
I include below 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)

July 23, 2018 at 6:09 am

#1998572
RE: Find the memory consumetion by each database

francesco.mantovani - Sunday, July 22, 2018 9:49 PM
Hello @jeff, I was thinking this was a good idea for monitoring SQL Server 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)

July 23, 2018 at 5:42 am

#1998568
RE: Find the memory consumetion by each database

p.s. I'm not sure why someone would write a PoSh script for this when it's so easy to do in T-SQL and requires no special handling.
--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)

July 22, 2018 at 9:18 pm

#1998543
RE: Find the memory consumetion by each database

I respect anyone that will take the time to publish knowledge and, no... this isn't a slam. Just some helpful hints for your next post.
I think your script...
--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)

July 22, 2018 at 9:17 pm

#1998542
RE: How to GROUP BY XML column

lexcerm - Thursday, July 19, 2018 2:11 AM
Hi Jeff,
Thank you for replying. I have actually researched some of your excellent work, but...
--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)

July 22, 2018 at 1:54 pm

#1998539
RE: how can i get the top 3, after i count the column ?

andycadley - Sunday, July 22, 2018 1:09 AM
Jeff Moden - Tuesday, July 17, 2018 6:47 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)

July 22, 2018 at 1:21 pm

#1998537
RE: Retrieving distinct values from two tables in vb.net

I guess that first and foremost, I need to advise you that building concatenated SQL like that leaves you wide open for SQL Injection. Consider using parameterization instead.
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)

July 22, 2018 at 1:19 pm

#1998536
RE: Recommended Implementation

I also missed Andy's post above... does his method solve the problem for you?
--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)

July 22, 2018 at 8:19 am

#1998533
RE: Recommended Implementation

NikosV - Sunday, July 22, 2018 7:36 AM
Here you go. https://stackoverflow.com/questions/51464758/retrieve-show-columns-based-on-user-inputHad to go to Stack Overflow. Posting on here via mobile...
--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)

July 22, 2018 at 8:17 am

#1998531
RE: Flat File csv with double quotes

andycadley - Sunday, July 22, 2018 7:33 AM
Jeff Moden - Sunday, July 22, 2018 7:18 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)

July 22, 2018 at 7:55 am

#1998529
RE: Backup blocked by system SPID

I have to admit that I've never seen such a thing before. I'm certainly not an expert here but the only way that I could see a CHECKPOINT causing this...
--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)

July 22, 2018 at 7:35 am

#1998527
RE: Variable assignments

Clever! Hopefully both values aren't more than 50% of the max for the given datatype.
--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)

July 22, 2018 at 7:25 am

#1998525
RE: Recommended Implementation

NikosV - Sunday, July 22, 2018 7:01 AM
Hi. I was having some difficulties with this site so i posted on stack overflow....
--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)

July 22, 2018 at 7:20 am

#1998524
RE: Flat File csv with double quotes

andycadley - Sunday, July 22, 2018 7:07 AM
Jeff Moden - Sunday, July 22, 2018 6:06 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)

July 22, 2018 at 7:18 am

#1998523
RE: Flat File csv with double quotes

Jeff Moden - Tuesday, July 17, 2018 1:26 PM
Chris Hurlbut - Tuesday, July 17, 2018 1:18 PM
--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)

July 22, 2018 at 6:41 am

#1998518

Viewing 15 posts - 11,746 through 11,760 (of 59,102 total)