Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,366 through 43,380 (of 59,098 total)

RE: TempDB mdf file has grown to 11GB

Jeff Moden (6/17/2009)
Carl Federl (6/17/2009)
MS does recommend a SQL Server restart as documented at "How to shrink the tempdb database in SQL Server" http://support.microsoft.com/kb/307487
There is also this note:
If tempdb...
--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 17, 2009 at 8:47 am

#1011005
RE: TempDB mdf file has grown to 11GB

Carl Federl (6/17/2009)
MS does recommend a SQL Server restart as documented at "How to shrink the tempdb database in SQL Server" http://support.microsoft.com/kb/307487
There is also this note:
If tempdb is 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)

June 17, 2009 at 8:35 am

#1010982
RE: pivot or cross tab assistance

Rich96 (6/17/2009)
-Jeff
Unfortunately I'm dealing with a 3rd party vendor that could not process the normalized table. In fact I've had to convert all my alphanumeric fields to ASCII..
Heh... been...
--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 17, 2009 at 8:32 am

#1010979
RE: Code Shortcuts

By the way... the code windows still don't work well with IE. I know a lot of development folks use FF, but the other half uses IE.
--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 16, 2009 at 10:58 pm

#1010634
RE: Code Shortcuts

SQLTeam, Wrox, and a couple of other forums have a "#" button in the menu like, say, the parenthesis you have for the quote code in the current menu. ...
--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 16, 2009 at 9:05 pm

#1010609
RE: Using @@IDENTITY With OUPUT Clause

southwynd (6/16/2009)
I figured it out. @@IDENTITY will not work. This is what I needed to do:
SET @ID = IDENT_CURRENT('Table1 ')
No... IDENT_CURRENT can allow other people "in". Take...
--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 16, 2009 at 8:59 pm

#1010605
RE: average rows between last match

andrewd.smith (6/16/2009)
You might wish to cast to a float or decimal value before calculating the average.
Nicely done, Mr. Smith. 🙂
--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 16, 2009 at 8:57 pm

#1010602
RE: How to concatenate row values?

MissyDaisy (6/16/2009)
Jeff,
I don't know how to get an ascii dump of a string from a particular column so I can't accurately say what characters they are.
Visually, it has spacing wider...
--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 16, 2009 at 8:56 pm

#1010600
RE: Code Shortcuts

Steve Jones - Editor (6/16/2009)
Quick clicks, for example, I typically type the code in, highlight, and then click "code" from the left.
So, why not add a "#" to the menu...
--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 16, 2009 at 8:51 pm

#1010599
RE: how to check if SQL Server is running or NOT

You can simply read a single row from a guaranteed-to-be-present table and then catch the error if it fails. If it succeeds, then everything is working fine including 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 16, 2009 at 8:49 pm

#1010597
RE: How to count the record in between 2 dates

Heh... thanks for the plug, Lutz. 🙂
--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 16, 2009 at 8:43 pm

#1010596
RE: Calculate relative dates in Oracle

Jason Coleman (6/16/2009)
as the dates are stored as numbers....
Anyone point me in the right direction
Thx..
The dates should be stored as the Date datatype. What is the data type...
--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 16, 2009 at 8:40 pm

#1010595
RE: NULL and Unique IDentifier.. :-(

It's simply because that setting only affects comparisons... not the way a UNIQUE index works.
--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 16, 2009 at 8:36 pm

#1010591
RE: Code Shortcuts

Steve Jones - Editor (6/16/2009)
when you post, I think a number of you notice there is a list of shortcuts to the left of the text box. This is not...
--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 16, 2009 at 8:25 pm

#1010588
RE: HOW TO AVOID FUNCTIONS ON MERGE STATEMENTS.

Unless you know for a fact that the server or the columns in the given table are case sensitive, just remove all instances of UPPER. This isn't Oracle. 😛
Unless...
--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 16, 2009 at 8:11 pm

#1010586

Viewing 15 posts - 43,366 through 43,380 (of 59,098 total)