Jeff Moden

Forum Replies Created

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

Reply To: Are Synonyms Useful?

frederico_fonseca wrote:
in VS - yes we can use the variables to replace with the appropriate database name - This can be done on the synonyms so we can still avoid...
--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 6, 2019 at 7:49 pm

#3669279
Reply To: Audit Users logging in using "sa" or service accounts

From the Article:
Triggers are not allowed in our production environment...
Heh... I realize that a lot of folks abuse triggers and write horrible trigger code but flat outlawing such an incredibly...
--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 5:24 pm

#3668904
Reply To: Are Synonyms Useful?

I take it you never need to make copies of prod then or, perhaps, you use the same method to make such copies? There's just no way that I'd allow...
--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 3:33 pm

#3668866
Reply To: BEGIN TRANSACTION, ROLLBACK TRANSACTION, COMMIT TRANSACTION

For ad hoc stuff, I don't use a programmatic method to commit or rollback. Someone at one of the companies I used to work for did such a thing. There...
--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 3:29 pm

#3668858
Reply To: Are Synonyms Useful?

@tsalha,
Are we talking about front end code or stored procedures here? And, please pardon my ignorance of VS. I've never actually used 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)

August 5, 2019 at 2:19 pm

#3668822
Reply To: Understanding the use of a CTE with MERGE
DesNorton wrote:
I haven't used the MERGE statement since I got burned many years ago doing a
```
WHEN NOT MATCHED BY SOURCE THEN DELETE
```
As it turns out, you end...
--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 2:04 pm

#3668820
Reply To: Are Synonyms Useful?

tsalha wrote:
We once used to utilizing them, but with the advent of database projects in VS, we abandoned them again from our development. This due to the reason, that VS...
--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 2:00 pm

#3668814
Reply To: Are Synonyms Useful?

Eric M Russell wrote:
Synonyms can be useful for whomever created them, but confusing for others who stumble across them by accident. It depends on the purpose, but I prefer views instead.
Interesting. I've...
--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 1:58 pm

#3668813
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

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