Jeff Moden

Forum Replies Created

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

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
RE: How to Monitor for High CPU utilization in SQL Server

dukedba (11/17/2010)
Why is it so complicated? You should use resources available in MS SQL server to monitor bottle neck: CPU, Hard drive, Memory, and Network. Use Perfmon 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)

November 17, 2010 at 9:32 pm

#1252262
RE: Pivot Query Question

joshtheflame (11/14/2010)
Jeff thank you for your reply. Well all the tasks will appear with 0 if the data is NULL for any day. Yeah I want to display the TOTAL...
--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:14 pm

#1252259
RE: Delete old rows from all tables in a database

JamesGibb (11/15/2010)
No, it REALLY IS useless, after more than a few hours to some peoples mind, but definitely after two weeks. It's only needed for drawing graphical trends...
--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:07 pm

#1252256

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