Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,996 through 17,010 (of 59,067 total)

RE: Need query for After Trigger on update,delete

ScottPletcher (8/17/2016)
Again, auditors would not have access to the original table.
But they have direct access to the audit table? That doesn't make sense to me but, of course, 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 17, 2016 at 11:41 am

#1895987
RE: what are some common naming conventions for sprocs?

sqlguy-736318 (8/17/2016)
There are tools which automate the generation of sprocs for a given database. At least 1 of these tools generate sprocs using the naming convention I mentioned.
I can't...
--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 17, 2016 at 9:18 am

#1895941
RE: Need query for After Trigger on update,delete

ScottPletcher (8/17/2016)
Jeff Moden (8/16/2016)
ScottPletcher (8/16/2016)
Jeff Moden (8/16/2016)
ScottPletcher (8/16/2016)
Even so, it's likely that for in-house audits, or less formal audits, the current table could be freely accessed, and then INSERTs might...
--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 17, 2016 at 8:56 am

#1895938
RE: Update statistics after Index Rebuild ?

MyDoggieJessie (8/17/2016)
Hey Jeff - care to share your job script for the stats?
😀
It's not my script. The folks before me downloaded it from the internet. To be absolutely...
--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 17, 2016 at 8:23 am

#1895931
RE: Still Confused about the difference between varchar(max) and varchar(8000)

joshua 15769 (8/17/2016)
Interesting! Thank you for the kind response! I'll use varchar(8000) from now on.
Just to emphasize what Grant stated... RIGHT SIZING of any and all columns is a best...
--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 17, 2016 at 8:13 am

#1895927
RE: The Max datetime

Need a correction in the original question. It shouldn't be "datetime". It should be "smalldatetime", just to avoid confusion that seems to be leading to a rather large...
--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 16, 2016 at 11:19 pm

#1895832
RE: Still Confused about the difference between varchar(max) and varchar(8000)

joshua 15769 (8/16/2016)
With what I know, varchar(max) could store up to 2GB of data while varchar(8000) would store 8MB of data, My question is, what is the difference if 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 16, 2016 at 11:15 pm

#1895831
RE: Query plan analysis

yujinagata72 (8/16/2016)
Hi,
If I get a query plan XML, what kind of information will make it to be considered as a 'bad' plan?
I can think of the following:
- PhysicalOp="Clustered Index Scan"
-...
--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 16, 2016 at 11:12 pm

#1895830
RE: Update statistics after Index Rebuild ?

Heh... I keep it simple. I've not done any index maintenance on my "money maker" box since 18 Jan 2016 and performance has actually and significantly improved. 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 16, 2016 at 11:04 pm

#1895829
RE: Rounding in tsql

ntreelevel (8/16/2016)
Hi all, Thank you for the answers but I figured out that using a case statements for custom rounding is the best way and it worked out
Would you post...
--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 16, 2016 at 10:55 pm

#1895828
RE: Need query for After Trigger on update,delete

ScottPletcher (8/16/2016)
Jeff Moden (8/16/2016)
ScottPletcher (8/16/2016)
Even so, it's likely that for in-house audits, or less formal audits, the current table could be freely accessed, and then INSERTs might not need logged....
--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 16, 2016 at 4:39 pm

#1895812
RE: Writing Better T-SQL: Top-Down Design May Not be the Best Choice

Jeff Moden (8/16/2016)
ChrisM@Work (8/16/2016)
The Dixie Flatline (8/16/2016)
Interesting discussion, but I am concerned about the casual dismissal of the number of logical reads. A consequence of more logical reads...
--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 16, 2016 at 4:25 pm

#1895809
RE: Partition and Index Alignment

Apologies for playing "20 questions" with you but why is it that you want to partition the table? If it's for code performance, save yourself the trouble because partitioning...
--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 16, 2016 at 3:11 pm

#1895795
RE: Want to give rights to user wo can configure replication but can not update database

sonimitu (8/16/2016)
Hi!
I am using SQL 2005 Enterprise Edition, I want to create a user who do not have update rights on the database (allowing read and write), but he 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 16, 2016 at 3:05 pm

#1895793
RE: Table Partition for date range>90 days

khushbu (8/15/2016)
Wanted to know how do I create partition function for date range >90 days
basically I need partition all the rows from Table A which are older than 90 days...
--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 16, 2016 at 3:02 pm

#1895792

Viewing 15 posts - 16,996 through 17,010 (of 59,067 total)