Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,616 through 21,630 (of 59,072 total)

RE: Is it possible to embed a parameter in the name of stored procedure that's called from within another sproc?

CELKO (2/2/2015)
These report periods can overlap or have gaps. I like the MySqL convention of using double zeroes for months and years, That is 'yyyy-mm-00' for a month within 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)

February 2, 2015 at 10:04 pm

#1774934
RE: Should I create an SP

Have an old app that imports data into a MSSQL server DB using an ODBC connection.
To be honest, because of the CID=1 thing, all of the solutions so far look...
--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 6:22 pm

#1774917
RE: sum result type character

elkinfortiz (2/2/2015)
If your analysis is correct. But this strip of operations corresponds to an interpretation of fields, sort of mini compiler, which translates : ' (WIDTH / 3 ) +...
--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:58 am

#1774857
RE: Swap Firstname lastname

sharonsql2013 (2/2/2015)
I was joining two tables on PersonFullname column when found that one tables has PersonFullname as Roger, Sharon whereas the other has Sharon Roger
How can I swap...
--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:55 am

#1774856
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

Viewing 15 posts - 21,616 through 21,630 (of 59,072 total)