Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,906 through 37,920 (of 59,072 total)

RE: Database Sizing

Dunno if anyone else has done it but.... reported.
--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)

June 27, 2010 at 10:18 am

#1185435
RE: Database Sizing

GilaMonster (6/27/2010)
It's a spam post. Content copied from elsewhere, link in sig.
That's what I was starting to think because of other posts of that user.
--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)

June 27, 2010 at 10:15 am

#1185434
RE: Database Sizing

carolwood (6/26/2010)
Hello Friends.....
Sizing a database can be one of the most arduous tasks a DBA, analyst or developer must attend to. It’s time consuming and more hours go into analyzing...
--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)

June 26, 2010 at 9:12 pm

#1185405
RE: Need Expert advice on my sql query for speed improvement

Sergiy (6/26/2010)
Use Wayne's advice for WHERE clause and make sure yout table is built like this:
CREATE TABLE [dbo].[Log_Transactions] (
[LogID] [int] IDENTITY (1,...
--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)

June 26, 2010 at 8:50 pm

#1185404
RE: Kudos to the Community

Boy Howdy! Like Gail and some of the other heavy hitters, I've had to temporarily back way off on the time I can spend on forums and I'm happy...
--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)

June 26, 2010 at 8:42 pm

#1185403
RE: How to Get Random Numbers

@parthi,
Are you all set now?
--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)

June 26, 2010 at 8:28 pm

#1185402
RE: How to Get Random Numbers

Dave Ballantyne (11/27/2009)
The general consensus it that abs(checksum(newid()))%100 is the bettet method to generate random numbers.
Heres an example from my blog
http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/08/27/a-faster-tsql-random-length-random-string-generator.aspx
Nicely done, Dave. Here's a minor modification using...
--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)

June 26, 2010 at 8:27 pm

#1185401
RE: store password and user name

Since HASHBYTES doesn't use any form of encryption key, I'd like to suggest that someone with just a tiny bit of time on a GOOGLE search can easily find 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)

June 26, 2010 at 1:22 pm

#1185385
RE: Performance issues

I second Grant's book.
--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)

June 26, 2010 at 12:55 pm

#1185377
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

jeffwilson2 (6/25/2010)
Hi my name is Jeff.
I am new to this forum. About a year ago I started at a company and last year they upgraded to SQL 2005 and nearly...
--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)

June 26, 2010 at 12:45 pm

#1185375
RE: How to Get Random Numbers

carolwood (6/26/2010)
Hello Friends.......
Generating random numbers is simple. Provided as part of the java.util package, the Random class makes it easy to generate numbers. Start by creating an instance of 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)

June 26, 2010 at 7:55 am

#1185350
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Ah... I feel much better now. I had seen the BOL info before but thought someone had come up with a new bit of info where they weren't replacing...
--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)

June 26, 2010 at 6:48 am

#1185347
RE: Add row number that alternates between groups of numbers

samalex (6/25/2010)
Hi Jeff,
Great article, and yes I can see how running it against a large dataset could take some time. In my scenario though we're just doing a few...
--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)

June 26, 2010 at 6:35 am

#1185346
RE: Add row number that alternates between groups of numbers

Ken McKelvey (6/25/2010)
Try something like:
(SELECT COUNT(DISTINCT AcctNo) FROM @tmpTable WHERE AcctNo<= reg.AcctNo) AS RowNo,
Try that on a single account of, say, 20000 rows and see how long it takes. ...
--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)

June 25, 2010 at 12:18 pm

#1185185
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Thomas-282729 (6/25/2010)
Michael Jenck (6/25/2010)
I have been trying to figure out a way to eliminate the following cursor. I figure this would be a good place to post this seeing...
--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)

June 25, 2010 at 8:01 am

#1185013

Viewing 15 posts - 37,906 through 37,920 (of 59,072 total)