Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,166 through 36,180 (of 59,067 total)

RE: Looping with out While or Cursor

SwePeso (10/31/2010)
I have a solution which yields this statistics
Table 'Worktable'. Scan count 1, logical reads 1, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0,...
--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)

October 31, 2010 at 10:34 am

#1244640
RE: Looping with out While or Cursor

WayneS (10/30/2010)
Jeff Moden (10/30/2010)
Ya beat me to it by a long shot. Well done.
Thanks. I've got just five words to say... "SQL Server MVP Deep Dives[/url]"
Oddly enough, I just...
--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)

October 31, 2010 at 10:17 am

#1244637
RE: table variable inside a cursor

SwePeso (10/30/2010)
Kevin Bullen (10/30/2010)
If the cursor iterates 1000 times, are 1000 instances of a table created, or is the same instance released and recreated.
Neither.
SQL Server is smart enough to move...
--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)

October 31, 2010 at 10:12 am

#1244635
RE: Group "Overlapping" Dates

SwePeso (10/31/2010)
I think Jeff means extending date ranges.
If you have three date ranges
20100101-20100630, 20100515-20100930 and 20100928-20101010,
the end result is 20100101-20101010.
That would be a separate article I was going to work...
--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)

October 31, 2010 at 10:07 am

#1244633
RE: Group "Overlapping" Dates

WayneS (10/30/2010)
Jeff - what do you mean by "overlapping" dates, and how does this differ from determining gaps/islands?
(If it's different, we probably ought to add one for each of those.)
It's...
--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)

October 31, 2010 at 10:02 am

#1244632
RE: table variable inside a cursor

Kevin Bullen (10/30/2010)
Question for the experts.
In reviewing code written by a contractor, they declare a table variable inside a cursor, but it is never used. The cursor itself can...
--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)

October 30, 2010 at 3:30 pm

#1244574
RE: Looping with out While or Cursor

Ya beat me to it by a long shot. Well done.
Oddly enough, I just wrote an "SQL Spackle" on the same subject.
--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)

October 30, 2010 at 3:09 pm

#1244571
RE: Writing Nearly Codeless Apps: Part 4

@david-2 Ziffer
I have a question based on the following snippet from the article...
The reader may question why the application should pass the audit date at all; why not just have...
--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)

October 30, 2010 at 9:13 am

#1244543
RE: Writing Nearly Codeless Apps: Part 4

RobertYoung (10/29/2010)
ron.buchanan.us (10/29/2010)
careusa2003 (10/29/2010)
I would not touch this design with a 10-foot pole.
If you are going to insult a design of which you know little about, at least elaborate. I...
--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)

October 30, 2010 at 8:58 am

#1244539
RE: how to check maximum dates in the csv files and insert into the sql tables using ssis

viky2010 (10/29/2010)
how to check maximum dates in the csv files and insert into the sql tables using ssis.
Example
viky, 20-10-2009
raj ,29-09-2006
kiran,09-09-2005
maximum date is 20-10-2009
So only viky and 20-10-2009 rows...
--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)

October 30, 2010 at 8:49 am

#1244537
RE: SQL Server Breaks down for every 10mins

I certainly could be wrong but, from the following entry in the log you posted, it looks like something may be starting up on the server BEFORE SQL Server...
--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)

October 30, 2010 at 8:41 am

#1244536
RE: SQL Server Breaks down for every 10mins

GilaMonster (10/29/2010)
p.s. The last integrity check of any of these databases was almost 2 years ago. You like living dangerously?
That actually brings up a good subject. Do you happen...
--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)

October 30, 2010 at 8:09 am

#1244530
RE: Sr level interview questions

PaulB-TheOneAndOnly (10/29/2010)
Don't put in your resume anything that can be used against you or better rephrasing it: don't lie to the extend that your CV is your death warrant.
Or, as...
--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)

October 30, 2010 at 7:52 am

#1244529
RE: Sr level interview questions

GilaMonster (10/29/2010)
Alvin Ramard (10/29/2010)
I've seen someone score 4/10 in an interview for a DBA position. All the questions were either based on something in his resume, or based on...
--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)

October 30, 2010 at 7:49 am

#1244528
RE: Count the number of rows with same last part

Nah... I've seen your code on other threads. I just got lucky here. If the data had 5 elements, our code would have been a whole lot more...
--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)

October 30, 2010 at 7:46 am

#1244526

Viewing 15 posts - 36,166 through 36,180 (of 59,067 total)