Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,701 through 17,715 (of 59,069 total)

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
RE: Creating a View in Another Database Using OpenQuery

imani_technology (5/3/2016)
Fortunately, this is just a proof of concept, but you are right. I followed your advice and let the Hive expert/DBA create the view. I was 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 3, 2016 at 9:31 pm

#1876481
RE: Are the posted questions getting worse?

xsevensinzx (5/3/2016)
Hey guys,
Need some advice. I got a really good job offer recently to work at a company as a DBA. I'm currently a data architect that built and manages...
--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:28 pm

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

frederico_fonseca (5/3/2016)
no Oracle isn't better suitable - and SQL Server Express will still hold with that volume. what you need to find out is exactly how many records each table...
--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:15 pm

#1876478

Viewing 15 posts - 17,701 through 17,715 (of 59,069 total)