Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,051 through 31,065 (of 59,101 total)

RE: TSQL that lists all numbers from 1..100

Gosh, Eli. Thanks for sharing but please consider the following, instead. It's faster, still doesn't require access to a table, can produce a much larger range of numbers,...
--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)

February 19, 2012 at 12:01 pm

#1449001
RE: Using regular expressions and -split to parse log file

opc.three (2/18/2012)
Jeff Moden (2/18/2012)
opc.three (2/18/2012)
Your problem is a classic one that IMO is not elegantly solved in current versions of T-SQL. The window frames coming out in SQL Server 2012...
--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)

February 19, 2012 at 11:21 am

#1448998
RE: Does Sql Server clustering increasing data access performance?

walia_jagwinder (2/19/2012)
Clustering allowing one physical server to take over tasks and responsibilities of another physical server that is failed.
Does clustering also increasing the data access performances?
If yes then how?
As Gail...
--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)

February 19, 2012 at 10:59 am

#1448996
RE: sum on specific column

SQL Kiwi (2/16/2012)
Stewart "Arturius" Campbell (2/16/2012)
will this help?
This is an unreliable and unsupported construct, and should not be used or recommended:
CREATE TABLE #test (col1 tinyint, col2 char(5));
INSERT #test (col1)
VALUES...
--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)

February 19, 2012 at 10:50 am

#1448995
RE: Looping through Stored Procedures

It would be extremely beneficial to your cause if you posted the data in a more readily consumable format than an Excel spreadsheet. Please see the first link 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)

February 19, 2012 at 10:43 am

#1448994
RE: Most Occuring value in a column

Heh. Not to worry. I've eaten my own share of bad beans. 🙂
--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)

February 18, 2012 at 7:03 pm

#1448958
RE: Most Occuring value in a column

ColdCoffee (2/18/2012)
Going through the example again adding extra data, ( new sample has Name1 and name2 appearing 5 times each), here is the code
DECLARE @Table TABLE
( ColVal VARCHAR(10) )
INSERT INTO...
--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)

February 18, 2012 at 6:35 pm

#1448955
RE: Most Occuring value in a column

ColdCoffee (2/18/2012)
Jeff Moden (2/18/2012)
"Use the Force, Luke!"
Although the execution plans are identical and the performance is likely identical, as well, sometimes the "old ways" lead to simpler code. Don't...
--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)

February 18, 2012 at 6:31 pm

#1448953
RE: Using regular expressions and -split to parse log file

opc.three (2/18/2012)
Your problem is a classic one that IMO is not elegantly solved in current versions of T-SQL. The window frames coming out in SQL Server 2012 may help towards...
--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)

February 18, 2012 at 6:29 pm

#1448949
RE: Group Islands of Contiguous Dates (SQL Spackle)

rfr.ferrari (2/18/2012)
nice article Jeff!
thanks!!!!
You bet. Thank you for the feedback.
--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)

February 18, 2012 at 11:57 am

#1448924
RE: Using regular expressions and -split to parse log file

I've not checked any of the other's code (not real good at reading PowerShell code) but make sure they can handle multiple days.
Just because it's my nature, I thought I'd...
--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)

February 18, 2012 at 11:44 am

#1448923
RE: Most Occuring value in a column

ColdCoffee (2/18/2012)
This?
DECLARE @Table TABLE
( ColVal VARCHAR(10) )
INSERT INTO @Table (ColVal)
SELECT 'name1'
UNION ALL SELECT 'name2'
UNION ALL SELECT 'name3'
UNION ALL SELECT 'name1'
UNION...
--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)

February 18, 2012 at 10:33 am

#1448916
RE: Varchar(max) performance problem in SQL server 2008 R2

I don't believe that the VARCHAR(MAX) datatype is the problem. I believe it's just the shear amount of data you're trying to transfer through the pipe. You said...
--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)

February 18, 2012 at 10:19 am

#1448914
RE: Convert minutes to HH:MM:SS format

GuruGPrasad (2/16/2012)
Hi Jeff Moden,
Yes my post was blocked.. Its ok no problem
Regards
Guru
It was problem enough for you to mention it. 😀 I looked back at your posts on...
--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)

February 18, 2012 at 10:10 am

#1448913
RE: Convert minutes to HH:MM:SS format

SQLKnowItAll (2/16/2012)
My guess is that the result for 1441 should be 24:01:00. It seems, looking at this post and the other post by the OP, that this is 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)

February 18, 2012 at 10:07 am

#1448912

Viewing 15 posts - 31,051 through 31,065 (of 59,101 total)