Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,841 through 30,855 (of 59,101 total)

RE: Multiple count() in a single SQL

You added "IO" to the mix, Lynn. Probably not a bad thing to do. Thank you, Sir. The "Physical Reads" are a bit ironic.
--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)

March 6, 2012 at 11:16 pm

#1455742
RE: Multiple count() in a single SQL

Ok folks. First, I'm going to refer everyone to the article on "Converting Rows to Columns". If you haven't read it before, now would be a good time...
--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)

March 6, 2012 at 10:54 pm

#1455739
RE: Multiple count() in a single SQL

siva 20997 (3/6/2012)
I have my own theorey whay this is so fast, but I like others comment first P
It's because of a thing that Peter Larsson coined the phrase for......
--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)

March 6, 2012 at 10:28 pm

#1455729
RE: Multiple count() in a single SQL

I just know I'm going to regret getting involved with this one. 😛 Testing in progress...
--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)

March 6, 2012 at 9:31 pm

#1455724
RE: TRIM, REPLACE, STR, or Use a Shotgun to the SSN field???

SQL_Enthusiast-AZ (3/5/2012)
I need to write a report for HR. The report needs a whole lot of data including the last four of the SSN. However, they have thrown me 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)

March 6, 2012 at 9:28 pm

#1455723
RE: TRIM, REPLACE, STR, or Use a Shotgun to the SSN field???

CELKO (3/5/2012)
Why are you formatting data in the back end? The basic principle of a tiered architecture is that display is done in the front end and never 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)

March 6, 2012 at 9:26 pm

#1455722
RE: Problem to write Special Function

It's a long thread so you've probably missed it, Lynn. He's trying to get rid of the current GUIDs and he thinks he want's to do it using an...
--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)

March 6, 2012 at 9:22 pm

#1455721
RE: Zettabyte

Heh... so THAT's what's causing the beach errosion! Chip makers! 🙂
--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)

March 6, 2012 at 9:06 pm

#1455717
RE: Need Help

jack_kiran (3/6/2012)
I would like o find out the application user while executing the query.
Lynn's suggestion is fine if you want to look at it externally. If you want...
--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)

March 6, 2012 at 9:02 pm

#1455716
RE: Constant Deadlocks on Production

ssdba (3/6/2012)
Do we have any major tradeoffs for implementing read_committed_snapshot?? or will it work just fine.
As Michael stated, it can solve a wealth of sins. Just make sure 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)

March 6, 2012 at 8:58 pm

#1455715
RE: TSQL Challenge 77-Transform monthly resource efforts to weekly actuals

Heh... when they delete the SPAM post, are you going to also delete the quote or perpetuate the SPAM? 😉
--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)

March 6, 2012 at 8:50 pm

#1455714
RE: Using table result within a script

JayWinter (3/6/2012)
My intent is to retrieve the last 5 records in the table by first sorting the table in descending order:
ORDER BY
ROW_NUMBER() OVER(ORDER BY RETAIL_SALES.YR
,RETAIL_SALES.MO, RETAIL_SALES.WK ASC) DESC
Now the bottom...
--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)

March 6, 2012 at 8:48 pm

#1455713
RE: Large table cleanup with minimal locks

ChrisTaylor (3/6/2012)
jay.dunk (3/6/2012)
I do something similar on a 24/7 db, 365 days a year with all files on a single raid 5 partition!?! I use the same approach but 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)

March 6, 2012 at 8:31 pm

#1455710
RE: Large table cleanup with minimal locks

cfradenburg (3/6/2012)
jberg-604007 (3/6/2012)
can't index a table variable
But you can declare a primary key which does have an effect on how the query is processed.
Just to add to that, you can...
--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)

March 6, 2012 at 8:10 pm

#1455706
RE: Large table cleanup with minimal locks

Eric1972 (3/6/2012)
I use CTE's to accomplish these type of delete and or archive tasks.
For example:
WITH AuditRecordsToArchiveTop10000 AS (
SELECT TOP 10000 *
...
--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)

March 6, 2012 at 8:07 pm

#1455703

Viewing 15 posts - 30,841 through 30,855 (of 59,101 total)