Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,211 through 21,225 (of 59,098 total)

RE: convert from access to sql server please help

draganl2000 (3/23/2015)
that is my code
TRANSFORM First(Eval1to4.answer) AS FirstOfanswer SELECT Eval1to4.evalOid, Membershiptypemap.mappedvalue as membership, First(Eval1to4.answer) AS [Total Of answer] FROM (Members RIGHT JOIN (Eval1to4 LEFT JOIN Orders ON Eval1to4.evalOid =...
--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)

March 23, 2015 at 9:52 am

#1785745
RE: Finding Beginning Date from multiple lines of date ranges

REYES_MONIKA (3/23/2015)
You Guys are the BEST!!! Many helpful tips and pointers!:) So much detail, thank you all very very much.
Thank you Eirikur Eiriksson, Jeff Moden & ZZartin.
Heh......
--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)

March 23, 2015 at 9:38 am

#1785742
RE: Bulk Insert Errors

You can't use BULK INSERT to import .xlsx files. It can be done with OPENROWSET but you'll need the ACE Drivers to do that. http://www.microsoft.com/en-us/download/details.aspx?id=13255
--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)

March 23, 2015 at 12:56 am

#1785618
RE: Creating multiple copies of a database.

Teach the students how to do a restore on the first day.
--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)

March 23, 2015 at 12:53 am

#1785617
RE: Will there be any problem in migrating data from evaluation edition DB ?

Joy Smith San (3/22/2015)
Hi All,
What are the limitations of SQL Server evaluation edition ?
Client is planning to buy a enterprise licence after 3-5 months.
Can they test their application by...
--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)

March 23, 2015 at 12:47 am

#1785616
RE: convert from access to sql server please help

You might also add the occasional line break in your posted code so it can actually be read a little easier. 😉 A better idea would be 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)

March 23, 2015 at 12:35 am

#1785615
RE: The Worst Comments

dwain.c (3/22/2015)
Jeff Moden (3/22/2015)
To me, it's simple and I train the Devs and DBAs that I work with on two very simple concepts.
Isn't training Devs akin to training cats? ...
--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)

March 22, 2015 at 10:03 pm

#1785608
RE: The Worst Comments

Steve Jones - SSC Editor (3/16/2015)
Eirikur Eiriksson (3/13/2015)
Digressing slightly, how would the threadizens describe the optimal code comments? Obviously the opposite of that would be the worst;-)
😎
I want to ask...
--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)

March 22, 2015 at 9:42 pm

#1785605
RE: Common Mistakes

Eric M Russell (3/20/2015)
Chris Harshman (3/20/2015)
Eric M Russell (3/20/2015)
One thing that SQL Server could use is function based indexes, so we can index on something like CAST(SALESDATE AS DATE) 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)

March 22, 2015 at 8:50 pm

#1785603
RE: the Size of DB became very big , any idea to cut it to smaller

Jeff Moden (3/21/2015)
wagdy_maher (3/21/2015)
its DB for online system ,I can take it down for one hour in the week end
it's normal single server no HA till now
Data...
--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)

March 22, 2015 at 8:43 pm

#1785602
RE: Sql Insert in Batches

Eirikur Eiriksson (3/22/2015)
er.mayankshukla (3/13/2015)
Hi Experts,
I use Batch wise delete in my procedures as they help me to reduce log size.
As we know the deletes causes ghost records, so commiting...
--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)

March 22, 2015 at 8:12 pm

#1785600
RE: Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

I've never had a performance problem because of such switches but if I were forced at gunpoint to make a conjecture, I would unfortunately still have to say I don't...
--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)

March 22, 2015 at 8:05 pm

#1785598
RE: Finding Beginning Date from multiple lines of date ranges

Thanks, Eirikur, but the brilliance is not mine. I'm just translating the work of the truly brilliant Itzik Ben-Gan.
Speaking of brilliant, using CHECKSUM() to convert the VARCHAR(30) ID 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)

March 22, 2015 at 7:58 pm

#1785596
RE: Using WHILE to avoiding Cursor

My pleasure, good Sir. Thank you for the feedback.
My question now is do you have any questions about how the solution I provided actually works?
--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)

March 22, 2015 at 2:19 pm

#1785585
RE: Finding Beginning Date from multiple lines of date ranges

As a bit of a sidebar, storing the "guaranteed to be 7 digits" ID in a VARCHAR(anything) data-type is not what I would do. At the very least, 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)

March 22, 2015 at 1:34 pm

#1785583

Viewing 15 posts - 21,211 through 21,225 (of 59,098 total)