Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,916 through 39,930 (of 59,098 total)

RE: Calculate physical space taken up by certain rows

Make a swag... count the number of rows per month and then extrapolate against the total number of bytes the table and its indexes hold. For example... if 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)

February 5, 2010 at 8:46 pm

#1114904
RE: Cannot Get Average of rowcount: Msg 130, Level 15, State 1, Line 1 Cannot perform an aggregate function on an expression

sgambale (2/4/2010)
create table sg
(EventTime datetime)
insert into sg values('02/01/10 07:17:00')
insert into sg values('02/01/10 07:33:00')
insert into sg values('02/01/10 07:46:00')
insert into sg values('02/01/10 08:10:00')
insert into sg values('02/01/10 08:37:00')
insert into sg values('02/02/10 07:57:00')
insert into...
--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)

February 5, 2010 at 8:37 pm

#1114903
RE: DBCC Timewarp

Actually, if you can restore the next hour's worth of backups now, you can get away with as few as 42 of the parameters.
--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)

February 5, 2010 at 8:15 pm

#1114898
RE: Converting data with apostrophes in it

If you passed the information to a stored procedure instead of using embedded SQL, this problem and some of the security problems that Luke mentioned would simply disappear.
--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)

February 5, 2010 at 8:02 pm

#1114895
RE: xp_cmdshell help needed

The SQL Server service must be logged in as a Domain account that can see the path that you're using xp_CmdShell to point 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)

February 5, 2010 at 7:55 pm

#1114894
RE: Report to be build from Very large amount of data.

If, as you say, the historical doesn't change, then just pre-aggregate it and store it in a reporting table. If you're careful about how it's done, then there's no...
--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)

February 5, 2010 at 7:54 pm

#1114893
RE: Table Variable Issue

amoericke (2/5/2010)
On our actual code (not my test code) we chose to use a hint to force the query to use the index and that works. But I just...
--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)

February 5, 2010 at 7:50 pm

#1114891
RE: What's a Toaster?

Oddly enough, one of my toasters also begins with a "T"... T-SQL. My other toaster is my trusty pork chop launcher... heh... I've only had to change the bands...
--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)

February 5, 2010 at 7:44 pm

#1114890
RE: Commas in Code

I'm pretty much good with the above mostly for readability and because SQL was originally designed to be "English like" which doesn't have commas at the beginning.
People who put commas...
--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)

February 5, 2010 at 7:38 pm

#1114889
RE: Patern Matching

Absolutely no problem... Just wanted to make sure everything was ok with you. Thank you for the come back.
--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)

February 5, 2010 at 7:05 pm

#1114885
RE: Use of a VARCHAR(MAX) in a Non-Clustered Index?

paul.knibbs (1/20/2010)
Jeff Moden (1/16/2010)
If you're using certain other methods to do the hashing (I forget what they're called... MD5???), then the additional checking will not be necessary.
Even with MD5 or...
--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)

February 5, 2010 at 6:39 pm

#1114877
RE: Patern Matching

UT,
It's been a couple of days... how'd all that work out for 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)

February 5, 2010 at 6:05 pm

#1114874
RE: Local Temporary Tables and Table Variables

True enough. You should also mention that most UDFs aren't necessary either. 🙂
--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)

February 5, 2010 at 6:03 pm

#1114873
RE: HUGE Database Update (> 550 million rows)

Brian.Dunat (1/23/2010)
Jeff,
This is the proper clustered index and it makes up the primary key on the table. This is a wealth management database, so the data that will be inserted...
--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)

February 5, 2010 at 5:52 pm

#1114872
RE: how to Split DateTime value in seprate date and time column

dan.hare (7/30/2009)
I didn't explain myself well enough, apologies.
Of course you can choose to report a date/time to whatever level of granularity you want.
Dead easy.
My point was that if you choose...
--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)

February 5, 2010 at 5:40 pm

#1114871

Viewing 15 posts - 39,916 through 39,930 (of 59,098 total)