Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,006 through 22,020 (of 59,072 total)

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
RE: BCP Cannot access a network share

Ron.James (1/5/2015)
Hmmm, why should my credentials need to make it out to the Server. The credentials that SQL Server is running under are already sufficient to read the file...
--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:36 am

#1767974
RE: How to Import Data from Excel sheet to Sql server 2008

navbingo20 (1/5/2015)
@jeff Moden :
First of all, i am very sorry for the delayed response..
it is perfectly working .. only one thing to be noted is , after downloading...
--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:27 am

#1767972
RE: NEED COLUMN NAMES FROM TABLE DYNAMICALLY

Kannan Vignesh (1/5/2015)
hi ,
i studied , it ll not allowed to table get lock. DBA team suggests that it ll increase your query performance. eg, try with nolock and with...
--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:22 am

#1767971
RE: NEED COLUMN NAMES FROM TABLE DYNAMICALLY

Kannan Vignesh (1/5/2015)
thanks for your clarification. i will correct it.
Ok jeff. with out nolock, if many peoples accessing same table means it cause any performance issue..?
thanks
Kannan.
Only if there's bad code...
--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:17 am

#1767969
RE: BCP Cannot access a network share

Ron.James (1/5/2015)
Thanks for the reply and sorry for the confusion over BCP.
I'm really quite sure its not as simple as file share permissions. I've been looking at...
--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 5, 2015 at 5:39 pm

#1767930
RE: How to Import Data from Excel sheet to Sql server 2008

@Navin,
Any feedback on this? Did it work for you or ???
--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 5, 2015 at 5:04 pm

#1767920
RE: BIDS 32bit or 64 bit application?

it.anishmca (1/5/2015)
Hey Folks,
I am facing an error issue while installation of 32-bit SQL Server BIDS on my 64-bit Windows-7 professional Edition.
Kindly help.
It would probably help if you told us what...
--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 5, 2015 at 4:47 pm

#1767913
RE: Backup 500GB SQL database and copy across to a remote server, to be restored.

Lempster (1/5/2015)
Jeff Moden (1/5/2015)
For the initial sync (a few terabytes), our guys went down to the DR site, unbolted the SAN, brought it to the production site, did the copy...
--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 5, 2015 at 9:30 am

#1767811
RE: Reclaim unused space / Rebuild table

Using SHRINK fragments all indexes in the database on a massive scale. I wouldn't do it unless something really bad and huge happened to the database and then I'd...
--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 5, 2015 at 9:17 am

#1767809
RE: Employee or Consultant?

I enjoy some of the best of both worlds.
As an FTE, I work with a great team that includes everyone from the owners, through the C-Level, local managers, right down...
--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 5, 2015 at 8:22 am

#1767789
RE: Backup 500GB SQL database and copy across to a remote server, to be restored.

Lempster (1/5/2015)
Depending on the bandwidth of your network and how far way the 3rd party datacenter is, you may find it quicker to copy the backup to an encrypted external...
--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 5, 2015 at 8:05 am

#1767779

Viewing 15 posts - 22,006 through 22,020 (of 59,072 total)