Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,016 through 36,030 (of 59,102 total)

RE: How to monitor and resolve deadlock in SQL 2005 ?

phuong.nguyen-1008376 (11/17/2010)
Thank for response,
But I don't know what is it deadlock on objects, therefore can't resolve it
Can you help full ?
phuongnh
The best way for me to be helpful in this...
--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 18, 2010 at 8:04 pm

#1252829
RE: Use of temp table

ps. (11/18/2010)
Temp tables are created in tempdb just like you create any other table in your user database. Only difference is it will be destroyed when u disconnect (Prefixed 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)

November 18, 2010 at 8:00 pm

#1252828
RE: Use of temp table

virender.singh (11/18/2010)
I know that temp tables are created in tempdb by default and automatically dropped on session close.
he was telling that there would be more logging, caching etc. in...
--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 18, 2010 at 7:57 pm

#1252827
RE: How to Monitor for High CPU utilization in SQL Server

Boxer (11/18/2010)
Jeff Moden: Yes, we can
Cool! I'll have to give it a try. In the meantime, someone should write an article on 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)

November 18, 2010 at 7:52 pm

#1252826
RE: Sending E-Mail from SQL 2008 Express

Jeff Moden (11/4/2010)
I have to ask because I just don't know... Hopefully, one of you do. Is CDONTS and sp_OA* available in SQL Server Express?
Anyone?
--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 18, 2010 at 7:48 pm

#1252824
RE: Do I need more free space on drive for tempdb?

And whatever you do, don't ever enable auto-shrink on any database... ever. 😉
--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 18, 2010 at 7:44 pm

#1252823
RE: Gap in Dates

GrassHopper (11/18/2010)
1 hour 43 mins running time.
For which method???
--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 18, 2010 at 7:36 pm

#1252821
RE: FLATTEN OUT ROW BASED STRUCTURE TO COMMA DELIMITED

LutzM (11/18/2010)
BaldingLoopMan (11/18/2010)
Thanks Moe. What is this BUMP u speak of.
A post with nothing but the word "bump" in it.
Usually used to bring the post back on the "most recent"...
--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 18, 2010 at 7:33 pm

#1252820
RE: column value balancing (copy previous value <> NULL)

WayneS (11/18/2010)
Dick Herberts-320552 (11/18/2010)
Hi Wayne and other techies,
Today i tested Wayne's routine on a table with 20.000.000 records. In total 6 columns are calculated and updated by Wayne's routine and...
--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 18, 2010 at 7:27 pm

#1252819
RE: Space used by NULL value in different data type columns

My understanding is that you want to find out if there's a difference if between a normal column and after you make it a sparse column. The easiest way...
--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 18, 2010 at 6:31 am

#1252458
RE: Repeate values

I suspect the second bit of code below is exactly what you want...
--===== Without Codigo
SELECT Nombre, Apellido, MinTipo = MIN(Tipo)
FROM #MyTable
GROUP BY Nombre, Apellido
;
--=====...
--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 18, 2010 at 5:04 am

#1252408
RE: column value balancing (copy previous value <> NULL)

Don't be surprised if you find the method works on heaps, as well.
Nice job, though, guys. 🙂
--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 17, 2010 at 10:03 pm

#1252272
RE: Burned Out?

Jack Corbett (11/15/2010)
So how do you handle it when you feel a bit burned out/overwhelmed?
Without looking at the other posts first, I'd say you need to do three things...
1. ...
--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 17, 2010 at 9:51 pm

#1252269
RE: Use of temp table

virender.singh (11/17/2010)
I have query which is using 4 temporary tables for some internal caluclation.
My doubt here is should i use temporary tables or should i use physical tables keeping
in...
--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 17, 2010 at 9:42 pm

#1252266
RE: How to monitor and resolve deadlock in SQL 2005 ?

Lookup "Troubleshooting Deadlocks" in Books Online. They have a better writeup there than I could give you here.
--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 17, 2010 at 9:36 pm

#1252264

Viewing 15 posts - 36,016 through 36,030 (of 59,102 total)