Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,466 through 12,480 (of 59,099 total)

RE: How to convert PDF data to database table in SQL server

keddula - Saturday, April 28, 2018 12:47 AM
Hi,
Can any one suggest on conveting PDF file data to SQL table in SQL server.
Thanks.
You...
--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)

April 29, 2018 at 7:29 am

#1988573
RE: The Last Service Pack

Rod at work - Friday, April 27, 2018 10:38 AM
This change in how Microsoft is pushing out updates, using CU's instead 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)

April 28, 2018 at 2:34 pm

#1988563
RE: Strange "The datepart millisecond is not supported by date function dateadd for data type date." error

btio_3000 - Saturday, April 28, 2018 9:52 AM
Thanks for replying,
Not sure I understand...
like I said both [date2] in dbo.[myTable] and [date1]...
--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)

April 28, 2018 at 2:07 pm

#1988562
RE: CTE Recursive Hierarchy Order

kiran 4243 - Saturday, April 28, 2018 1:59 AM
Hi,
Please refer to the attached image for your kind perusal.
For example the product 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)

April 28, 2018 at 1:53 pm

#1988561
RE: Recovery mode reverting to Full

sharky - Thursday, April 26, 2018 6:25 AM
Thom, Erikur, Thanks for the help.. Understand a bit more how AWS works.. thanks.. 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)

April 27, 2018 at 4:24 pm

#1988533
RE: designing portal so we don't run into performance issues.

NewBornDBA2017 - Friday, April 27, 2018 12:35 PM
Sue_H - Thursday, April 26, 2018 3:36 PM
--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)

April 27, 2018 at 4:01 pm

#1988532
RE: Are the posted questions getting worse?

Jason A. Long - Friday, April 27, 2018 11:14 AM
Steve Jones - SSC Editor - Thursday, April...
--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)

April 27, 2018 at 11:26 am

#1988496
RE: Packaged-Application Database Nightmares - A Horror Story.

Eric M Russell - Thursday, April 26, 2018 7:42 AM
Jeff Moden - Wednesday, April 25, 2018 4:17...
--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)

April 26, 2018 at 8:23 am

#1988359
RE: Packaged-Application Database Nightmares - A Horror Story.

p.s. I'm going through the drill right now. Our telephone system vendor has asked for a login with "sa" privs for their new reporting system. They're into that "Well other...
--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)

April 25, 2018 at 4:17 pm

#1988278
RE: Packaged-Application Database Nightmares - A Horror Story.

Ray Herring - Wednesday, April 25, 2018 1:13 PM
Jeff Moden - Wednesday, April 25, 2018 7:56 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)

April 25, 2018 at 4:14 pm

#1988277
RE: Auditing

Sue_H - Wednesday, April 25, 2018 3:45 PM
AndrewL65 - Tuesday, April 24, 2018 4:35 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)

April 25, 2018 at 4:02 pm

#1988275
RE: Getting 10,000 rows of SQL code into SSRS

jeffshelix - Wednesday, April 25, 2018 7:48 AM
I wrote 10,000 lines of SQL (several temp tables) and i would like to move...
--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)

April 25, 2018 at 8:05 am

#1988187
RE: Stored Proc Permissions

Sounds like an interview question.
--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)

April 25, 2018 at 8:03 am

#1988184
RE: Transferring data between tables

richardmgreen1 - Wednesday, April 25, 2018 7:51 AM
To be honest, it wasn't very scientific.
We split them into 300 column "lumps".
We've quite 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)

April 25, 2018 at 7:58 am

#1988182
RE: Packaged-Application Database Nightmares - A Horror Story.

Eric M Russell - Wednesday, April 25, 2018 7:47 AM
If a software application is hard coded to use the "SA" account,...
--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)

April 25, 2018 at 7:56 am

#1988180

Viewing 15 posts - 12,466 through 12,480 (of 59,099 total)