Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,646 through 21,660 (of 59,098 total)

RE: incrementing alpha string using SQL

My last response on this was nearly a decade ago. I no longer believe that recursion of a scalar function would be the right way to go nor do...
--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)

February 2, 2015 at 11:51 am

#1774854
RE: 'sys.dm_db_index_physical_stats' giving 3 rows with different fragmentation.

Tac11 (2/1/2015)
So which level is fragmented 99% according to G. Berry's script? should I be worried about above result and run rebuild index job?
Just change the Word "Detailed" to "Sampled"...
--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)

February 2, 2015 at 11:09 am

#1774836
RE: how to read contents of flat file in SSIS and extract from it just one value for use in variable?

KoldCoffee (1/22/2015)
Yes, I thank you but like you say it's probably overkill. I have to learn C# for making the most of the script task transformation (Control Flow).
IMHO, learning...
--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)

February 2, 2015 at 11:00 am

#1774832
RE: SQL Server closes database backup request to NAS share in middle of restore

Brandie Tarvin (2/2/2015)
UPDATE:
We have some issues with changing the TCP Chimney Offset (corporate owns these servers and our server guy is leery of playing with the settings). The suggestion 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)

February 2, 2015 at 8:13 am

#1774789
RE: How to encapsulate table columns into individual tags?

rybo (2/2/2015)
Jeff Moden (2/1/2015)
rybo (2/1/2015)
Per the agency’s specification document,
Can you, by any chance, provide a link to that spec? I'd like to cite it for something else I'm...
--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)

February 2, 2015 at 7:39 am

#1774779
RE: How to encapsulate table columns into individual tags?

rybo (2/1/2015)
Per the agency’s specification document,
Can you, by any chance, provide a link to that spec? I'd like to cite it for something else I'm doing.
--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)

February 1, 2015 at 4:14 pm

#1774661
RE: sum result type character

elkinfortiz (2/1/2015)
i neek result from '(1000/3)+(15/100)'. try exec() by failed. Thands for your help.
Not sure why you would try EXEC() for this. You just need a SELECT with 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)

February 1, 2015 at 11:31 am

#1774644
RE: Rename a Live database

sm_iransoftware (1/31/2015)
Because The cur Database has about 200 GB.
And we dont have enough space and we must Backup from it and then truncate tables.
But Backup from this size with many...
--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)

February 1, 2015 at 11:22 am

#1774642
RE: Anyone tried "DBA Job Interview Question & Answer Kit"?

The bottom line (I think) here is that there's really no way to actually know what will happen during the interview and you have to be prepared for whatever. ...
--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)

February 1, 2015 at 10:57 am

#1774641
RE: The Number that shouldn't be a number

jarick 15608 (2/1/2015)
How about storing all of the data in XML in a compressed binary string and using and using am image datatype to store it in. To read...
--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)

February 1, 2015 at 10:28 am

#1774640
RE: The Number that shouldn't be a number

Michael Valentine Jones (2/1/2015)
I worked at a place where consultants came up with a design for a high volume OLTP application that would completely replace SQL Server with XML flat...
--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)

February 1, 2015 at 10:14 am

#1774639
RE: The Number that shouldn't be a number

jarick 15608 (1/31/2015)
Jeff, I think we must have run into the same consultants. I had one of my clients hire a data warehouse expert that did not know...
--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)

February 1, 2015 at 10:04 am

#1774638
RE: The Number that shouldn't be a number

Eirikur Eiriksson (1/31/2015)
jwiseh (1/31/2015)
I remember the pain of working with a system where a developer had chosen the TIME data type to store the number of hours worked in...
--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)

February 1, 2015 at 9:54 am

#1774637
RE: Rename a Live database

sm_iransoftware (1/31/2015)
1- Create a new database with same structure.
I guess my question is, if it's the same structure, why are you bothering to do this in the first place?
--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 31, 2015 at 11:16 pm

#1774605
RE: Anyone tried "DBA Job Interview Question & Answer Kit"?

yoshii (1/31/2015)
Thanks to Jeff and others' contributions. All discussions are valuable.
@jeff. Thanks for the valuable feedbacks!
In my opinion, communication not only happens verbally, but also at implication level...
--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 31, 2015 at 11:01 pm

#1774604

Viewing 15 posts - 21,646 through 21,660 (of 59,098 total)