Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,716 through 17,730 (of 59,102 total)

RE: RANDom traps for the unwary

Andrew Morgan (5/9/2016)
However beware, when used in a select, it is only evaluated once, eg
SELECT RAND(),*
FROM sys.objects
GO
will output the SAME value.
That and a workaround substantial enough for the generation 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)

May 9, 2016 at 6:33 pm

#1877644
RE: RANDom traps for the unwary

robert.bruhin (5/9/2016)
Thank you! I was planning on writing a similar response. The problem here is not with the Random function, but with the author's confusion about the proper use and...
--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)

May 9, 2016 at 6:14 pm

#1877643
RE: Padding a string with extra 0's

tarr94 (5/6/2016)
Two of you have chimed in with a preference for keeping this sort of logic out of SQL. Could you please clarify why you feel this way? ...
--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)

May 9, 2016 at 4:50 pm

#1877639
RE: Does T-SQL have a means of iterating over the columns of a table?

J Livingston SQL (5/6/2016)
some test data......and yeah the generic audit is slow.
Personally I only use this for Updates and only on relatively small tables with few changes....tables for customers/products etc.
Just...
--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)

May 8, 2016 at 3:03 pm

#1877374
RE: Does T-SQL have a means of iterating over the columns of a table?

J Livingston SQL (5/8/2016)
Sergiy (5/8/2016)
J Livingston SQL (5/6/2016)
R.P.Rozema (5/6/2016)
mock up some example table and generate a significant volume of test data into it
some test data......and yeah the generic audit...
--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)

May 8, 2016 at 2:49 pm

#1877372
RE: Application (entity framework) error - Any thoughts?

SQL!$@w$0ME (5/6/2016)
We see this error once in a while on the application side(web services). Backend - SQL server 2014.
An error occurred while executing the command definition. See the inner exception...
--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)

May 6, 2016 at 11:42 pm

#1877309
RE: Any one can send me answers for these

I get that not everyone can know everything but the truth eventually came out. The OP didn't even try to help himself and wanted others to do the research...
--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)

May 6, 2016 at 11:34 pm

#1877308
RE: What is the best to remove xp_cmdshell calls from t-sql code

Mcin (4/4/2016)
Application connects to server using domain users. They have no admin privileges.
sa account is already disabled. It is application that works for few years already and now I'm maintaining...
--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)

May 6, 2016 at 9:08 pm

#1877302
RE: Moving a large number of databases from one server to another?

TheSQLGuru (5/3/2016)
Backup and restore works fine.
Detach and reattach works fine (beware the stats updates though - make sure you tell the script to not do those).
If this is 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)

May 6, 2016 at 9:01 pm

#1877301
RE: Pros/Cons between Default vs Named Instances

Still, it's another answer that someone may run across and benefit from. Some of the "old" problems are very relevant even today. I never mind it when someone...
--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)

May 6, 2016 at 7:48 pm

#1877299
RE: Any one can send me answers for these

ffarouqi (5/6/2016)
I believe I agree with you'll to some extent, but not totally. If you guys know a lot of the DBA stuff, at least do not make fun 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)

May 6, 2016 at 7:14 pm

#1877298
RE: SQL Server Resource Governor

sqldoubleg (4/28/2016)
Jeff Moden (4/26/2016)
Thanks for the article, Raul. I especially like what I saw on the PerfMon chart in the "Results" section.
Not much to add because Kevin beat me...
--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)

May 6, 2016 at 5:23 pm

#1877290
RE: Need to store .wav files out on disk, but the metadata should remain inside the database

ffarouqi (5/6/2016)
Thanks! Jeff. It is definitely very informative, but unfortunately it still keeps me thinking on how the implementation steps look like.
Understood. The key here will now be 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)

May 6, 2016 at 5:16 pm

#1877289
RE: Does T-SQL have a means of iterating over the columns of a table?

Shifting gears though and no matter the method of auditing, auditing INSERTs is a huge waste of time, effort, and disk space. Audits should ONLY record changes to 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)

May 6, 2016 at 9:42 am

#1877192
RE: Does T-SQL have a means of iterating over the columns of a table?

Rod at work (5/6/2016)
Jeff Moden (5/5/2016)
Wayne West (5/5/2016)
Good points. My biggest table has 66 columns (all the other active tables have a very small column count), but even when...
--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)

May 6, 2016 at 9:40 am

#1877190

Viewing 15 posts - 17,716 through 17,730 (of 59,102 total)