ChrisM@Work

Forum Replies Created

Viewing 15 posts - 6,496 through 6,510 (of 10,143 total)

RE: foxpro odbc driver in windows server 2008

elham_azizi_62 (11/2/2011)
hello all.
I work with sql server 2008 and windows server 2008.I configure target in odbc properties to %SystemRoot%\SysWOW64\odbcad32.exe and add microsoft visual foxpro driver in UserDSN and select...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

November 2, 2011 at 3:01 am

#1402015
RE: SSIS 2008 Task Elapsed Time

Stefan Krzywicki (11/1/2011)
ChrisM@Work (11/1/2011)
You're welcome Stefan. I'd be interested to hear what you come up with.
...If I use GetDate in the Execute SQL, it should give me the time I...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

November 1, 2011 at 7:55 am

#1401623
RE: SSIS 2008 Task Elapsed Time

You're welcome Stefan. I'd be interested to hear what you come up with.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

November 1, 2011 at 6:53 am

#1401585
RE: SSIS 2008 Task Elapsed Time

Stefan Krzywicki (10/31/2011)
ChrisM@Work (10/27/2011)
Stefan Krzywicki (10/27/2011)
ChrisM@Work (10/27/2011)
Look at LoggingMode on the properties tab of the package.
Right-click on the white space of a package, select Logging, select what you want...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

November 1, 2011 at 3:08 am

#1401459
RE: Removing Redundant Records from Table

Ugly but it works:
DROP TABLE #Sample
CREATE TABLE #Sample ([Line#] int, Level1 int, Level2 int, Level3 int, Level4 int, Goal CHAR(1))
INSERT INTO #Sample ([Line#], Level1, Level2, Level3, Level4, Goal)
SELECT 1, 102111,NULL,NULL,NULL,...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

October 31, 2011 at 11:00 am

#1401222
RE: Help with performance - aggregating a lot of data

Jeff Moden (10/30/2011)
ChrisM@home (10/30/2011)
Here's a few preliminary results from queries posted so far, and another which I'm guessing is Jeff's preaggregate. The preaggregate works fastest but not by a fat...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

October 31, 2011 at 3:10 am

#1400962
RE: Help with performance - aggregating a lot of data

There are a couple of things I want to confirm using your data.
Firstly, IIRC aggregating the columns separately then adding up the aggregates is quicker than aggregating the sum...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

October 28, 2011 at 6:21 am

#1400586
RE: Help with performance - aggregating a lot of data

Kiara (10/28/2011)
ChrisM@Work (10/28/2011)
No worries Ki. There's an aspect of this which is interesting to me and I'll continue to work with it - at home, they wouldn't allow these volumes...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

October 28, 2011 at 5:56 am

#1400580
RE: Help with performance - aggregating a lot of data

No worries Ki. There's an aspect of this which is interesting to me and I'll continue to work with it - at home, they wouldn't allow these volumes at work...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

October 28, 2011 at 5:30 am

#1400562
RE: case statement help.

bass8117 (10/27/2011)
below is part of code that includes many subselects, sums, etc. here's the problem I have,
in the CHRG0.CHRG_AMT column I have a reverse charge of -289.00 with a CHRG0.CHRG_BAL...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

October 28, 2011 at 2:59 am

#1400532
RE: Inserting records in a table fills up TempDB

Vishal Sinha (10/27/2011)
What can be done in situations like these where a few million records will be inserted in the table? I only want 1 record to be inserted in...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

October 28, 2011 at 1:52 am

#1400513
RE: SSIS 2008 Task Elapsed Time

Stefan Krzywicki (10/27/2011)
ChrisM@Work (10/27/2011)
Look at LoggingMode on the properties tab of the package.
Right-click on the white space of a package, select Logging, select what you want to log.
During dev,...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

October 27, 2011 at 9:29 am

#1400243
RE: SSIS 2008 Task Elapsed Time

Look at LoggingMode on the properties tab of the package.
Right-click on the white space of a package, select Logging, select what you want to log.
During dev, log just about...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

October 27, 2011 at 8:28 am

#1400180
RE: Inserting records in a table fills up TempDB

What does the following query return?
SELECT count(*)
FROM TABLE1 AS CC
INNER JOIN TABLE2 AS M ON CC.FORMATTED_PHONE_ADDRESS = M.EMAIL_ADDRESS
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

October 27, 2011 at 7:56 am

#1400162
RE: self teaching newbie needs help please...

Here's a wee script to get the ball rolling. No PK's / FK's yet (or even indexes), and not even fully normalised, but simple enough to use as a framework...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

October 27, 2011 at 7:51 am

#1400156

Viewing 15 posts - 6,496 through 6,510 (of 10,143 total)