Jeff Moden

Forum Replies Created

Viewing 15 posts - 29,986 through 30,000 (of 59,101 total)

RE: New toys in SQL Server 2012

Dan Guzman - Not the MVP (5/15/2012)
I actually ran into an 'Expert' last month who was so proud of himself for not using Cursors, and yet used while loops instead!...
--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)

May 15, 2012 at 3:58 pm

#1488073
RE: How to load a temp table with the result set of a sproc

Absolutely no problem there, Geoff. I actually feel dwarfed by your knowledge of SQL Server in many areas especially on the system side.
Yeah, I remember all the temp tables...
--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)

May 15, 2012 at 8:49 am

#1487776
RE: Daily Comulative Report in SQL Server

abdul.badru (5/15/2012)
Hi All,
Suppose that a have a table in sql server that store sales information ( Product; Date, Qty, Region).
It is possible to write a sql staments to retrivea table...
--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)

May 15, 2012 at 8:37 am

#1487763
RE: ad hoc queries

kwe477 (5/15/2012)
Excerpt from below link:
Ad-hoc query:
created and executed manually through a client. e.g., a user opens up SSMS, writes a query and executes it.
Dynamic queries:
are nothing more than ad-hoc...
--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)

May 15, 2012 at 8:32 am

#1487753
RE: Where are the good Senior Level DBA's?

Michael Valentine Jones (5/15/2012)
That's something that I have given a lot of thought to over the years, and I finally settled into not trying to correct people or give them...
--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)

May 15, 2012 at 8:28 am

#1487749
RE: Exporting reports into excel

vinay4444 (5/15/2012)
Thanks guys
Page Break is for items in same report , I am talking about multiple reports in a project into an excel spreadsheet in different ( with custom tab...
--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)

May 15, 2012 at 8:06 am

#1487717
RE: New toys in SQL Server 2012

I'm not sure why this article is getting such low marks. It exposes some information that a lot of people didn't know about and it does so in 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)

May 15, 2012 at 8:00 am

#1487707
RE: New toys in SQL Server 2012

I think it's fascinating how much value people put on such things as being able to type a 5 letter word like BEGIN and have the machine type a 3...
--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)

May 15, 2012 at 7:55 am

#1487703
RE: Exporting reports into excel

I don't know much about SSRS but I did some digging. There's some suggestion that adding a page break before a report will start a new tab 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)

May 15, 2012 at 7:45 am

#1487690
RE: How to split Delimited text

Gosh... Thanks Dugi. :blush: Mighty kind of you to say so.
--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)

May 15, 2012 at 7:40 am

#1487682
RE: Converting first letter of every word to uppercase

dwain.c (5/14/2012)
Forgive me oh experts for I have sinned. I have not compared performance against other suggestions. 🙂
Since you used a recursive CTE for this task, that may be...
--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)

May 15, 2012 at 7:36 am

#1487677
RE: Are the posted questions getting worse?

GilaMonster (5/14/2012)
Steve Jones - SSC Editor (5/14/2012)
Jack Corbett (5/14/2012)
I haven't done a backup, restore, or anythign with security since I've been there.
Whaaa? No backups of your laptop? None...
--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)

May 14, 2012 at 10:38 pm

#1487524
RE: How to split Delimited text

Sean Lange (4/30/2012)
MaverickMan (4/30/2012)
Thank you all for providing such wide variety of solutions to this problem. Performance is not the need for our problem so it will work with any...
--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)

May 14, 2012 at 10:23 pm

#1487520
RE: import a txt file in sqlserver

marclas (5/10/2012)
hi,
is it possible to import a text file in sql server?
in fact i have a list of data in a text format that i wanted to add to 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)

May 14, 2012 at 8:00 pm

#1487502
RE: import a txt file in sqlserver

Adi@Wrk (5/14/2012)
Another option is to use our (free) app called ClipTable, which, in many cases, saves you a *lot* of headache when trying to import pretty much anything into SQL...
--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)

May 14, 2012 at 7:56 pm

#1487501

Viewing 15 posts - 29,986 through 30,000 (of 59,101 total)