Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,076 through 30,090 (of 59,101 total)

RE: How Do You Verify Sequential Record Numbers.

mcertini (5/12/2012)
Thanks Jeff and Matthew,
I am using extremely large data sets (ie. 66,000,000 records). I will have to test both of these to see how fast they process through...
--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 12, 2012 at 2:02 pm

#1486789
RE: How Do You Verify Sequential Record Numbers.

It wasn't my original idea but here's a method that I've changed a bit over time. It turns out to be similar to Ben-Gan's and is nasty fast when...
--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 12, 2012 at 12:18 pm

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

Lynn Pettis (5/10/2012)
First step in performance tuning a database, ask the users what is slow. That is where you should focus your attention first.
Well said. That's actually one...
--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 12, 2012 at 11:59 am

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

I absolutely do understand about the type of "test" interviews that you're talking about but being nervous under fire is all a part of what it means to be 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 12, 2012 at 11:48 am

#1486780
RE: Technical Interview - I feel dumb now.... :)

125K isn't bad for the DC area.
--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 12, 2012 at 11:37 am

#1486779
RE: A brief overview of mechanisms to "export to excel" - which do you use, which do you prefer?

So, keep a log of the requests and how long they took to resolve. After 6 months or a year, calculate a comparison between handling the ad hoc requests...
--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 12, 2012 at 11:14 am

#1486776
RE: How to manage common tasks

Without network connections between the sites, it would seem that emailing the scripts to build the procs is going to be the only way.
--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 12, 2012 at 11:09 am

#1486774
RE: Teambuilding and Bonding

It's ironic, I think, that the very tools that are supposed to make us more effecient are actually contrary to team building. Ever have the person in the next...
--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 12, 2012 at 11:02 am

#1486773
RE: drive space issues trying to index 2.4TB table

RP_DBA (5/11/2012)
OK, this landed on my desk this morning: user created a 2.4TB table without a Clustered Key. He now wants a clustered key on the table but is unable...
--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 12, 2012 at 10:48 am

#1486772
RE: SSRS Reports RUnnine very slow

logicinside22 (5/2/2012)
Hey guys
any idea or what steps to take if Reports suddenly starts running slow...
Before it was taking less than one minute but now its taking 5...
--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 12, 2012 at 10:35 am

#1486771
RE: Update the description property of a table in SQL Server

apostolis.karayiannis (5/11/2012)
Hello
My problem is the following:
I have a table (table A) that has several columns and each one of those columns has a description on the description property. 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)

May 12, 2012 at 10:00 am

#1486765
RE: does ss2008 maintain an internal timestamp of data updates?

sqlguy-736318 (5/11/2012)
Does SS2008 maintain an internal timestamp of data updates?
For example, if I wanted to select the last 5 rows in a table that were updated is there a T/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 12, 2012 at 9:53 am

#1486764
RE: What are these extra files?

KarenM (5/11/2012)
Could your db have been imported from some other dbms? Might explain those extra files.
Regardless as Steve already advised those additional filegroups can be removed.
Uhm... make sure you...
--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 12, 2012 at 9:44 am

#1486760
RE: rows to columns

The following article explains a couple of methods to change rows to columns. For character data, use MAX instead of SUM.
[font="Arial Black"]Cross Tabs and Pivots, Part 1 – Converting...
--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 12, 2012 at 9:39 am

#1486759
RE: Where clause with view returns super slow!!!

princa (5/11/2012)
Hi All,
I have a query running very wired:
Query:"
Select *
from view1
where score1 > 3.5 and score2 > 6
"
The view1 is a big view which has some sub views 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)

May 12, 2012 at 9:30 am

#1486755

Viewing 15 posts - 30,076 through 30,090 (of 59,101 total)