Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,036 through 25,050 (of 59,099 total)

RE: sum of columns based on new group

dwain.c (12/23/2013)
Brilliant Jeff, simply brilliant!
Thanks for the feedback, Dwain but it's not that. It was late and I had to do it with just dip on the table because...
--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)

December 23, 2013 at 5:10 am

#1675548
RE: sum of columns based on new group

ChrisM@Work (12/23/2013)
Isn't this all rather irrelevant though? The source table is denormalised - it contains two types of data, products and subproducts. The output contains two types of data too,...
--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)

December 23, 2013 at 5:08 am

#1675547
RE: request for query hint

DBA12345 (12/22/2013)
Table 1 : custemaildim
emailADDr |||||| SendSurvey
some@gmail.com|||||| N
exam@gmail.com|||||| ...
--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)

December 23, 2013 at 12:28 am

#1675503
RE: New features

KumarVelayutham (12/22/2013)
Refer the summarized features over here.!
http://sqldbatask.blogspot.com/2013/12/sql-server-upgrade-sql2012-features.html
Unfortunately, that's only a partial list. You missed quite a bit.
--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)

December 23, 2013 at 12:21 am

#1675502
RE: Get identity value of all rows inserted

Use the OUTPUT clause. There's much more that it can do (like inserting into another table) so check it out in "Books Online".
insert into DestinationTbl
OUTPUT INSERTED.YourIdentityColumn
select * from...
--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)

December 23, 2013 at 12:16 am

#1675501
RE: sum of columns based on new group

First, let it be known that I'm dead set against creating this type of output which basically forms an EAV. The output of the SELECT within ctePreAgg in 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)

December 22, 2013 at 11:54 pm

#1675500
RE: It’s About the Journey, Not the Exam

I agree. The journey is much more important.
That's where SQLServerCentral comes in and I again have to thank you founders for bringing it into existance. Although the knowledge...
--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)

December 22, 2013 at 10:40 pm

#1675492
RE: Double quotes on Bulk Insert

Luis Cazares (12/22/2013)
Thank you Jeff.
I'm using xml format files as described here: http://technet.microsoft.com/en-us/library/ms187833.aspx
But I really shouldn't have posted so late on friday because I'll return to the office after Christmas...
--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)

December 22, 2013 at 9:35 pm

#1675490
RE: What to look for in Execution plans when a query is slow ?

Grant Fritchey (12/20/2013)
For just getting started, these are the things[/url] that I immediately look at for a plan. Yeah, there are tons more details, but this is the starting point....
--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)

December 22, 2013 at 5:40 pm

#1675484
RE: How to write data from multiple stored procedures(which has parameters) to files using SSIS script task?

etirem (12/20/2013)
http://stackoverflow.com/questions/7095930/how-to-write-data-from-multiple-stored-procedures-to-files-using-ssis-script-tas
Wow! That's pretty lazy.
--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)

December 22, 2013 at 4:07 pm

#1675480
RE: Is a date within multiple date ranges

You're new, so 2 things.
First, "WELCOME!" to these fine forums!
Second, have a look at the first link under "Helpful" links in my signature line below. It will tell 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)

December 22, 2013 at 3:51 pm

#1675479
RE: Recovery Pending Database in SQL server

GilaMonster (12/22/2013)
Jeff Moden (12/22/2013)
navimir (12/22/2013)
Can I delete the secondary data file in emergency mode?
there will be any data loss??
the secondary data file was wrongly created with extension .mdf 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)

December 22, 2013 at 3:23 pm

#1675478
RE: Arcjitecture

I've found that a whole lot of people don't even know what "Books Online" is. Get into SSMS and press the {f1} key to get there. It's 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)

December 22, 2013 at 3:18 pm

#1675477
RE: Validate trigger entries

masoudk1990 (12/22/2013)
Ville-Pekka Vahteala (12/22/2013)
Couple of things.
Can't you just use constraints?
Your posted code seems to assume that there will be just one row coming to trigger, which might not be 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)

December 22, 2013 at 3:16 pm

#1675476
RE: Audit Trail

nainamohamedy (12/22/2013)
I have a database which is used for a web application(not website).
For each web application user, Is it advisable to create separate db user?
Now I have a single...
--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)

December 22, 2013 at 3:12 pm

#1675475

Viewing 15 posts - 25,036 through 25,050 (of 59,099 total)