Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,056 through 23,070 (of 59,102 total)

RE: Are the posted questions getting worse?

Jeff Moden (7/30/2014)
Steve Jones - SSC Editor (7/30/2014)
Lynn Pettis (7/30/2014)
It should be noted as well, that sometimes people come to SSC and ask question(s) and then actually get upset when...
--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 30, 2014 at 6:27 pm

#1733882
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (7/30/2014)
Lynn Pettis (7/30/2014)
It should be noted as well, that sometimes people come to SSC and ask question(s) and then actually get upset when we try...
--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 30, 2014 at 6:26 pm

#1733881
RE: Cross Join Help

dwilliscp (7/30/2014)
Do you have a good link for "Triangular" join, never heard of it.
The author 😀 of the article at the following link has put it pretty simply although it's...
--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 30, 2014 at 6:09 pm

#1733878
RE: Do you usually go to agencies?

Lynn Pettis (7/30/2014)
SQL Guy 1 (7/30/2014)
For instance, when you hear or read ASP what comes to your mind?
Active Service Pages
Application Service Provider
Also googled:
Appalachia Service Project
Association of 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)

July 30, 2014 at 12:46 pm

#1733763
RE: Are the posted questions getting worse?

Although I don't believe monitors should shut down the proverbial "teach a man to fish" type of responses, there are a large number of times that even a totally undocumented/no-writeup-included...
--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 30, 2014 at 12:31 pm

#1733755
RE: Extracting VarBinary(MAX) column to Flat File - Facing Issue.

windows_mss (7/30/2014)
Thanks Guys for your guidance...
I have overcomes this problem using XQuery functionality.
Any chance of you posting the code/package you ended up with?
--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 30, 2014 at 11:54 am

#1733739
RE: Cross Join Help

500*500 is only a quarter million row Cross Join and would probably take less than a quarter second to materialize and just a second or two to insert into an...
--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 30, 2014 at 11:36 am

#1733730
RE: Tables on seperate filegroups.

SQLRNNR (7/30/2014)
I am in favor of separating the large fact tables into their own filegroups - based on better data and analysis.
I don't necessarily think that the fact tables should...
--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 30, 2014 at 8:38 am

#1733632
RE: How to Reduce the Table Size...

I believe that one form of "compression" is being overlooked and it's available in all editions of SQL Server... if the Clustered Index has no temporal-like key to match thee...
--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 30, 2014 at 8:34 am

#1733628
RE: Disable Unicode output

michael_alawneh (7/28/2014)
I am running SQL Server 2012. I have been producing files as output for the Unix folks at work. We are running into an issue with what appears 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)

July 29, 2014 at 8:09 pm

#1733441
RE: quick sp_whoisactive question?

fkeuris (7/29/2014)
If the indexes are created and/or it is still that high amount of reads, it could also meant that the Statistics is out of date, so the optimizer is...
--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 29, 2014 at 7:57 pm

#1733439
RE: Does anyone know of a way to get the machine's processor name from T-SQL?

Shawn Melton (7/29/2014)
Now, xp_cmdshell is not bad and don't let anyone tell you it is. I used to think it was since supporting military as a contractor they frowned upon...
--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 29, 2014 at 7:02 pm

#1733432
RE: date a week

amadeu_j (7/29/2014)
need date for weeks, beginning the week and end of week format. ie for week 1 week 2 week ... 52. how do I?
What day of the week do...
--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 29, 2014 at 6:14 pm

#1733425
RE: Restore database without backup history in msdb

Hema kumar-337490 (7/29/2014)
Power shall is the best option to traverse the folder and generate the scripts.
It's "PowerShell" and so far as it being the "best option", I'll say "It...
--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 29, 2014 at 5:57 pm

#1733422
RE: Cocktail Recipe Database Schema - Tables Question - Normalization

Sean Lange (7/29/2014)
Actually normalization (more tables) causes slower performance.
"It Depends". 😉
If you have de-normalized table that looks like a spreadsheet with date columns in it, queries can be both difficult...
--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 29, 2014 at 5:54 pm

#1733421

Viewing 15 posts - 23,056 through 23,070 (of 59,102 total)