Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,651 through 34,665 (of 59,102 total)

RE: NoSQL is Not the Answer

NoSQL types of databases may, in fact, be the answer. Now, lets figure out what the question is. 😛
If you need a database that is essentially nothing but 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)

March 12, 2011 at 9:57 pm

#1298070
RE: Why Sql Server fails to use index?

But there is no obvious advantage for this query btw clustered and nonclustered index.
Maybe not. But you're really going to hate yourself if this table get's any depth...
--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)

March 12, 2011 at 8:04 pm

#1298066
RE: Displaying Sorted Hierarchies (SQL Spackle)

Very cool compliment. :blush: Thanks Mishaluba!
I aim to please. I sometimes miss but I'm always aiming. 😀
--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)

March 12, 2011 at 7:30 pm

#1298061
RE: Serialising tabular and relational data.

Phil, I have to mostly agree with djackson above. The editorial almost sounds like whining about the disparities of transmittable data formats. A "universal" data format has been...
--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)

March 12, 2011 at 12:16 pm

#1298029
RE: Serialising tabular and relational data.

djackson 22568 (3/12/2011)
The universities would distain such a practical task.
Oh please, let's not involve the universities! Seriously, I am tired of the better than you attitude of American universities....
--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)

March 12, 2011 at 12:04 pm

#1298027
RE: Fixed Length Flat File

josetur12 (3/11/2011)
I have a flat file with over 200 fixed length columns
We're just guess here because we can't see your file.
Do you have a record layout for this file 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)

March 12, 2011 at 11:07 am

#1298021
RE: working and stopped time from devices logs

Sorry, forgot to post the results...
Device StartDateTime StopDateTime ...
--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)

March 12, 2011 at 10:50 am

#1298020
RE: working and stopped time from devices logs

Nuno Martins (3/11/2011)
I have a table with devices logs and I need calculate the working time and stopped time, how making in sql?
The sample log table:
device1 0 ...
--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)

March 12, 2011 at 10:48 am

#1298019
RE: Cursor use in Oracle

I absolutely agree but, just like I said a year and a half ago, too many people simply give up too easily on finding a high performance set based solution....
--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)

March 12, 2011 at 9:21 am

#1298013
RE: ISDATE difference from client and server

Stuart Davies (3/11/2011)
Hi,
Can anyone help out me please.
If I run select isdate('27/1/2011') from my local install of SQL against a server I get 1
If I run the same query directly...
--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)

March 12, 2011 at 9:15 am

#1298012
RE: Types of Composite Keys

My recommendation is "Try it". You may forget what you've been told but you won't forget what you've done. 😉
--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)

March 12, 2011 at 9:02 am

#1298011
RE: Columns to Row?

jason-772533 (3/12/2011)
I'm probably just being a bit stupid and missing the point.
Nope. You're alright, Jason. 🙂 It's a bit difficult to understand the concept when it comes 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)

March 12, 2011 at 8:57 am

#1298010
RE: Correspond multiple values to a single username

Everything is good there except I wouldn't make the delimited list for the front end. Just return a result set and consume it at the front end. 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)

March 12, 2011 at 7:38 am

#1298006
RE: Group by

Brandie Tarvin (3/11/2011)
It wouldn't work if Roy was using some other data or delimiter
It only takes one well place REPLACE to fix that little nuance.
--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)

March 11, 2011 at 11:02 pm

#1297978
RE: Correspond multiple values to a single username

jashwantsingh (3/11/2011)
Hello friends , I am newbie here.
In my project a user can have multiple friends and I need to store friends of a each user. What I am...
--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)

March 11, 2011 at 10:53 pm

#1297977

Viewing 15 posts - 34,651 through 34,665 (of 59,102 total)