Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,911 through 8,925 (of 59,091 total)

Reply To: How does SQL determine which column a table level check constraint is applied to

p.s. Two of the better articles in this world on what APPLY does can be found on Paul White's "author" page. He has some other helpful articles there, as well. ...
--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 5, 2019 at 12:10 am

#3668684
Reply To: How does SQL determine which column a table level check constraint is applied to

michael.leach2015 wrote:
1. In the second block of code, the SELECT statement has a column called value. But the table that was created in the first block of code doesn’t have...
--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 4, 2019 at 11:43 pm

#3668675
Reply To: Is It Worth Writing Unit Tests?

Excellent post, Steve. What we need now is someone that's an expert in QA or an expert system designer to provide people that write requirements with knowledge and techniques the...
--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 4, 2019 at 10:09 pm

#3668663
Reply To: Stored procedure getting results from views that are joining several tables

A much better idea is to find out why the batch job is taking 7 hours. Is it actually because this stored procedure taking 7 seconds? While that may certainly...
--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 2, 2019 at 7:52 pm

#3668368
Reply To: Convert Rows into Columns

This is a duplicate post. Please use the following link to get to the duplicate and the answers. No posts on this link, please. It will only dilute the information...
--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 2, 2019 at 5:16 pm

#3668326
Reply To: Convert Rows into Columns

Jonathan AC Roberts wrote:
Sorry, I didn't read which forum it was from.
I end up having that same problem. I did the very same thing yesterday.
--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 2, 2019 at 3:48 pm

#3668303
Reply To: Convert Rows into Columns

Unfortunately, this is a 2008 forum and so the IIF functionality will need to be converted to CASE statements if you're truly using 2008.

--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 2, 2019 at 2:39 pm

#3668291
Reply To: Convert Rows into Columns

lokesh wrote:
Thanks Jonathan for the query... 🙂
Output data is coming correctly but is it possible to get output data into corresponding pivoted columns.
I attached sample data in excel for better...
--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 2, 2019 at 2:27 pm

#3668285
Reply To: Are Synonyms Useful?

Alex Gay wrote:
I think that Jeff has covered most of the salient points involved with using synonyms. I have used them for everything allowable, including stored procedures. We had a routine...
--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 2, 2019 at 2:14 pm

#3668278
Reply To: How does SQL determine which column a table level check constraint is applied to

michael.leach2015 wrote:
Jeff Moden,
Thanks for your input. I am familiar with IF statements and looping statements a bit. Your example will help me to get use to the programming side of...
--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 2, 2019 at 1:55 pm

#3668264
Reply To: The Problem with Users

From the Article
Plenty of others are trying to help you build a smoother database DevOps process, including Microsoft.
DevOps is NOT a process! 😉
--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 2, 2019 at 1:59 am

#3668097
Reply To: Are Synonyms Useful?

As many folks do, we have many databases associated with one "system". We have many uses for synonyms.
It's important to also know that database naming can change and tables can...
--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 2, 2019 at 1:48 am

#3668096
Reply To: How does SQL determine which column a table level check constraint is applied to
To add to what DesNorton posted, you can also check for existence of a constraint and take a conditional action in T-SQL. For example...
```
   ...
```
--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 2, 2019 at 12:40 am

#3668092
Reply To: How does SQL determine which column a table level check constraint is applied to

michael.leach2015 wrote:
It looks really nice now.
Awesome job, Michael!
I know it'll sound strange for me to say so but I'm also impressed that you took the time to discover the setting...
--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 2, 2019 at 12:27 am

#3668091
Reply To: Efficient way to split a string

ScottPletcher wrote:
It seems like it, but SQL 2008 doesn't directly read JSON, afaik. It might be easier to handle it with T-SQL rather than try to create some external function/process.
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 1, 2019 at 11:51 pm

#3668087

Viewing 15 posts - 8,911 through 8,925 (of 59,091 total)