Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,021 through 22,035 (of 59,098 total)

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
RE: Faster way to populate number table variation with inline tally?

aaron.reese (1/6/2015)
Michael Meierruth (12/30/2014)
Jeff, so what was the trick?
I guess when you need to execute something only once and it takes 900 miliseconds you give it no further thought.
Still, getting...
--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:28 am

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

jwiseh (1/5/2015)
On my SQL Server 2012 SP2 installation, The following expression always returns an integer between 1 and 6:
[font="Courier New"]SELECT CEILING(RAND()*6)[/font]
...but this function only works half the time, returning...
--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:24 am

#1768112
RE: Are the posted questions getting worse?

GilaMonster (1/5/2015)
Jeff Moden (1/4/2015)
I've taken to quoting the original post in many cases simply because too many people delete the original post even if they get a reasonable answer.
I've had...
--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 12:43 am

#1767977
RE: how to create master table in sql

KenpoDBA (1/5/2015)
I think you guys have all been punked.
Heh... ok then. Small change...
Punking us is a real quick way to lose friends. 😀
--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 12:38 am

#1767975

Viewing 15 posts - 22,021 through 22,035 (of 59,098 total)