Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,811 through 24,825 (of 59,102 total)

RE: A few reflections on RBAR by a weary application developer

Tavis Reddick (1/9/2014)
Jeff Moden (12/11/2013)
To tell the truth, though, there should be 0 failures all the time even if the data is bad because the data should be imported into...
--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)

January 9, 2014 at 8:52 am

#1678820
RE: A few reflections on RBAR by a weary application developer

craig 81366 (12/13/2013)
Would you please stop abusing the word exponential.
It really wrecks the credibility of your otherwise valid comments when you get this concept so fundamentally wrong.
The fact is that...
--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)

January 9, 2014 at 8:50 am

#1678818
RE: query giving unexpected results

xp_DirTree returns the names of files AND directories. If you want to count just the files, then you have to include the "secret" 3rd operand for xp_DirTree and then...
--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)

January 8, 2014 at 1:26 pm

#1678573
RE: Why the Delay in TimeStart

The best way would be to write the reports to return the correct timeframe rather than relying on the time that they are executed.
--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)

January 8, 2014 at 1:11 pm

#1678565
RE: Stairway to SQLCLR Level 1: What is SQLCLR?

Solomon Rutzky (1/8/2014)
Just FYI, there is possibly a little glitch in the publishing of the article such that this forum (and its comments) might disappear. If that happens, and...
--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)

January 8, 2014 at 12:56 pm

#1678558
RE: Are the posted questions getting worse?

rodjkidd (1/8/2014)
Weather update, as Grant has discovered it gets dark here very quickly, that and the rain and wind seems to be the story of the week in not 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)

January 8, 2014 at 12:45 pm

#1678552
RE: script to set all user database to simple recovery model

george sibbald (1/8/2014)
if you want to keep it simple and just change recovery model for all user databases run this, copy results to another window and run
select 'alter database ['+name+']...
--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)

January 8, 2014 at 12:42 pm

#1678550
RE: SQL Help needed...

satishchandra (1/8/2014)
The solution from MelroyV, worked for me. Thanks a lot, melroy.
Thank you Sean for your inputs/suggestions.
Your suggested solution was close too, but I was looking for traversed...
--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)

January 8, 2014 at 11:30 am

#1678523
RE: script to set all user database to simple recovery model

Todd Erickson (1/8/2014)
I really liked that script, but, being an efficiency fanatic, I thought I would improve it just a little. Instead of building the SQL statement and then...
--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)

January 8, 2014 at 11:26 am

#1678520
RE: How to artificially fragment an index ?

SQL Guy 1 (1/8/2014)
Yes, it's always backed up periodically.
DBCC shrink file did not help. First, it shrinks entire file which also has other tables. And it shrank just little...
--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)

January 8, 2014 at 11:20 am

#1678519
RE: How to artificially fragment an index ?

george sibbald (1/8/2014)
run a dbcc shrinkfile on it, you'll have all the fragmentation you want.
+1
but not in production 🙂
+1000!!!
--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)

January 8, 2014 at 11:14 am

#1678518
RE: Ensuring stored procedure actually runs with permissions of the caller

Sean Lange (1/8/2014)
When a user has rights to execute a stored procedure it will be assumed that they can do whatever the procedure code does. It does not check privileges...
--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)

January 8, 2014 at 11:10 am

#1678514
RE: optimal indexes for a table that is read frequently

Sridhar-137443 (1/7/2014)
I checked our sql server edition. It is standard edition. So, I don't have option of rebuilding indexes with ONLINE option. If I disable the indexes and enable 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)

January 8, 2014 at 8:29 am

#1678440
RE: Log space

karthik babu (1/8/2014)
The below query gives results omitting information of few databases. Upon going through the results I found that the databases with is_cleanly_shutdown is 1 are missing.
DBCC sqlperf...
--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)

January 8, 2014 at 8:24 am

#1678436
RE: Stairway to SQLCLR Level 1: What is SQLCLR?

VERY nice, Solomon. Great job!
--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)

January 8, 2014 at 8:08 am

#1678430

Viewing 15 posts - 24,811 through 24,825 (of 59,102 total)