Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,991 through 22,005 (of 59,072 total)

RE: Best approach to download variably named CSV file from FTP and insert into existing table?

Herpington_McDerpington (1/6/2015)
Thank you both for your assistance. I'm probably going to go the SSIS route since we've a good amount of existing packages today (and xp_cmdshell is presently disabled). Thanks...
--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 7, 2015 at 9:10 am

#1768499
RE: How to hide/disable the menus New Database, Restore Database in SQL Server Management Studio

Grant Fritchey (1/6/2015)
One other point, I'm not sure what industry you're working in, but many, especially healthcare, now have criminal penalties if you expose personal data to people without permission...
--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 6, 2015 at 11:44 pm

#1768333
RE: Are the posted questions getting worse?

dwain.c (1/6/2015)
SQLRNNR (1/6/2015)
Lynn Pettis (1/6/2015)
Luis Cazares (1/6/2015)
dwain.c (1/6/2015)
Lynn Pettis (1/6/2015)
... Mark one off, 52 days on the calendar to go. 52 days on the calendar to go, 52 days 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)

January 6, 2015 at 11:36 pm

#1768332
RE: cpu consumption rate

djordan 4543 (1/6/2015)
I found the solution from this hp article http://www8.hp.com/h20195/v2/Getdocument.aspx?docname=4AA4-2072ENW I am able to calculate Cpu consumption core rate at 360 mb/s
It won't help. As with every installation...
--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 6, 2015 at 11:34 pm

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

jwiseh (1/6/2015)
Thank you , Jeff, that's a perfect workaround!
Thank you for the rest of the replies as well. It's nice to know it's probably a bug in CHOOSE, and not...
--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 6, 2015 at 11:31 pm

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

Eirikur Eiriksson (1/6/2015)
While you'r at it, save yourself around 15% using an inline tally
Not to mention reads. That's why I keep a Tally function at the ready in every...
--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 6, 2015 at 11:27 pm

#1768328
RE: Converting Char string to dateTime issue

gabCruz (1/6/2015)
Hi Gents,
Thanks for all the suggestions. I already found out what the issue is. I missed to validate the date strings using isDate(). My bad. I used isDate 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)

January 6, 2015 at 11:17 pm

#1768327
RE: Are the posted questions getting worse?

Koen Verbeeck (1/6/2015)
I never clear out subscriptions, except for the daily questions.
You never know if someone stumbles on a thread after an Internet search and has an additional question on...
--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 6, 2015 at 1:18 pm

#1768237
RE: How to hide/disable the menus New Database, Restore Database in SQL Server Management Studio

Mohan G (1/6/2015)
Hi All,
Thank you very much for your quick replies. Below is the scenario for which i want to disable/hide the menus.
Whenever team take the production DB backup 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)

January 6, 2015 at 1:12 pm

#1768230
RE: Get previous years holiday date

Self join, look for the MAX date less than the current date with the same holiday name.
{edit} The self join should probably be in the form of a correlated...
--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 6, 2015 at 9:31 am

#1768140
RE: How to hide/disable the menus New Database, Restore Database in SQL Server Management Studio

Mohan G (1/6/2015)
I want to force my SQL Server developers to run a script to create a new database and restoring a database so
WHY??? :blink: Developers should NOT...
--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 6, 2015 at 9:03 am

#1768131
RE: Not able to recover database

Siva Ramasamy (1/6/2015)
But that did not help and the Log File size grew to the full capacity of the disk.
Hopefully, you've identified the code that caused that problem 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)

January 6, 2015 at 8:47 am

#1768121
RE: cpu consumption rate

djordan 4543 (1/6/2015)
Hi Guys,
I am looking to build a data warehouse and trying to analyse hardware that may be suitable.
On microsoft's website they have an article called the fast track...
--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 6, 2015 at 8:43 am

#1768118
RE: Converting Char string to dateTime issue

You don't need to do anything to it but convert it to a DATETIME. And, you don't need to insert any spaces. SQL Server is pretty tolerant when...
--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 6, 2015 at 8:35 am

#1768116
RE: How to define Production, Non-Production and Development

jdbrown239 (1/6/2015)
Hi
Not sure which forum to post this question but here goes.
My company has a stand alone sql instance with no front end application. The data in this instance is...
--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 6, 2015 at 8:32 am

#1768115

Viewing 15 posts - 21,991 through 22,005 (of 59,072 total)