Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,011 through 38,025 (of 59,098 total)

RE: divide by 0 or null SSRS

checkai (6/9/2010)
From my understanding, you'll need a function to make sure this is accurate at all times. I have code embedded in every report (in my template).
Public Function DivideBy(ByVal Exp1,...
--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)

June 11, 2010 at 5:27 pm

#1179485
RE: Programming an installation script

Andy Leonard give a pretty good overview in the following...
https://www323.livemeeting.com/cc/usergroups/view?id=W5888W
--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)

June 11, 2010 at 5:26 pm

#1179484
RE: Mentor

scott.pletcher (6/11/2010)
I would think in this situation a single query would be the most efficient. I/O (physical and logical) are the real culprit in performance more than 90% 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)

June 11, 2010 at 4:54 pm

#1179482
RE: Mentor

john-902052 (6/11/2010)
Because I want to get to know the person and go deep with the topic. Here people may or may not answer and only will work against 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)

June 11, 2010 at 4:33 pm

#1179478
RE: Mentor

I don't like those challenges because they teach the wrong thing. There are many times where the resolution of a problem using a single query is just flat out...
--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)

June 11, 2010 at 4:31 pm

#1179477
RE: Best practice for test environment?

If you have a decent SAN, learn how to use the SAN "clone" or "snapshot" feature. We used it to "replace" a Tera-Byte copy of the production databases every...
--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)

June 11, 2010 at 3:25 pm

#1179457
RE: Mentor

Which part of the world do you hail 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)

June 11, 2010 at 3:20 pm

#1179453
RE: Making the leap Sql Sever from Oracle

PaulB-TheOneAndOnly (6/11/2010)forget about the differences in between PL/SQL and SQL*Plus - the beauty of SQL Server is that relies on a single, powerfull T-SQL language.
Excellent point, Paul. I never...
--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)

June 11, 2010 at 3:18 pm

#1179451
RE: Selecting the earliest month wrapping January to December

As a side bar, this thread has taken a bit of a turn for the worse. Everybody be nice, eh?
--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)

June 11, 2010 at 3:07 pm

#1179446
RE: Selecting the earliest month wrapping January to December

scott.pletcher (6/11/2010)
I'll also add what I said before. The data is being inserted in the order of 09, 11, 01 and everyone is just getting lucky with the "sorted" order....
--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)

June 11, 2010 at 3:06 pm

#1179445
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

eq2home (6/11/2010)
Super explanation and it clarifies and identifies a simpler and faster approach to building crosstabs. My hat is tipped to you Jeff - Pick clarity of thought, writing...
--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)

June 11, 2010 at 9:19 am

#1179263
RE: tempdb size

nadia-720162 (6/8/2010)
Would a continuous backup of transaction logs cause a growth from size 8 MB up to 10s of GB knowing that such backup is occurring periodically over short 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)

June 11, 2010 at 7:13 am

#1179147
RE: Need help in SQL , Subtract column based on the condition in the Row

danielprabhu (6/10/2010)
Here i would close my book and sleep 🙂 my local time is 2.30 pm still searching and learning Sql
BWAA-HAAA!!!! Nope... you're NOT learning SQL... you're learning...
--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)

June 11, 2010 at 6:59 am

#1179135
RE: Database size quadruples after converting varchar, text to nvarchar

mack.talcott (6/10/2010)
CirquedeSQLeil (6/10/2010)
In addition to what Lynn has mentioned, you should look at free space vs. used space in your database. Despite having grown to 17GB, you may not...
--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)

June 11, 2010 at 6:51 am

#1179131
RE: Bi-Weekly Pay Period Total Worked Hours

canoedoceanprince (6/10/2010)
, CASE DATEPART(dw, startdate)
WHEN '1' THEN 'Sunday'
WHEN '2' THEN 'Monday'
WHEN '3' THEN 'Tuesday'
WHEN '4' THEN 'Wednesday'
WHEN '5' THEN 'Thursday'
WHEN '6' THEN 'Friday'
WHEN...
--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)

June 11, 2010 at 6:46 am

#1179129

Viewing 15 posts - 38,011 through 38,025 (of 59,098 total)