Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,281 through 38,295 (of 59,098 total)

RE: Deadlock!!!!! plz help

sanketahir1985 (5/21/2010)
it depends on amount of data
but developers have taken care of that thing ,they have used some threading concept in which it checks for thread if it 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)

May 21, 2010 at 8:03 am

#1170845
RE: Crosstab Query

Thanks for the test data... I'll take a whack at it after I get home from work tonight.
--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)

May 21, 2010 at 7:49 am

#1170831
RE: Deadlock!!!!! plz help

Heh... does your stored procedure take less than 5 seconds to run? If it does, then yes, either Leo's pass-through view or my synyonm swap should do the trick...
--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)

May 21, 2010 at 12:15 am

#1170601
RE: Create temp table with from existing table adding a new column

... and, let's say you wanted COL7 to be a NOT NULL INTEGER column...
SELECT COL1, COL2, COL2 , COL4, COL5, COL6, ISNULL(CAST(0 AS INT),0) AS COL7
...
--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)

May 21, 2010 at 12:06 am

#1170599
RE: I almost posted a question today to a forum

Lowell (5/20/2010)
So I almosted posted a topic today,but as i was typing the question, putting in the sample code to demonstrate my mental block, I stopped because my own quesiton...
--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)

May 20, 2010 at 11:46 pm

#1170596
RE: Crosstab Query

BSavoie (5/20/2010)
Yea, that's what I need alright. In my situation, it looks like I would essentially create my month counters in the same way the PIVOT example creates the employeeId...
--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)

May 20, 2010 at 11:22 pm

#1170590
RE: Deadlock!!!!! plz help

Leo is spot on. Truncating a permanent table that's "in service" will always cause some sort of a problem in the future.
In SQL Server 2005 and up,...
--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)

May 20, 2010 at 11:17 pm

#1170585
RE: SQL to manipulate rows of data

Not to worry... and thanks for the feedback. 🙂
If you want to learn more about the dynamic SQL Cross Tab I used, please see the following articles. Of...
--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)

May 20, 2010 at 10:54 pm

#1170581
RE: Getting most common value from several fields into one record

Details are in the comments folks. Heh... ya wanted to get rid of "repeating code", right?
--===== Conditionally drop the test table. It makes reruns easier
...
--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)

May 20, 2010 at 10:35 pm

#1170575
RE: Getting most common value from several fields into one record

elutin (5/20/2010)
I would create aggregate CLR function for this in C#.
Cool... lets see it.
--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)

May 20, 2010 at 8:11 pm

#1170562
RE: Which path to choose (DB Developer Vs DBA)?

Suresh Kumar-284278 (5/20/2010)
Hi All,
I am currently in a dilemma of choosing my career path. I have been doing DB Developer role (SP writing, Query Tuning etc) for the past 5...
--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)

May 20, 2010 at 8:09 pm

#1170561
RE: Simple Update using three tables. . .

donato1026 (5/20/2010)
Lowell (5/20/2010)
Donato this is how i usually update a table from multiple sources...note the commented SELECT statement so i can run the bottom portion to test before and after:
SET...
--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)

May 20, 2010 at 7:39 pm

#1170556
RE: Concatenation Error

Jdoggz (5/20/2010)
Can anyone tell me what's wrong with this query:
Select (sum(Datediff(HOUR,clkIn, clkOut))+ ':' + sum(Datediff(MINUTE,clkIn, clkOut))) as "Total Hours" from History WHERE CONVERT(CHAR(10),clkIn,1) = '05/20/10'
I get the following...
--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)

May 20, 2010 at 7:16 pm

#1170546
RE: How to default Zero-length string to NULL ?

Take a look in Books Online at the NULLIF() function. It may not help directly for the load into your staging table (you do have a staging table, 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)

May 20, 2010 at 6:19 pm

#1170538
RE: How to count left side nodes and right side nodes for managing a chain link(binary tree)application

Joe Celko (5/20/2010)
Let's make a simple cycle:
INSERT INTO AdjTree VALUES ('foobar', 1, 1);
Damn. I knew I was forgetting something. Thanks, Joe.
We also need to compel a root with...
--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)

May 20, 2010 at 6:01 pm

#1170533

Viewing 15 posts - 38,281 through 38,295 (of 59,098 total)