Jeff Moden

Forum Replies Created

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

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
RE: Flat File csv with double quotes

@ gothaimviii ,
In my curious mind, I'd like to know if you've solved this problem and, if so, what the issue...
--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:16 am

#1998515
RE: Flat File csv with double quotes

Chrissy321 - Wednesday, July 18, 2018 4:13 PM
See this http://sqlblog.com/blogs/jamie_thomson/archive/2010/11/25/sql-server-2008-sp1-cu-6-includes-small-changes-to-dtsx-files.aspx
I distantly recall running into this. I think if you view the properties...
--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:14 am

#1998514
RE: Flat File csv with double quotes

andycadley - Sunday, July 22, 2018 3:33 AM
Powershell can be quite handy for this kind of thing, it can be as simple...
--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:06 am

#1998513

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