Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,731 through 17,745 (of 59,102 total)

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
RE: Need to store .wav files out on disk, but the metadata should remain inside the database

ffarouqi (5/5/2016)
Jeff Moden (5/5/2016)
ffarouqi (5/2/2016)
One of my clients have a project requirement, where they need to store the .wav files out of the database onto the storage subsystem, and 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)

May 5, 2016 at 10:21 pm

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

With the disclaimer that I've never had to work directly with IMS nor am I a Cobol programmer, it seems to me that what people are calling a "hierarchical" database...
--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 5, 2016 at 8:45 pm

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

Wow. I wrote the code almost 3 years ago. I didn't remember the problems that we had with Linq2SQL and other things that had to be written into...
--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 5, 2016 at 8:34 pm

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

J Livingston SQL (5/5/2016)
Jeff Moden (4/28/2016)
Apologies. I'm not going to get to this tonight or tomorrow. I'm in the middle of a server migration and I need to...
--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 5, 2016 at 2:01 pm

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

ffarouqi (5/2/2016)
One of my clients have a project requirement, where they need to store the .wav files out of the database onto the storage subsystem, and have the pointers or...
--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 5, 2016 at 1:35 pm

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

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 I was inserting 600 records...
--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 5, 2016 at 1:21 pm

#1876963
RE: Why STUFF

Luis Cazares (5/5/2016)
Raghavendra Mudugal (5/5/2016)
Luis Cazares (5/4/2016)
Raghavendra Mudugal (5/4/2016)
(EP)Z!!!
No need of STUFF. (very old code)
No need for cursors, or several statements.
WITH CTE AS(
select distinct personid from...
--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 5, 2016 at 1:16 pm

#1876960
RE: Why STUFF

edwardwill (5/4/2016)
Ed Wagner (5/4/2016)
It came from Wayne Sheffield's SQL Spackle article on string concatenation. The article is at http://www.sqlservercentral.com/articles/comma+separated+list/71700/. It's a great technique.
It's broken so no, it's not...
--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 5, 2016 at 8:21 am

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

Jez-448386 (5/5/2016)
Many of the generic triggers that I have seen, including Pop Rivett's, create an SQL statement for each column in the table so with a wide table of say...
--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 5, 2016 at 7:40 am

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

Wayne West (5/4/2016)
Wow. 4 minutes for an update with an audit? I notice zero delay with Pop Rivett's audit trigger.
That's the problem with a lot 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 4, 2016 at 5:07 pm

#1876742
RE: How to show CAPS lock status in Management Studio status bar?

amar_sharma (5/4/2016)
@jeff Moden, :blink: It was on the same day, as, didn't get any reply and views were increasing, so, being a newbee, I doubted myself, whether I have asked...
--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 4, 2016 at 8:38 am

#1876615
RE: GUI Enhancement on Instant File Initialization (IFI) in SQL Server 201

Hommer (5/3/2016)
Thanks!
By the way, what are the risks?
There are two.
The first is that you've just given the SQL Server login more privs.
The second is that old data isn't removed from...
--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 3, 2016 at 9:59 pm

#1876482

Viewing 15 posts - 17,731 through 17,745 (of 59,102 total)