Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,616 through 36,630 (of 59,072 total)

RE: I need some help with a test, please.

Paul White NZ (9/20/2010)
mazzz (9/20/2010)
I would like to help - is the latest code that Jeff would like us to run in the original post?
My understanding is that Jeff welcomes...
--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)

September 20, 2010 at 6:04 am

#1223941
RE: Query tweak required

Bhuvnesh (9/19/2010)
WayneS (9/17/2010)
Probably not what you're looking for, but how's this?
Select top 5 'MY DATABASE TABLE: ' = name
from sysobjects
where xtype = 'u'
order by 1 desc
Thanks...
--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)

September 19, 2010 at 11:15 pm

#1223802
RE: Put logic inside Execute SQL Task or call sproc?

Craig Farrell (9/19/2010)
My preference has, and almost always will be, SPROC if there's logic involved if I can get away with it. Primarily so that I only have to...
--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)

September 19, 2010 at 11:09 pm

#1223797
RE: Anyone know where the MS Auditing tool is?

I agree... I think that every DBA worth a salt has their own private bag o' tricks in this area especially those good folks (like Gail) that make a living...
--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)

September 19, 2010 at 11:03 pm

#1223795
RE: SQL Server DB Tools

As a side bar (and, NO, I'm not a RedGate employee or salesperson), I will tell you that I've used the RedGate Backup software and between its compression abilities 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)

September 19, 2010 at 10:44 pm

#1223792
RE: SQL Server DB Tools

swethak13 (9/19/2010)
Is there any standard approach in the ways to administer the SQL Server databases. As I am new and have no experience in these I don't know where to...
--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)

September 19, 2010 at 10:26 pm

#1223790
RE: I need some help with a test, please.

Crud... I did it again. I've got to get some shuteye. I'll see you folks in about 8 hours or so. Thanks again for everyone's help. ...
--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)

September 19, 2010 at 10:17 pm

#1223789
RE: I need some help with a test, please.

Ah... one more thing, Brad. Would you run that latest code in both your 2k5 and your 2k8 environments so we have exactly apples-to-apples to compare with? Much...
--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)

September 19, 2010 at 10:15 pm

#1223788
RE: I need some help with a test, please.

By the way, Brad... that's one heck of a nice 4 x 4 you have for a laptop. 🙂
--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)

September 19, 2010 at 10:12 pm

#1223787
RE: I need some help with a test, please.

Brad Schulz (9/19/2010)
It was written tongue-in-cheek, but I was trying to demonstrate a real-world scenario. The Tally table approach is sure fast when you're just stripping a list, but once...
--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)

September 19, 2010 at 10:08 pm

#1223786
RE: I need some help with a test, please.

Brad Schulz (9/19/2010)
...then everything changes.
If I try the above with the SPlit8KTally function and the Split8KXMLBrad function and the Split8KL1 function, I get the following results from the SET STATISTICS...
--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)

September 19, 2010 at 10:00 pm

#1223784
RE: I need some help with a test, please.

Brad Schulz (9/19/2010)
but once you actually USE that list to do something (i.e. lookup the ID's in a table), then it becomes a pig,
First, thanks for the test runs,...
--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)

September 19, 2010 at 9:21 pm

#1223781
RE: (sql 2008) t-sql concurrency question.

Barkingdog (9/19/2010)
Case closed.
Actually, it might not be a closed case just yet. Do you know how to use the increment external to the code we wrote to handle 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)

September 19, 2010 at 8:56 pm

#1223776
RE: (sql 2008) t-sql concurrency question.

It's the "simple" things that kill people's code. The folks at the company I was telling you about spent hundreds of thousands of dollars on multiple consultants and 3rd...
--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)

September 19, 2010 at 8:52 pm

#1223775
RE: Transform Data / Duplicate Records on the Fly

Ok... NP. Fire off a flare if you run into a buzz saw.
--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)

September 19, 2010 at 8:43 pm

#1223773

Viewing 15 posts - 36,616 through 36,630 (of 59,072 total)