Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,541 through 39,555 (of 59,098 total)

RE: CLR, to be or not to be, that is the question!

Roust_m (3/3/2010)
Jeff Moden (3/3/2010)
Roust_m (3/2/2010)
Another issue we have with this function is that it fails after few days without SQL instance restart. When we restart it it works until...
--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)

March 3, 2010 at 11:52 pm

#1128291
RE: Query Execution Time Variance

Before you simply "move on"... what would be wrong with simply adding the creation of the correct indexes to the process?
--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)

March 3, 2010 at 11:02 pm

#1128272
RE: Fairly complex SQL - Can it be done better in SP format?

Hi Joe and welcome aboard.
Most folks like to test their code before they post it but don't have the time to build test data to do it with. Keeping...
--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)

March 3, 2010 at 10:58 pm

#1128271
RE: How to create global "database wide" Identity-columns

Personally, I think it would be a much better thing to convince the user of the error of their ways.
--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)

March 3, 2010 at 10:48 pm

#1128267
RE: Performance of functions on group by

Adam Bean (3/3/2010)
Hey all,
Having some troubles here. The query I'm working on takes 34 seconds, which in itself is obviously unacceptable. The indexing is rather good, but can be tweaked...
--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)

March 3, 2010 at 10:41 pm

#1128266
RE: Insert multiple records for a single ID

harshalnag (3/3/2010)
This is actually very similar to a customer-order management system (one-to-many relationship) used on websites like amazon or bestbuy.
Each user can buy what he wants to and check out....
--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)

March 3, 2010 at 10:32 pm

#1128263
RE: Delete everything before updating the table

itskumar2004 (3/3/2010)
Hi ,
Here is the update statement:
update set
deletedate=getdate()
from
dbo.A
where
deletedate is null
and UserID in (select UR.UserID from
...
--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)

March 3, 2010 at 10:27 pm

#1128261
RE: Querying a Table Using Dynamic SQL

Jeff Kring (3/3/2010)
I did look into ROW_NUMBER as an option. I could use it to return the correct rows, but the application needs the actual value as well.
Not sure...
--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)

March 3, 2010 at 10:19 pm

#1128255
RE: A Cheap Fix?

With hardly an exception, my stance is that users who write their own queries should not have access to the production server... period. A separate "report" instance is 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)

March 3, 2010 at 10:02 pm

#1128247
RE: Need help on T-SQL

What ray means is that you simply need to not insert duplicated data.
--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)

March 3, 2010 at 9:45 pm

#1128239
RE: Best Performance SQL Server version

"All the above" depending on what the customer has. It's also not a really good question because of things like the Enterprise Edition of any version is "better" than...
--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)

March 3, 2010 at 9:41 pm

#1128234
RE: Convert Unix Date Time to Julian - DST

{edit} Never mind... misread the post...
--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)

March 3, 2010 at 9:21 pm

#1128228
RE: maximizing sql server memory usage

Nikki-395727 (3/2/2010)
Thanks everyone for the reply.
I knew that this is the best I can do with the current set up but wanted to confirm.
I just feel bad that all our...
--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)

March 3, 2010 at 9:06 pm

#1128226
RE: Database performance down

Paul White (3/3/2010)
For general advice, and a solid methodology that works, read This Microsoft White Paper.
BWAA-HAAA!!! 😛 The very first item in the "Common scenarios to avoid in OLTP"...
--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)

March 3, 2010 at 8:57 pm

#1128220
RE: Reading the .LDF File in Sql server 2005

dakshinamurthy-655138 (3/1/2010)
The objective or the requirement is, we would like to know what all the transactions has happend which is stored in the .ldf file and its contents in .ldf...
--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)

March 3, 2010 at 8:50 pm

#1128219

Viewing 15 posts - 39,541 through 39,555 (of 59,098 total)