Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,686 through 17,700 (of 59,069 total)

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
RE: How to show CAPS lock status in Management Studio status bar?

amar_sharma (5/6/2016)
You are welcome, Jeff. It was a pleasure to see your replies on the post..!!
Thanks.
Thanks for the feedback, Amar. Just to be sure, most of the heavy hitters...
--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 6:20 am

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

R.P.Rozema (5/6/2016)
Seriously, I see it was suggested before, did you have a look at CDC (Change Data Capture)? BOL: https://msdn.microsoft.com/en-us/library/cc645937.aspx. This technology provides -though only available in the enterprise...
--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 6:09 am

#1877088
RE: IBM Hierarchical IMS Database model to RDBMS, options ?

EdVassie (5/6/2016)
Jeff, certainly doing a 1 to 1 mapping of what IMS calls Segments into relational tables will give a reasonable first-cut design.
Most of the mapped tables will...
--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 4:36 am

#1877071

Viewing 15 posts - 17,686 through 17,700 (of 59,069 total)