ChrisM@Work

Forum Replies Created

Viewing 15 posts - 9,901 through 9,915 (of 10,143 total)

RE: I got burned today at a SQL Server Interview!

Geoduck
From Wikipedia, the free encyclopedia
Well blow me, what a fascinating critter. Bet they taste like razor clams, which are kinda like concentrated scallop. Yum!
^{“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

March 18, 2008 at 4:36 am

#790732
RE: Scheduling data extraction to excel

This works for me, Ahmad - c:\CambridgePubs.xls is created - and Excel isn't installed on the server.
Either there's a mistake in your sp, there's a problem with the driver...
^{“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

March 18, 2008 at 4:25 am

#790729
RE: I got burned today at a SQL Server Interview!

Not tried emu, but ostrich is very good, similar to steak but milder taste. Low cholesterol and fat so quite healthy.
Crustaceans and molluscs would be at the top of my...
^{“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

March 18, 2008 at 4:22 am

#790728
RE: Scheduling data extraction to excel

Hi Ahmad
This isn't the method I use for reading / writing spreadsheets using TSQL, however I created the stored procedure using your code above and executed the following:
EXEC spExecute_ADODB_SQL
'Create...
^{“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

March 18, 2008 at 1:38 am

#790694
RE: I got burned today at a SQL Server Interview!

SQLBill (3/17/2008)
I wasn't listing foods that COULD be eaten. Those are all things that I HAVE eaten.
Half of my Air Force career was spent in other countries. So 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

March 17, 2008 at 3:05 pm

#790597
RE: I got burned today at a SQL Server Interview!

Loner (3/17/2008)
Exotic food - Yummmmmm.
Fried Alligator tails
Fried Conch
Fried Rattlesnake
Raw Rattlesnake
Elk
Moose
Bear
Raw Sea Urchin
Camel
Reindeer
Pigeon
Horse
Eel
Fried Octopus
Fried Squid
Grilled Squid
(note on Octopus and Squid - if you really want to have fun, stick the tentacles...
^{“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

March 17, 2008 at 2:10 pm

#790561
RE: Poor performance with multiple updates

Sure Alan. If you are only updating a fixed number of columns in one table using data from another table, you can do it with a single statement, written something...
^{“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

March 17, 2008 at 7:29 am

#790329
RE: Poor performance with multiple updates

Is the same table UPDATEd in each statement? If so, the batch would run very much faster if it was written as a set-based update (UPDATE...FROM...)
^{“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

March 17, 2008 at 6:15 am

#790281
RE: Scheduling data extraction to excel

Ahmad Osama (3/15/2008)
Yes it is, Ahmad. I'm using it for something very similar.
I can post the main stored procedures I use for this in their entirety, and fragments...
^{“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

March 15, 2008 at 3:40 pm

#790063
RE: Scheduling data extraction to excel

Hi Jason
I guess it does, having read a few bits and bobs about Reporting Services. We don't have it here, we're stuck on 2k for a while yet. I didn't...
^{“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

March 14, 2008 at 3:00 pm

#789912
RE: Scheduling data extraction to excel

Ahmad Osama (3/14/2008)
Thanks Chris,
I had to generate daily sales report and store as new file every day...Is it possible thru ur technik
Yes it is, Ahmad. I'm using it for...
^{“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

March 14, 2008 at 2:57 pm

#789911
RE: I got burned today at a SQL Server Interview!

Grant Fritchey (3/14/2008)
And everytime you're eating chicken fingers... you're having Chernobyl Chicken.
It would have to be Chernobyl Chicken. Everybody knows normal chickens don't have fingers. Fish do.
^{“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

March 14, 2008 at 9:48 am

#789730
RE: Scheduling data extraction to excel

Ahmad, you can do either. I'm currently using stored procedures, in a process which flows as follows:
Start with a formatted Excel template file placed in an accessible folder
Copy to...
^{“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

March 14, 2008 at 8:56 am

#789682
RE: SELECT certain number of rows

Using Adam's sample data:
-- Top 21 TO 30 (less than one second)
SELECT TOP 10 * FROM (
SELECT TOP 30 * FROM dbo.TestData ORDER BY RowNum
) t ORDER...
^{“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

March 14, 2008 at 8:40 am

#789667
RE: I got burned today at a SQL Server Interview!

Brandie Tarvin (3/14/2008)
Actually, Grant, on my Google of the stuff, wikipedia said Lithium Bromide was used for bi-polar disorder too, which is probably where Chris's comment came from.
Weird. They...
^{“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

March 14, 2008 at 7:05 am

#789595

Viewing 15 posts - 9,901 through 9,915 (of 10,143 total)