Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,976 through 21,990 (of 59,098 total)

RE: Data Lakes

I guess I'd have to ask why anyone might think this is a new idea. Isn't this the purpose of things like databases?
--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)

January 10, 2015 at 1:36 pm

#1769255
RE: Screen layout messed up in Forum control panel

I'm not having such a problem and I have IE 11.
--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)

January 10, 2015 at 1:33 pm

#1769254
RE: How to juxtapose ( pivot horizontally ) Author names, and group by Book title

http://www.sqlservercentral.com/articles/comma+separated+list/71700/
--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)

January 10, 2015 at 1:32 pm

#1769253
RE: query

peterausger (1/8/2015)
Dear all,
I have following table
id id1 id2 id3 id4 ...
--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)

January 10, 2015 at 11:36 am

#1769248
RE: New to SQL. Need help

OwnSQL (1/10/2015)
Hi I have to create a table with the following
Accountnumber,DOB,FullName,Accountopendate,currentbalance
I am having troubles:
What data type should I use for DOB?
Use the DATE datatype, unless you're anticipating doing some...
--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)

January 10, 2015 at 11:07 am

#1769245
RE: Comvault Backups breaking the backup chain?

Welsh Corgi (1/10/2015)
I'm performing SQL Server native backups and Comvault Backups are breaking the backup chain?
I can work around them if they only perfume 1 backup per day.
We have 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)

January 10, 2015 at 10:56 am

#1769244
RE: SQL Select stament

Dee Dee-422077 (1/9/2015)
Hi,
My example data as this:
ID code1 code2
1 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)

January 10, 2015 at 10:39 am

#1769242
RE: SQL Select stament

Eirikur Eiriksson (1/9/2015)
Dee Dee-422077 (1/9/2015)
Hi,
My example data as this:
ID code1 code2
1 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)

January 10, 2015 at 10:38 am

#1769241
RE: SQL Select stament

LinksUp (1/9/2015)
Here is another even simpler solution!
declare @t table
(
ID int
, code1 char
, code2 char
)
insert @t values
(1,'a','m')
,(1,'b','n')
,(1,'c','T')
,(2,'d','m')
,(2,'e','n')
,(2,'f','n')
,(3,'g','m')
,(3,'h','n')
,(3,'i','T')
;with cte as
(
Select id
...
--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)

January 10, 2015 at 10:34 am

#1769240
RE: Failed reindex caused massive DB file growth

sickpup (2/17/2011)
Great info - thanks all. I knew shrinkfile would cause fragmentation... just didn't know how bad it would be.
So, here's the gameplan:
Identify the NC indexes on the affected DB...
--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)

January 10, 2015 at 10:28 am

#1769239
RE: Split Function on the basis of Contact Number

Why would anyone take the time to "split" the data, clean it, and not normalize it? :blink:
--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)

January 10, 2015 at 6:54 am

#1769238
RE: How to buffer more data for longer time

Bill Talada (1/8/2015)
I have a customer with awful disk throughput but lots of memory on the host. I understand data pages are aged out of cache after five minutes....
--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)

January 10, 2015 at 6:52 am

#1769237
RE: how to answer interview question "what is the hardest sproc you have created?"

Grant Fritchey (1/9/2015)
Jeff Moden (1/9/2015)
Brandie Tarvin (1/9/2015)
I've been through 5 managers...
BWAAAA-HAAAAA-HAAAA!!!! You must be tough on managers! :-D:-P
I'm finishing up my fourth year at Redgate and I'm on my...
--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)

January 10, 2015 at 6:20 am

#1769236
RE: CHOOSE() a RAND() vowel not working???

Have you seen Dwain C's article on the generation of random sets?
--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)

January 9, 2015 at 12:51 pm

#1769182
RE: how to answer interview question "what is the hardest sproc you have created?"

Brandie Tarvin (1/9/2015)
I've been through 5 managers...
BWAAAA-HAAAAA-HAAAA!!!! You must be tough on managers! :-D:-P
--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)

January 9, 2015 at 12:45 pm

#1769178

Viewing 15 posts - 21,976 through 21,990 (of 59,098 total)