Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,196 through 54,210 (of 59,098 total)

RE: Query times inconsistent

This report is accessing a history table that is constantly being written to by the application,
That would be part of the inconsistency... procs recompile when certain amounts of 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)

November 12, 2007 at 6:14 pm

#750430
RE: sql-dmo object is not destroyed properly

I can't prove it, but apparently you have... I've heard that the sp_OA* procs have a "connection leak"...
Real key here is what do you think you need an sp_AO* string...
--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)

November 12, 2007 at 6:08 pm

#750429
RE: Find all the matches for col1 in col2 and display athe matches in col2 as column seperated values

I don't see any similarity, either, except for the fact that Alicia has, again, not shown anything that she's tried (not to mention the double 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)

November 12, 2007 at 6:00 pm

#750427
RE: conditional aggregate functions?

Ok, I'm not Jeff but I'm gonna take a shot at this anyway
First the question
WeekStart = DATEADD(dd,DATEDIFF(dd,-1,Date)/7*7,-1),
The /7*7 gives you a different number because the 7's are integers....
--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)

November 12, 2007 at 5:56 pm

#750426
RE: How come no one post any job?

Grumpy DBA (11/12/2007)
I guess Henry found a way around paying the posting fee... ha ha...
J Moden - Where in Michigan are you located? I heard about a possible opening...
--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)

November 12, 2007 at 5:07 pm

#750423
RE: INSERT A Record Based on Count

Using the "code" and "/code" tags (you need to include square brackets around those words instead of the double quotes... ). Still sucks for the end user, though, because...
--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)

November 12, 2007 at 5:01 pm

#750422
RE: Select Statements in Stored Procedure gets Error converting data type DBTYPE_DBTIMESTAMP to datetime.

Thanks for the feedback on your solution, Juan...
--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)

November 12, 2007 at 4:56 pm

#750421
RE: The Pace of Information

It's not a good analogy. An unhealthy restaurant will get you sick or dead.
Heh... it's a great analogy... An unhealthy bit of code will make your database sick 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)

November 12, 2007 at 4:52 pm

#750420
RE: The Pace of Information

Are they like restaurants opening without a health inspection?
I couldn't have come up with a better analogy if I tried... there are so many that are absolute rubbish when...
--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)

November 12, 2007 at 7:06 am

#750235
RE: Retrieving the value of the variables dynamically

No, no... I believe a checksum of each row would allow you to check for uniqueness across the 24 columns. Lookup CHECKSUM in BOL...
--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)

November 12, 2007 at 6:31 am

#750221
RE: INSERT A Record Based on Count

Is this a separate request or added requirements to what has been done already?
... and NVL is ORACLE... the equivelant in SQL Server is ISNULL... but why would you 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)

November 12, 2007 at 6:26 am

#750220
RE: Script

Just a different slant on things...
-- DROP TABLE #T
GO
--===== Create a table to store the results in
CREATE TABLE #T
(
...
--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)

November 11, 2007 at 10:40 pm

#750146
RE: SQL JOIN syntax

And, please don't post duplicate posts.... we'll find ya...
http://www.sqlservercentral.com/Forums/Topic420902-145-1.aspx
--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)

November 11, 2007 at 10:09 pm

#750141
RE: SQL JOIN syntax

Duplicate post...
http://www.sqlservercentral.com/Forums/Topic420896-146-1.aspx
--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)

November 11, 2007 at 10:07 pm

#750138
RE: conditional aggregate functions?

Lordy, I hate setting up test data for payroll examples... whatever...
Here's some code that generates 100,000 entries for 200 employes for a year's worth of payroll following your rules...
--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)

November 11, 2007 at 9:30 pm

#750132

Viewing 15 posts - 54,196 through 54,210 (of 59,098 total)