Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,646 through 33,660 (of 59,099 total)

RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

SQL Server Youngling (5/27/2011)
Awesome article! Definitely something I've never done, but I believe this article will get me there.
"For an optional solution, please refer to the following URL"
Optimal, perhaps?
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)

June 15, 2011 at 9:04 pm

#1339433
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

David Jackson (5/27/2011)
SQL Server Youngling (5/27/2011)
Awesome article! Definitely something I've never done, but I believe this article will get me there.
"For an optional solution, please refer to the following...
--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 15, 2011 at 9:02 pm

#1339431
RE: Inserting into an Table with Identity Column from n number of tables

JAYANTH KURUP (6/13/2011)
For obvious reasons you should try never to use an OLTP database back end as the data source for your reports.
"Never" is a pretty strong word here. ...
--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 15, 2011 at 8:23 pm

#1339426
RE: Log File Space during Updates of a Table

Grizzly Bear (6/13/2011)
OK here it is .
This table had 35 Million Rows.
We were Updating the BitColumn Field.
There was also a Trigger which would write to another table, which...
--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 15, 2011 at 8:15 pm

#1339422
RE: Need to filter by date range...

toddasd (6/13/2011)
Jeff Moden (6/13/2011)
sql_jr (6/13/2011)
Thank you, Jeff! I see quite a lot of activity around my post (which doesn't really have anything to do w/my original question 🙂 ...
--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 15, 2011 at 7:52 pm

#1339415
RE: please help me out

vultar (6/10/2011)
Just a suggestion as well. The original post doesn't mention anything about the need to automatically detect the names of over 100 servers..
Absolutely true. But I also didn'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)

June 15, 2011 at 7:37 pm

#1339413
RE: How to manage databases without sysadmin role?

Lowell (5/26/2011)
i'm very weak on the reason why i had to do that trustowrthy thing;
can you turn off trustowrthy, change the proc to WITH EXECUTE AS SELF,...
--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 15, 2011 at 7:08 pm

#1339408
RE: how or what tools can I use to return a list of SQL servers in our network

Shabba (5/27/2011)
There are quite a few tools out there but one of the best in my opinion which was free the last time I looked was http://www.quest.com/discovery-wizard-for-sql-server/. Although 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)

June 15, 2011 at 7:01 pm

#1339405
RE: Finding dates in Dates tally table

Ah... almost forgot. You might want to take a look at Michael Valentine Jones' post above... the concept of using the underlying "date serial number" (number of days since...
--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 15, 2011 at 6:22 pm

#1339395
RE: Finding dates in Dates tally table

No... following your standard of having an ID column on most tables, leave the PK on the ID column (makes some forms of automation a lot easier). Just drop...
--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 15, 2011 at 6:14 pm

#1339393
RE: Expanding functions within a script

chas.clarke (6/13/2011)
Jeff,
Thanks for coming back.
I am trying to combine several stored procedures and functions into one query that I can run with my limited access. Initially, whilst I refine...
--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 15, 2011 at 6:08 pm

#1339392
RE: Division Problem in SQL 2005

MtnJim (5/26/2011)
Thank you so much. I was tearing my hair out trying to figure out why my division wouldn't work.
Ah... you bet and, again, apologies for the late response. ...
--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 15, 2011 at 6:04 pm

#1339391
RE: Division Problem in SQL 2005

robertm-772679 (10/19/2009)
Thank you Bob and Jeff for your excellent feedback. I have modified my solution based on your input. This is a bit simpler and easier to read. No CAST...
--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 15, 2011 at 6:00 pm

#1339390
RE: Cursors for T-SQL Beginners

jmaloney-1117255 (6/7/2011)
Jeff, thank you for taking the time to answer. 🙂
I suspected that there would likely be some overhead involved. And thank you for the links, I'll check...
--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 15, 2011 at 5:50 pm

#1339389
RE: Are the posted questions getting worse?

Roy Ernest (6/15/2011)
Brandie, it is the perfect place for a vacation. 🙂
Steve, I will expecting you for sure. Trey, there is lots of time to save money for the trip....
--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 15, 2011 at 5:38 pm

#1339387

Viewing 15 posts - 33,646 through 33,660 (of 59,099 total)