Jeff Moden

Forum Replies Created

Viewing 15 posts - 51,226 through 51,240 (of 59,098 total)

RE: What kind of DBA are you?

Mike Menser (4/8/2008)
Also, 'SEQUEL' has prevailed over the competition in this instance.
Heh... that's probably why I'll continue to use S-Q-L... 😛
--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)

April 8, 2008 at 6:19 am

#799673
RE: Truncate can be rollbacked or not?

Truncate can be rolled back within an explicit transaction just as Adam said... try it on a table that can easily be rebuilt like a Tally 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)

April 7, 2008 at 10:50 pm

#799536
RE: Changing tables names to lowercase

Google for sp_MSForEachTable...
--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)

April 7, 2008 at 10:27 pm

#799532
RE: What kind of DBA are you?

rbarryyoung (4/7/2008)
It was an exciting time, but it's got nothing on today. Seriously, living in the future rocks.
The past "rocks", too... had to use rocks because the Abacus hadn't...
--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)

April 7, 2008 at 9:41 pm

#799529
RE: Back door on Information_Schema

Heh... I gotta agree with that...
Moot point now, though... I just found out that they want to aggregate the aggregates in these views across the databases. Gotta trade in...
--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)

April 7, 2008 at 9:21 pm

#799524
RE: T-SQL Help

Ummm... be very careful using CROSS APPLY... it's just another way of making a "correlated subquery" which qualifies as RBAR and can be very slow.
--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)

April 7, 2008 at 8:51 pm

#799520
RE: SUBSELECT to string

I'm pretty sure recursion will be a performance killer here... please check out the XML code at the following URL (last bluish/purple code box in the article)...
http://www.sqlservercentral.com/articles/Test+Data/61572/
--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)

April 7, 2008 at 8:48 pm

#799519
RE: Need to return the result of dynamic execution to a variable

Forgive me for doing just a quick scan of the threads... couldn't you use the Information_Schema views for this?
--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)

April 7, 2008 at 8:46 pm

#799517
RE: Hundreds of strange system stored procedures - replication related?

Um.... if it's not a 3rd party application, check the "Model" database... sp_MSrepl_PAL_rolecheck is a sproc from the Master database and shouldn't exist anywhere else.
Compare what's in the sp_MSrepl_PAL_rolecheck sproc...
--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)

April 7, 2008 at 8:41 pm

#799516
RE: Finding open records over time without loop

pauls2 (4/7/2008)
One of these days I'll actually recognize for myself when to use a tally table 😀 I have one built but didn't think to use it. ...
--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)

April 7, 2008 at 8:27 pm

#799513
RE: Finding open records over time without loop

mrpolecat (4/7/2008)
build your numbers table ( I call mine tally because Jeff Moden does:D.
Now, there's a heck of a compliment. 😀 Thanks, MrPoleCat!
--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)

April 7, 2008 at 8:22 pm

#799512
RE: Optimizing SQL Query

Grant Fritchey (4/7/2008)
By the way, from what I can see, GetMatricule is going to force the query to function like a cursor, running this select statement for each row in...
--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)

April 7, 2008 at 8:14 pm

#799510
RE: T-SQL Help

Uh, huh... several different ways in the following URL along with some performance pit-falls to avoid...
http://www.sqlservercentral.com/articles/Test+Data/61572/
--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)

April 7, 2008 at 8:02 pm

#799508
RE: Back door on Information_Schema

It would be an aggregate query to sum all the CDRs (Call Detail Records for Telephone Billing) for a about 120 thousand customers in a 4-5 million row 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)

April 7, 2008 at 7:57 pm

#799507
RE: Back door on Information_Schema

Steve Jones - Editor (4/7/2008)
Yikes!
Just put it in the Version Control script for database creation 🙂
Hi Steve,
As with Matt, I always appreciate it when you jump in on one 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)

April 7, 2008 at 6:13 pm

#799487

Viewing 15 posts - 51,226 through 51,240 (of 59,098 total)