Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,991 through 31,005 (of 59,101 total)

RE: String tokenizing / splitting

Gatekeeper (5/2/2011)
Not to mention his CTE tally table...
Thank you for the wonderful kudo but I absolutely cannot take the credit for the cteTally. The original concept was first published...
--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 25, 2012 at 3:11 pm

#1451767
RE: Passing comma-delimited list as a parameter

Dang, Joe. That's the 3rd one I've seen today... Informative, helpful, kind, and courteous. It's a really nice change. Keep it up! The tone of your...
--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 25, 2012 at 1:53 pm

#1451762
RE: Are the posted questions getting worse?

Lynn Pettis (2/25/2012)
Grant Fritchey (2/25/2012)
Lynn Pettis (2/24/2012)
Quite an interesting day. I gave my two weeks notice and was basicly told that I would not need to come back. ...
--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 25, 2012 at 1:45 pm

#1451761
RE: WHERE Date Range

BSavoie (2/24/2012)
Fantastic info, which is exactly what I knew I would get as always from this forum. Gails post is exactly what I needed.
Thanks all!!
Considering the very narrow range 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)

February 25, 2012 at 1:14 pm

#1451758
RE: WHERE Date Range

HowardW (2/24/2012)
Artoo22 (2/24/2012)
SELECT* FROM#t WHEREDateCreated >= ISNULL(@FromDate, DateCreated)
ANDDateCreated <= ISNULL(@ThroughDate, DateCreated)
It might look neater, but the use of scalar functions (ISNULL) guarantees that indexes can't be used to fulfil the query.
The word...
--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 25, 2012 at 12:58 pm

#1451756
RE: WHERE Date Range

Henrico Bekker (2/23/2012)
use BETWEEN...
select column where daterange between @startrange and @endrange
How's that going to work if either or both variables have a value of NULL because the user didn't specify...
--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 25, 2012 at 12:38 pm

#1451748
RE: Is 2GB physical Memory enough for SQL Server 2008 RTM on a Virtual Machine?

Someone with more knowledge in this area will likely correct me but I'd say that "it depends" on how many sessions are going to be hitting this box at once.
--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 25, 2012 at 12:35 pm

#1451746
RE: Is it a good idea to shrink a database, after backing up the transaction logs?

I'll throw in with the others. The only time you should shrink the database is if there has been a catastropic event that caused some really crazy file growth....
--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 25, 2012 at 12:31 pm

#1451744
RE: Incrementing a table name

CELKO (2/25/2012)
Have you looked at the indexing on partitioned tables? I attended a DB2 talk a few weeks ago on their implementation. Basically, each partition gets it own index 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 25, 2012 at 12:16 pm

#1451738
RE: Are the posted questions getting worse?

Returning to the original subject of this thread, I can now say I've seen just about everything on this fine forum.
http://www.sqlservercentral.com/Forums/Topic1257783-391-1.aspx
--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 25, 2012 at 12:11 pm

#1451737
RE: Incrementing a table name

gary.morey (2/24/2012)
I have a sql server table named raw17. Is there a way to create a new table that increments the number in the table name by 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)

February 25, 2012 at 12:02 pm

#1451732
RE: Incrementing a table name

CELKO (2/25/2012)
Lowell (2/24/2012)
instead of multiple tables, why not a single table with your 1-19 etc indicators as a column value in that table? wouldn't that be easier to use 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)

February 25, 2012 at 11:51 am

#1451728
RE: Call That a Database? This is a Database.

BWAA-HAAA!!!! In that vein, I have a simple name for most databases I've seen in my life whether they be small or large. "Snowman Databases". They look really...
--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 25, 2012 at 11:37 am

#1451725
RE: How to speed up Running Average View

BWAA-HAAA!!! Maybe I'm not done yet! I just had an ephiphany that I'll have to explore. It seems to me that a Recursive CTE might be 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 25, 2012 at 11:13 am

#1451720
RE: How to speed up Running Average View

IF you don't mind changing the view and the code that calls it to be a bit more flexible, we can make it so the table actually only needs one...
--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 25, 2012 at 11:04 am

#1451717

Viewing 15 posts - 30,991 through 31,005 (of 59,101 total)