Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,706 through 27,720 (of 59,101 total)

RE: Report Processing time too long at 7 mins

Lynn Pettis (12/31/2012)
Another reason for the table aliases and 2-part naming convention is the Microsoft has deprecated the use of 3- and 4-part naming conventions in SQL Server. This...
--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)

January 2, 2013 at 12:28 am

#1572748
RE: Create Table and Bulk Insert

Alright... what's the name of the file you used that last stored procedure 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)

January 2, 2013 at 12:15 am

#1572747
RE: Create Table and Bulk Insert

urso47 (12/31/2012)
As we don't have square brackets in the file uploaded, I tried removing them all, but it didn't work.
You certainly do. The last file you showed me had...
--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)

January 2, 2013 at 12:07 am

#1572746
RE: Report Processing time too long at 7 mins

ziako (12/31/2012)
i have created a stored procedure with the following SQL:
SELECT dbo.Generics.ProductName, dbo.Generics.Pack, dbo.Generics.OrderReference, dbo.Generics.CostPrice, dbo.Generics.Commission, dbo.Generics.Supplier,
...
--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)

December 31, 2012 at 6:31 pm

#1572636
RE: Create Table and Bulk Insert

urso47 (12/31/2012)
Based on the first file you created for me (treating the header), I made some changes (including the path) for using the real file (atached). When I run "EXEC...
--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)

December 31, 2012 at 5:47 pm

#1572631
RE: how to fetch records from multiple tables

ScottPletcher (12/31/2012)
That seems to imply that someone can change his/her SSN at will. I don't believe that's true.
Apologies... I certainly didn't mean to imply such a thing. 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)

December 31, 2012 at 4:35 pm

#1572624
RE: How To Generate XML File....From the Table...

Hmmm.... I thought this looked familiar. I recommend that we take our posts to the nearly identical post listed here http://www.sqlservercentral.com/Forums/Topic1401136-392-1.aspx#bm1401339 because it more correctly identifies the request 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)

December 31, 2012 at 4:26 pm

#1572622
RE: SELECT * INTO Table without propagating IDENTITY attribute?

ScottPletcher (12/31/2012)
Please try this:
SELECT *
INTO dbo.newtable
FROM dbo.oldtable_with_identity
UNION ALL
SELECT TOP (1) *
FROM dbo.oldtable_with_identity
WHERE 1 = 0
The identity property should be left off the column in the new table :-).
Nicely done, Scott....
--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)

December 31, 2012 at 4:11 pm

#1572621
RE: Need To Generate XML File

Dave Ballantyne (12/31/2012)
Jeff Moden (12/31/2012)
The fly in the ointment, of course, will be the non-unique leaf levels.
Indeed there are
->-> VP Dev Dept
->->-> Team Lead Team1...
--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)

December 31, 2012 at 7:35 am

#1572511
RE: Need To Generate XML File

sarwaanmca (12/30/2012)
Hi Sunil ,
The Required Heirarchy is,
[ CEO ]
1 -> President QA
->-> VP...
--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)

December 31, 2012 at 7:31 am

#1572509
RE: Need To Generate XML File

sarwaanmca (12/28/2012)
Hi,
I Have Table Data For The Following Stucture..
CREATE TABLE [dbo].[xmldata](
[FirstName] [varchar](110) NULL,
[LastName] [varchar](210) NULL,
[Email] [varchar](110) NULL,
[Phone] [varchar](110) NULL,
[Position] [varchar](110) NULL,
[Branch] [varchar](110) NULL,
[Address] [varchar](110) NULL
) ON [PRIMARY]
GO
Hmmm.... on my way...
--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)

December 31, 2012 at 7:24 am

#1572505
RE: Keeping all three environment(Dev,Stag,Prod) in sync

John Mitchell-245523 (12/31/2012)
ScottPletcher (12/28/2012)
I would never try to re-run the prod processes to get the data for other environments. That would be a nightmare to keep clean.
That's how we...
--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)

December 31, 2012 at 6:47 am

#1572499
RE: Fragmentation size

zi (12/30/2012)
Thanks for replying
Do you have a script to know the fragmentation size for the whole database not only table by table.
Thanks lot
You don't need one. Just check 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)

December 30, 2012 at 11:26 pm

#1572430
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

John Hardin (12/30/2012)
On page 27 I posted a suggested version of this that avoided CHARINDEX() and used an indexed table-type variable and it showed performance gains over the pure-CTE version,...
--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)

December 30, 2012 at 10:48 pm

#1572428
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Tony.l (12/29/2012)
Hi
unbelievable - so good. I have been doing these puter things for 30 years now and i am still amazed how little i know or probably at just how...
--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)

December 30, 2012 at 10:23 pm

#1572427

Viewing 15 posts - 27,706 through 27,720 (of 59,101 total)