Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,116 through 50,130 (of 59,102 total)

RE: Making it pivot

SQL Server 2005 allows you to write PIVOT queries. Lookup the keyword PIVOT in Books Online. Books Online comes free with SQL Server and is the "help" system...
--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 12, 2008 at 7:34 am

#827845
RE: Database Growth Settings

Not likely the database did it... either a human or some other program did it. Finding out what changed it will take some doing, though.
Should never grow by percent,...
--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 12, 2008 at 7:32 am

#827843
RE: Remove Locking from particular row

One of the cylinders on my car is misfiring... I can't understand why the mechanic blew me off when I told him he couldn't look under the hood because 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)

June 12, 2008 at 7:29 am

#827837
RE: Algorithm For Email

I'd say that's a pretty tall order unless you have a particular domain in mind that want's particular formatting rules. Then, you could use LIKE to build 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 12, 2008 at 7:23 am

#827828
RE: Dividing count(*) by DateDiff always equals 1

Here's a "cheater" method...
count(*)*1.0/(DATEDIFF(s, MIN(scan_datetime), MAX(scan_datetime))) as ItemsPerSecond
--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 12, 2008 at 7:12 am

#827814
RE: Get date of last Sunday of every month

Ok... now that everyone has figured stuff out... how 'bout everyone post their solutions? 😉
--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 12, 2008 at 7:07 am

#827810
RE: What do you do with a new SQL Server?

I found it... them, really.
http://www.sqlmag.com/Articles/ArticleID/19851/19851/pg/2/2.html?Ad=1
http://www.sqlmag.com/Article/ArticleID/20242/sql_server_20242.html
I'm not a "member" of that particular site so I can't see the whole article. What I glean from the two articles is...
--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 12, 2008 at 6:54 am

#827800
RE: What do you do with a new SQL Server?

AndyD (6/12/2008)
Jeff Moden (6/12/2008)
I remember seeing an article on the difference between 0% and 100% fill factors... Dunno if I can find it, again, but I'll look...
I was only regurgitating...
--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 12, 2008 at 6:43 am

#827795
RE: What do you do with a new SQL Server?

AndyD (6/12/2008)
Yes, I agree, good concise advice.
Just one quick question - you mention the Fill Factor defaults to 100% in 2005, whereas it was 90% in 2000. [To be precise,...
--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 12, 2008 at 6:26 am

#827785
RE: What do you do with a new SQL Server?

Nice, clear, well written article with good advice. 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)

June 11, 2008 at 10:11 pm

#827638
RE: SQL Defrag

Dominique DUCHEMIN (6/11/2008)
To defrag is it always a manual process for safety reason or other or could we automate the process?
Sure... create a scheduled job... you can use SQL Server...
--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 11, 2008 at 9:05 pm

#827627
RE: BETWEEN

... and that's why I hate multiple-guess questions... gimme a good solid essay question or lemme write some code, instead!
That was a fun conversation to watch... thanks, Gents. 🙂
--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 11, 2008 at 8:58 pm

#827625
RE: CLR Table-valued function

Heh... and Marketing.
Nice explanation, Barry!
--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 11, 2008 at 11:53 am

#827444
RE: CLR Table-valued function

rbarryyoung (6/11/2008)
That sounds like a challenge...!
Seriously though, "useful" and "appropiate" were not part of your specs. 🙂 They're a lot harder to fulfill. (Though as Lynn says,...
--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 11, 2008 at 11:48 am

#827439
RE: CLR Table-valued function

Matt Miller (6/11/2008)
Jeff Moden (6/11/2008)
rbarryyoung (6/11/2008)
Well, if we're looking for examples, a Fourier Transform would proabably be a good candidate for CLR.
Heh... ok, I gotta ask... has anyone actually ever...
--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 11, 2008 at 11:43 am

#827436

Viewing 15 posts - 50,116 through 50,130 (of 59,102 total)