Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,456 through 34,470 (of 59,099 total)

RE: temp table vs. table variable

jeedee (3/28/2011)
For example Microsoft SQL Server 2008 R2 Unleashed, under the "General T-SQL Performance Recommendations" section. There (page 1655) I read the following:
You should use table variables instead of temporary...
--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)

March 28, 2011 at 4:53 pm

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

Tim-24860 (3/28/2011)
Sure,
I'd like the output to be like this.
Name | Oct 2010 | Nov 2010 | Dec 2010 | 2010 Total | Jan 2011 | Feb 2011 |...
--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)

March 28, 2011 at 2:36 pm

#1304581
RE: temp table vs. table variable

In fact, I'll state that I normally avoid Table Variables because they don't persist during troubleshooting and they don't act like Temp Tables would. Here's an example I recently...
--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)

March 28, 2011 at 2:34 pm

#1304575
RE: temp table vs. table variable

jeedee (3/28/2011)
May I ask why you prefer temporary tables above table variables?
Almost all the books I have read about SQL Server state that it's better to use table variables than...
--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)

March 28, 2011 at 2:28 pm

#1304571
RE: Are the posted questions getting worse?

Either way, I still think it's a really bad idea to have such sequences write directly into 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)

March 28, 2011 at 2:20 pm

#1304568
RE: Separate db copy for reporting

srdjan.katic (3/28/2011)
Idea is to have 2 node sql cluster on principal DB and separate DB that is mounted on sql reporting server for OLAP, analitical tools. Second DB does 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)

March 28, 2011 at 2:16 pm

#1304566
RE: NEW SEQUENCE NUMBER DAILY?

DMS11X (3/28/2011)
What do you guys think?
USE [msdb]
GO
/****** Object: Job [CYCLE NUMBER] Script Date: 03/28/2011 08:01:05 ******/
BEGIN TRANSACTION
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
/****** Object: JobCategory [[Uncategorized...
--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)

March 28, 2011 at 10:46 am

#1304475
RE: NEW SEQUENCE NUMBER DAILY?

DMS11X (3/28/2011)
Thanks again guys, you all have given me some additional homework and learning. I have no DBA, I am trying to create a database for use at work...
--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)

March 28, 2011 at 8:31 am

#1304395
RE: Separate db copy for reporting

David Benoit (3/28/2011)
srdjan.katic (3/28/2011)
We are waiting for NetApp that have snapshot manager for sql but i am not sure it will do all the work. I was thinking about sql...
--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)

March 28, 2011 at 8:24 am

#1304389
RE: Separate db copy for reporting

chetanr.jain (3/28/2011)
@jeff,
SAN replication always has edge over Log shipping if cost is not a factor.
I hope my statement is correct.
You're correct. I was just making sure that people know...
--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)

March 28, 2011 at 8:20 am

#1304386
RE: Are the posted questions getting worse?

Gianluca Sartori (3/28/2011)
Jeff Moden (3/28/2011)
Gianluca Sartori (3/28/2011)
GilaMonster (3/28/2011)
Not trying to start any bashing or pile-ons, but this has to rate high on the list of most useless replies: http://www.sqlservercentral.com/Forums/FindPost1084783.aspx
Sounds like...
--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)

March 28, 2011 at 8:01 am

#1304365
RE: Are the posted questions getting worse?

GilaMonster (3/27/2011)
Jeff Moden (3/27/2011)
GilaMonster (3/27/2011)
Jeff Moden (3/27/2011)
Oh yes... I know it's partially correct. I just couldn't understand why anyone who knows of SQL would bring it up even 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)

March 28, 2011 at 7:42 am

#1304350
RE: Are the posted questions getting worse?

Craig Farrell (3/28/2011)
GSquared (3/28/2011)
Stefan Krzywicki (3/26/2011)
Jeff Moden (3/26/2011)
Gianluca Sartori (3/25/2011)
GilaMonster (3/25/2011)
Koen Verbeeck (3/25/2011)
Maybe a blog post that Microsoft has purchased MySQL from Oracle and that it is integrating it with...
--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)

March 28, 2011 at 7:27 am

#1304336
RE: Are the posted questions getting worse?

Gianluca Sartori (3/28/2011)
GilaMonster (3/28/2011)
Not trying to start any bashing or pile-ons, but this has to rate high on the list of most useless replies: http://www.sqlservercentral.com/Forums/FindPost1084783.aspx
Sounds like "OK, just do it"....
--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)

March 28, 2011 at 7:23 am

#1304335
RE: NEW SEQUENCE NUMBER DAILY?

DMS11X (3/28/2011)
I need to reset a sequence number every 0000hrs daily...
I have searched and searched and tested different ways, and have found no viable solution.
Anyone know how to do this?
There...
--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)

March 28, 2011 at 7:18 am

#1304332

Viewing 15 posts - 34,456 through 34,470 (of 59,099 total)