ChrisM@Work

Forum Replies Created

Viewing 15 posts - 6,526 through 6,540 (of 10,143 total)

RE: Are the posted questions getting worse?

Brandie Tarvin (10/25/2011)
ChrisM@Work (10/25/2011)
Brandie Tarvin (10/25/2011)
Got my new smart phone. Setting up my tethering connection now. Thanks for all the help.
A nice pair of ski socks will prevent abrasion of...
^{“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 25, 2011 at 5:49 am

#1399042
RE: Are the posted questions getting worse?

Brandie Tarvin (10/25/2011)
GSquared (9/19/2011)
Brandie Tarvin (9/19/2011)
GSquared (9/16/2011)
Brandie Tarvin (9/16/2011)
I'm thinking about getting a tablet so I can do email & social networking apps while I am at functions (rather than...
^{“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 25, 2011 at 5:42 am

#1399038
RE: Introduction to Indexes: Part 2 – The clustered index

"A scan of the clustered index is equivalent to a table scan. It’s a read of all of the data pages in the table...
This is a full scan of all...
^{“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 24, 2011 at 10:09 am

#1398790
RE: Using OPENROWSET to dynamically retrieve SP results when SP contains temp tables

ZokWobblefotz (10/24/2011)
Also, if a local temp table is created outside of the EXEC statement it can be referenced within one like so:
DECLARE @sql VARCHAR(MAX)
IF(OBJECT_ID('TempDB..#TempOutput') IS NOT NULL) DROP TABLE #TempOutput
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

October 24, 2011 at 9:40 am

#1398767
RE: Using OPENROWSET to dynamically retrieve SP results when SP contains temp tables

DECLARE @sql VARCHAR(MAX)
IF(OBJECT_ID('TempDB..##TempOutput') IS NOT NULL) DROP TABLE ##TempOutput
SELECT @sql = 'SELECT * INTO ##TempOutput FROM (SELECT Today = GETDATE()) d'
EXEC(@sql)
SELECT * FROM ##TempOutput
-- returns "now"
IF(OBJECT_ID('TempDB..#TempOutput')...
^{“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 24, 2011 at 8:27 am

#1398703
RE: Using OPENROWSET to dynamically retrieve SP results when SP contains temp tables

ZokWobblefotz (10/24/2011)
Stewart, the method you propose requires me to know the output of a procedure in advance, does it not?
ChrisM, I am indeed working on one single server.
It's not clear...
^{“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 24, 2011 at 8:19 am

#1398696
RE: Query Optimization using Indexes

Ninja's_RGR'us (10/24/2011)
When we tune we only care about the statements. Unless the index creation will always be part of the process (like for a temp table).
Both of the temp...
^{“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 24, 2011 at 7:52 am

#1398681
RE: Query Optimization using Indexes

adlakha.22 (10/24/2011)
here is execution plan for covered index
How long did this one take to run? There are a number of interesting changes in the plan as a result.
^{“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 24, 2011 at 7:21 am

#1398660
RE: Are the posted questions getting worse?

GilaMonster (10/24/2011)
I prefer picking a sentence from towards the end of the article, it eliminates those posting just an extract of the article. Doing that, this one turned up:
http://toostep.com/insight/daily-dba-morning-check-list
Steve's going...
^{“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 24, 2011 at 5:32 am

#1398618
RE: Query Optimization using Indexes

adlakha.22 (10/24/2011)
here is execution plan for covered index
Can you post the CREATE INDEX statement?
^{“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 24, 2011 at 5:09 am

#1398604
RE: Query Optimization using Indexes

Why are you doing this 3 times in a row?
SELECT @ordernumber = ordernumber
I didn't want the return of the data as you put it influencing the speed test. 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

October 24, 2011 at 4:59 am

#1398600
RE: Query Optimization using Indexes

adlakha.22 (10/24/2011)
By executed this I got an error:
Warning: Null value is eliminated by an aggregate or other SET operation.
Remi's right - ignore this for now.
^{“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 24, 2011 at 4:42 am

#1398589
RE: Using OPENROWSET to dynamically retrieve SP results when SP contains temp tables

ZokWobblefotz (10/19/2011)
[h1]My Scenario[/h1]
I'm working on a database which will contain many details from various Stored Procedures in different databases across the entire server. ...
Can you confirm that you are working...
^{“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 24, 2011 at 4:14 am

#1398573
RE: Are the posted questions getting worse?

HowardW (10/24/2011)
Just came across this:
http://sqlserverboost.info/?p=204
Complete plagiarism, yes?[/url]
The rest of the site content looks equally dubious.
Looks like the perp is from Welling, Kent, UK - meaning reachable for a change.
^{“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 24, 2011 at 3:43 am

#1398566
RE: Query Optimization using Indexes

adlakha.22 (10/24/2011)
Chris
I have executed Qry, and it took 71 sec. to execute
U can see EP.
Two sorts - 70% of total.
Comment out this line:
[OE Type] ...
^{“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 24, 2011 at 3:38 am

#1398564

Viewing 15 posts - 6,526 through 6,540 (of 10,143 total)