Jeff Moden

Forum Replies Created

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

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

Gary Varga (12/23/2013)
At the time I was working with a manager who was hiring and, therefore, trawling through a huge number of CVs and conducting a large number of interviews....
--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:32 am

#1675559
RE: Are the posted questions getting worse?

L' Eomot Inversé (12/23/2013)
I've been having a strange problem for the last few days, roughly speaking internet access to USA sites has been almost impossible: average proportion of lost packets...
--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:20 am

#1675554
RE: Will SQL Server 2014 Support to Read BLOB (Byte Array)

yuvipoy (12/23/2013)
David Burrows (12/19/2013)
DECLARE @test varchar(max) SET @test = CHAR(1)+CHAR(87)+CHAR(179) SELECT CAST(CAST(SUBSTRING(@test,1,3) as varbinary(3)) as int)
how do u made CHAR(1)+CHAR(87)+CHAR(179) on which factor u decide if it is a...
--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:15 am

#1675552
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

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