Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,971 through 26,985 (of 59,101 total)

RE: No performance gain on queries on different servers with considerable hardware change

Markus (4/17/2013)
I agree. It goes to show you that your hardware is not the bottleneck. Sometimes it is just simply the I/O can only go as fast as...
--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)

April 17, 2013 at 3:42 pm

#1607460
RE: Are the posted questions getting worse?

First, a very hearty congratulations to the new MCM's!
Out of shear curiosity, how much (including the prerequisites) would you say you had to spend to get the MCM?
--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)

April 17, 2013 at 3:34 pm

#1607458
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (4/17/2013)
Brandie Tarvin (4/17/2013)
So I have this ridiculous thought of doing a series of articles for my blog on how to build a SQL Server database...
--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)

April 17, 2013 at 3:32 pm

#1607456
RE: The Cascading (CROSS) APPLY

You're not doing so bad, yourself, Dwain. Ten mostly 5 star articles in a year is freakin' awesome!
--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)

April 17, 2013 at 3:20 pm

#1607449
RE: selecting all attributes for a loan from a loan table

Joechelad (4/16/2013)
Hi all,
I have a student loan table that holds details such as the loan#, SSN and their dob(birth date).The table...
--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)

April 16, 2013 at 9:55 pm

#1607112
RE: Can someone help with a TSQL date sorting issue?

leonie6214 (4/16/2013)
I am sorry but I was not aware of the rules. However, I did include the table structure w/insert statements; I also attached an excel spreadsheet with the desired...
--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)

April 16, 2013 at 9:48 pm

#1607111
RE: loading massive files

captcooldaddy (4/16/2013)
I'm loading server large data files into a db. Some records in some table have carrage returns in the data which is acting like an end of line 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)

April 16, 2013 at 9:46 pm

#1607110
RE: Assigning a fieldname with rollup

znetznet (4/16/2013)
DevDB (4/16/2013)
If you post table script and script to insert some sample data that will be very helpful.
The DDL for the tables involved isnt the issue, as the correct...
--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)

April 16, 2013 at 9:41 pm

#1607109
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

mark.gilbert (4/16/2013)
I love this article, but I'm bothered by the following scenario...
declare @var varchar(7)
set @var = ''
select case when @var NOT LIKE '%[^0-9]%'
...
--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)

April 16, 2013 at 9:09 pm

#1607104
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

Solomon Rutzky (4/16/2013)
Of course, this is most likely all a moot point given that TRY_PARSE and TRY_CONVERT do a better job (in most cases) of determining Number vs Not 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)

April 16, 2013 at 8:37 pm

#1607102
RE: Can someone help with a TSQL date sorting issue?

leonie6214 (4/16/2013)
See query with groupings below. I have also attached an excel spreadsheet with the sample output.
SELECT
Name as StreetName,
MeterId,
CollectionDate,
CollectionAmount,
SpaceUniqueID as MeterNumber,
Blockface
FROM dbo.CollectionSummaries C WITH(NOLOCK)
JOIN Meters M WITH(NOLOCK) ON M.MeterId...
--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)

April 16, 2013 at 8:27 pm

#1607101
RE: Can someone help with a TSQL date sorting issue?

Apologies for my previous post. It was getting late and I didn't notice the sort order. Although the following will look identical to my previous post to the...
--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)

April 16, 2013 at 7:48 pm

#1607100
RE: view more efficient than before or not?

sqlfriends (4/16/2013)
Now we change the view to hopefully speed it up.
...but we have a batch process at night that uses it [font="Arial Black"][highlight=""]for each [/highlight][/font]individual. so overall it makes the...
--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)

April 16, 2013 at 7:44 pm

#1607097
RE: Wildcard DB name in VIEW of Procedure - Possible?

Considering the title of this thread, please keep in mind that none of them will work in a VIEW.
--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)

April 16, 2013 at 4:28 pm

#1607081
RE: The Cascading (CROSS) APPLY

ChrisM@Work (4/16/2013)
Jeff Moden (4/16/2013)
Awesome job, Chris. Well done!
Thanks Jeff! And thank you for the encouragement to put pen to paper. DC's been nagging me for ages. Once you stepped...
--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)

April 16, 2013 at 3:44 pm

#1607068

Viewing 15 posts - 26,971 through 26,985 (of 59,101 total)