Viewing 15 posts - 6,526 through 6,540 (of 10,144 total)
GilaMonster (10/24/2011)
ChrisM@Work (10/24/2011)
October 26, 2011 at 2:18 am
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...
October 25, 2011 at 5:49 am
Brandie Tarvin (10/25/2011)
GSquared (9/19/2011)
Brandie Tarvin (9/19/2011)
GSquared (9/16/2011)
Brandie Tarvin (9/16/2011)
October 25, 2011 at 5:42 am
"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...
October 24, 2011 at 10:09 am
ZokWobblefotz (10/24/2011)
DECLARE @sql VARCHAR(MAX)
IF(OBJECT_ID('TempDB..#TempOutput') IS NOT NULL) DROP TABLE #TempOutput
CREATE...
October 24, 2011 at 9:40 am
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')...
October 24, 2011 at 8:27 am
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...
October 24, 2011 at 8:19 am
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...
October 24, 2011 at 7:52 am
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.
October 24, 2011 at 7:21 am
GilaMonster (10/24/2011)
http://toostep.com/insight/daily-dba-morning-check-list
Steve's going...
October 24, 2011 at 5:32 am
adlakha.22 (10/24/2011)
here is execution plan for covered index
Can you post the CREATE INDEX statement?
October 24, 2011 at 5:09 am
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...
October 24, 2011 at 4:59 am
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.
October 24, 2011 at 4:42 am
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...
October 24, 2011 at 4:14 am
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.
October 24, 2011 at 3:43 am
Viewing 15 posts - 6,526 through 6,540 (of 10,144 total)