Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,031 through 39,045 (of 59,098 total)

RE: Getting decent sql server performance despite a slow drive

Paul White NZ (4/6/2010)
We do not have enough information to say how Marts time should be best spent, and Marts has already said that he is converting to set-based code...
--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)

April 6, 2010 at 6:10 am

#1146411
RE: Can We Skip the Marketing?

Heh... now we know why I don't go to TechEd and all those other "great" Microsoft events. I got a gut full in the late 90's. I got...
--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)

April 5, 2010 at 9:57 pm

#1146271
RE: how can i do this convert

Bhuvnesh (4/5/2010)
Another approach
CREATE FUNCTION [dbo].[uf_utl_SplitNString]
(
@InStr nvarchar(max) = null ,
@token nvarchar(4000) = ','
)
RETURNS @RtnElement TABLE ( item nvarchar(4000))
AS
BEGIN
declare @pos int, @tokenlen...
--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)

April 5, 2010 at 9:47 pm

#1146263
RE: Getting decent sql server performance despite a slow drive

Marts (4/5/2010)
There were a bunch of triggers that used cursors eeep, I changed them to use while loops at least,
Stop. It's a waste of time to do that. ...
--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)

April 5, 2010 at 9:42 pm

#1146260
RE: Adding zero's to int

CirquedeSQLeil (4/5/2010)
Jeff Moden (4/5/2010)
if 234 is 02:34 then why on Earth would 1 be anything but 00:01???? :blink:
Nice catch there Jeff.
Heh... but still the OP has not replied on 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)

April 5, 2010 at 9:38 pm

#1146257
RE: Double-Entry Bookkeeping for SQL Programmers

Tom.Thomson (4/5/2010)
Maybe we both have the same sort of warped mind?
Heh... 'zactly. And from what I've seen from your two folks posts in the past, it's not a bad...
--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)

April 5, 2010 at 9:37 pm

#1146255
RE: I don't know how to do it :(

COldCoffee (4/5/2010)
Exactly Jeff!!
When the OP is unclear then we are explicitly type-casted to be unclear 😀 :w00t:
Heh... what I'm suggesting is that you add the link for the article 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)

April 5, 2010 at 9:35 pm

#1146254
RE: Update current period data based on previous period data

I'm also thinking that you didn't read the article on "Triangular Joins" whose link I posted. I strongly recommend you do before you implement the code... you stand 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)

April 5, 2010 at 9:29 pm

#1146252
RE: Update current period data based on previous period data

yingchai (4/5/2010)
Paul White NZ (4/5/2010)
:ermm: Not a running total problem.
CREATE TABLE Sample1
(
product_id CHAR(7) NOT NULL,
...
--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)

April 5, 2010 at 9:23 pm

#1146248
RE: Triiger On Insert

nilesh k (4/5/2010)
Delete + Insert is as per the business logic so that can not be changed.
This is such a terrible idea that I have to ask. What 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)

April 5, 2010 at 9:19 pm

#1146243
RE: Test

Heh... "It depends". 😛
--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)

April 5, 2010 at 9:15 pm

#1146241
RE: Get Date only from getdate() function

wallace.dave (4/5/2010)
I thnk it is a good solution if you work (like me) in an environment where you must try wherever possible to adhere to cross platform standards - I'm...
--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)

April 5, 2010 at 9:14 pm

#1146240
RE: XCOPY depreiated, use ROBOCOPY

Lynn Pettis (2/9/2010)
I have found that XCOPY has been depreciated in Windows Server 2008 and we should be using ROBOCOPY.
Can anyone point me toward more documentation on ROBOCOPY? 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)

April 5, 2010 at 9:03 pm

#1146228
RE: Cause of a lock being placed on the database

Bill Kline-270970 (4/2/2010)
We have a third-pary application and the users are complaining about performance.
...
Can someone enlighten me?
Yes... it seems that everyone approaches the problem of 3rd party code incorrectly......
--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)

April 5, 2010 at 9:00 pm

#1146224
RE: how can i do this convert

Here's the necessary tweek to cfradenburg's good code to make it work without surprises...
declare @param1 nvarchar(10)
set @param1 = '4,8,12'
declare @current_datetime datetime
set @current_datetime = getdate()
declare @get_min varchar(2)
select @get_min = datepart(mi,@current_datetime)
if patindex('%,'+@get_min+',%',','+@param1+',')...
--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)

April 5, 2010 at 8:54 pm

#1146222

Viewing 15 posts - 39,031 through 39,045 (of 59,098 total)