Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,896 through 8,910 (of 59,067 total)

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
Reply To: Efficient way to split a string

I might be missing something but that looks an awful lot like JSON. Is 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 1, 2019 at 5:27 pm

#3667987
Reply To: Login Trigger / Audit

jkw wrote:
Thanks for your input. I've done some thinking about this and might be able to work something out querying the sys.syslogins. Since a trigger will catch every login 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)

August 1, 2019 at 11:54 am

#3667863
Reply To: Login Trigger / Audit
Andrey wrote:
Jeff, I agree that on busy systems these 5 files (20 MB each) of default trace will be overwritten soon, but look at at from the following angle:
--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:49 am

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

MVDBA (Mike Vessey) wrote:
What I'm really getting at is that a lot of Developers that I've worked with at other companies think that they don't need to test their own code 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)

August 1, 2019 at 11:46 am

#3667859
Reply To: Login Trigger / Audit

Not to mention that the default trace file has a pretty small row limit before it "rolls over", it only stores (IIRC) 6 total files, and a busy system 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 1, 2019 at 12:44 am

#3667767
Reply To: OS Memory high

Admingod wrote:
Can you think of anything that could cause the problem?
Call the vendor that provided the "application". If the "application" was written by you good folks, you can't "call 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)

July 31, 2019 at 10:13 pm

#3667719
Reply To: Cannot create a row of size XXXX which is greater than the allowable maximum row size of 8060

ScottPletcher wrote:
Agreed. Be nice if MS added the option to the CREATE TABLE statement, so that SQL would "know" that the variable length bytes are not needed at all for...
--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 31, 2019 at 8:19 pm

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

chris geswein wrote:
Heh... but ONLY if the reason for the change wasn't in the form of a requirements change. Otherwise, the existing unit test is totally useless and actually may cause...
--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 31, 2019 at 8:15 pm

#3667689
Reply To: Cannot create a row of size XXXX which is greater than the allowable maximum row size of 8060

ScottPletcher wrote:
Then again, with properly normalized tables, I can't imagine ever needing more than 10 (if that many?) max-length columns in one row.
I cannot give that comment enough good points! ...
--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 31, 2019 at 5:10 pm

#3667648

Viewing 15 posts - 8,896 through 8,910 (of 59,067 total)