Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,136 through 9,150 (of 59,067 total)

Reply To: I Need a Good App Development Company to work with

The OP is just spamming. It's a BS request to try to get past the SPAM filters. I hate these people and won't do business with any company advertised by...
--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)

June 14, 2019 at 10:33 pm

#3654012
Reply To: Partial Backups excluding a read/write filegroup?

Totally agreed and thanks for the the feedback, Jonathan. I also do the "partial backups" to exclude Read_Only file groups, sometimes in concert with having the large table in 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)

June 14, 2019 at 1:24 pm

#3653807
Reply To: LongPrint

Henrik Staun Poulsen wrote:
hi Jeff, That is going to be useful, at least for me. But I could not get it to work on SQL Server 2008 R2 (not that it 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)

June 14, 2019 at 1:19 pm

#3653806
Reply To: Calculate last friday date with timestamp ssis

dallas13 wrote:
Thanks Sreedhar... Ur expression works but the variable has datetime datatype so it converts it to 6/7/2019 5:00:00 PM format rather than 2019-06-07 17:00:00.000. Anyway Thanks for all ur...
--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)

June 14, 2019 at 1:13 pm

#3653802
Reply To: Calculate last friday date with timestamp ssis
v_sreedhar wrote:
```
-- SV: For understanding getdate() and things you need
select SYSDATETIME() as sysdatetime_FYI
, getdate() as getdate_FYI
, cast(getdate() as time) as getdate_TimeOnly
, CONVERT(varchar(15), cast(getdate() as time),100) as getdate_TimeOnly_AMPM
,...
```
--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)
June 14, 2019 at 3:33 am

#3653633
Reply To: LongPrint

I used to display long strings in a similar matter and even wrote a similar article (didn't know Timothy had already written one back then). A fellow by the name...
--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)

June 14, 2019 at 2:56 am

#3653628
Reply To: Partial Backups excluding a read/write filegroup?

I've done this but not the way you want. It's super simple, though. Create another database, move your large table to that, and create a synonym in the original database...
--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)

June 14, 2019 at 2:50 am

#3653626
Reply To: If possible need a more elegant solution to a current brute force view

randyetheridge wrote:
ok thanks for all the posts. First this is a view, and I now know declare statements do not work in a view so I updated the statement 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)

June 13, 2019 at 5:44 pm

#3653382
Reply To: formatting T-SQL

Eirikur Eiriksson wrote:
I generally use the SQLinForm plugin for Notepad++, works fine for large code sets and most SQL flavors. 😎
With some settings changes, that actually does a fairly good...
--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)

June 13, 2019 at 5:40 pm

#3653379
Reply To: LOOP vs CTE vs NUMS function

rVadim wrote:
Why not just create a permanent Tally table? It's probably be useful in other situations. Just wondering...
I actually have both a Tally table and an iTFV that works like...
--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)

June 13, 2019 at 3:42 pm

#3653302
Reply To: LOOP vs CTE vs NUMS function

Jeff Moden wrote:
Mauricio_ wrote:
Function MCS_ClarionDateToSQL is just a scalar function: Do you think GetNums is wrong? Thanks for your help!
Yes... it's partially incorrect. It has a real ORDER BY in...
--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)

June 13, 2019 at 3:09 pm

#3653288
Reply To: LOOP vs CTE vs NUMS function

Mauricio_ wrote:
Function MCS_ClarionDateToSQL is just a scalar function:
Do you think GetNums is wrong? Thanks for your help!
Yes... it's partially incorrect. It has a real ORDER BY in it. Since 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)

June 13, 2019 at 3:06 pm

#3653285
Reply To: formatting T-SQL

David Burrows wrote:
Jeff Moden wrote:
IIRC, it was David Poole that said "If you're the first person people come to with database problems rather than the last, you might be an exceptional DBA".
...
--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)

June 13, 2019 at 2:30 pm

#3653266
Reply To: formatting T-SQL

jonas.gunnarsson 52434 wrote:
I have used Poor Man's T-SQL Formatter, in different editors, works nicely. Now I mostly use SQL Prompt, from Toolbelt in SSMS. The SQL Prompt Core,...
--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)

June 13, 2019 at 1:59 pm

#3653253
Reply To: LOOP vs CTE vs NUMS function

Mauricio_ wrote:
Thanks for your answer, Jeff. I've already solved the problem.
If you ended up using some other than a "GetNums" or other "Tally-like" function, you still have a problem, provided...
--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)

June 13, 2019 at 1:44 pm

#3653244

Viewing 15 posts - 9,136 through 9,150 (of 59,067 total)