Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,566 through 23,580 (of 59,099 total)

RE: SSRS Slowness

A normal type-written piece of 8-1/2" x 11" piece of paper (portrait orientation) will normally contain 60 lines (at 12pt font) or almost 80 lines (10 pt font). At...
--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)

May 26, 2014 at 11:26 am

#1716514
RE: Export in txt from sql (in a pivot way)

antonela (5/26/2014)
Do you know how can I do the same in sql server 2005?
This functions properly only in sql server 2008 and 2012.
Heh... this is why you should always pick...
--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)

May 26, 2014 at 10:41 am

#1716511
RE: Database Design Queries

IDENTITY is a good choice but does have some caveats when it come to "replication". If you intend to use replication, you'll need to study that a bit.
Yes, both...
--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)

May 26, 2014 at 10:31 am

#1716510
RE: hi

eboucicaut 94437 (5/26/2014)
someone can help me please,I have a stored procedure that executes a set of procedure in a cursor procedure. it always gives me an error message when 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)

May 26, 2014 at 9:55 am

#1716501
RE: 2014 - Are you using it and are there any reported issues?

SQLKnowItAll (5/21/2014)
I am having a really hard time finding any articles or blogs mentioning issues with 2014. I suppose that is a good thing 🙂 Can anyone point me to...
--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)

May 26, 2014 at 9:47 am

#1716498
RE: Purge and Archive using ssis packages

jansub07 (5/26/2014)
Purge and Archive using ssis 2008R2 packages
The OLTP DB and Archive DB are of two separate servers. We have like hundreds of tables. Deletion is not a problem 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)

May 26, 2014 at 9:02 am

#1716493
RE: too many arguments - but they match

danaanderson (5/25/2014)
Jeff Moden (5/25/2014)
danaanderson (5/25/2014)
I don't think that it matters about the position in the parameter of the dbtype spec, but I'll check it out. It is ASP.NET. ...
--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)

May 26, 2014 at 8:26 am

#1716490
RE: SQL server license swithching from Production license to MSDN version.

SanjeevBaranwal (5/25/2014)
We have made a product and deployed on cloud with production license of sql server. since we dont have the client in order to minimise the cost we need...
--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)

May 25, 2014 at 11:58 pm

#1716432
RE: How are task implemented internally

Shadab Shah (5/25/2014)
...showed him some links where it was proved that SSIS loads the data faster.
Faster than what? Show us the links, please.
Then he ask me, this all loading...
--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)

May 25, 2014 at 11:52 pm

#1716430
RE: Copy files using Powershell

I've got just the thing for you. Check out the /MIR option. And, the three best things are 1) you probably already have it and 2) it's free...
--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)

May 25, 2014 at 11:24 pm

#1716427
RE: How to compare the first 20 chars onlys

Lynn Pettis (5/25/2014)
Realize that you lose any benefits of having an index on the TransDesc column. If you can, you may want to consider adding a persisted computed column...
--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)

May 25, 2014 at 10:12 am

#1716395
RE: TempTables

sql-lover (5/24/2014)
ramana3327 (5/24/2014)
Thanks Everyone.
Please let me know,
How the table spool effect the performance? In what situation we can get table spool in execution plan and how can we avoid...
--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)

May 25, 2014 at 9:55 am

#1716390
RE: Most Basic SQL Doubt - Why is it called a Table in the first place?

webrunner (5/24/2014)
I think this is the most complete etymological explanation:
http://english.stackexchange.com/questions/10976/does-the-word-table-have-anything-to-do-with-a-table
That kind of table comes from the Latin tabula meaning "a board or plank" which was used for writing down columns...
--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)

May 25, 2014 at 9:45 am

#1716388
RE: too many arguments - but they match

danaanderson (5/25/2014)
I don't think that it matters about the position in the parameter of the dbtype spec, but I'll check it out. It is ASP.NET. Classic ASP is...
--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)

May 25, 2014 at 9:33 am

#1716387
RE: Recursive CTE? Not Sure How To Do This...

autoexcrement (5/24/2014)
For anyone else following along, I just thought I'd mention however that I omitted SalesRepID from my index and from my case statements on eligibility. My index and row_number,...
--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)

May 25, 2014 at 9:13 am

#1716385

Viewing 15 posts - 23,566 through 23,580 (of 59,099 total)