Viewing 15 posts - 13,021 through 13,035 (of 49,552 total)
Sergiy (5/24/2013)
Not valid is your claim that aliasing in your example belongs to INSERT.Or has any relevance to it at all.
I never said the aliasing 'belongs' to insert, or that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2013 at 6:06 am
Please note: 9 year old thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2013 at 5:16 am
Not what I asked.
Is the table bigger than the view?
There's more going on when you index a view than indexing a table, the query that defines the view has to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2013 at 12:28 am
Jack Vamvas (5/23/2013)
Are you receiving any Sort warnings? these can be a clue of ORDER BY spilling into TempDB and insufficient memory. Check Statistics are up to date
Sorts are very...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2013 at 12:19 am
Table's bigger?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2013 at 12:08 am
Shouldn't be a difference
Bear in mind though what MAXDOP is. It's telling SQL the maximum number of processors that it is allowed to use for the operation. So MAXDOP 64...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 23, 2013 at 11:48 pm
Sergiy (5/23/2013)
GilaMonster (5/23/2013)
Since that's a valid form for the select, it's also valid for the insert...select.Very arguable.
What, that it's valid? Since it passes a syntax check it's valid T-SQL, hard...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 23, 2013 at 3:31 pm
The Dixie Flatline (5/23/2013)
Don't you own a bokken?
Yes, they also have the tendency to damage punching bags. Edge is too narrow to use on a bag. Same with the jo.
And...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 23, 2013 at 1:51 pm
What exactly do you mean that it doesn't use that option? What are you seeing?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 23, 2013 at 1:02 pm
jcrawf02 (5/23/2013)
GilaMonster (5/22/2013)
Evil Kraig F (5/22/2013)
GilaMonster (5/22/2013)
Oh look... "I don't think that's right... " again. Anyone got a baseball bat? Or a punching bag?Don't you own a katana?
Yes, but it'll...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 23, 2013 at 10:50 am
mister.magoo (5/23/2013)
I don't have 2005 any more, but interestingly on 2012 at least, you can just issue a CREATE INDEX using the same index name without dropping it first!
You can...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 23, 2013 at 9:51 am
Grant Fritchey (5/23/2013)
GilaMonster (5/22/2013)
Grant Fritchey (5/22/2013)
GilaMonster (5/22/2013)
Oh look... "I don't think that's right... " again. Anyone got a baseball bat? Or a punching bag?Will an Arkansas tire thumper work?
No idea...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 23, 2013 at 9:27 am
Bhaskar.Shetty (5/23/2013)
You cannot call insert like that, = operator works while you are updating any row or table.
You mean the way Marc suggested?
insert mytable(col1,col2,col3,col4)
select
col1...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 23, 2013 at 5:54 am
Index column order is important
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
That said, test the indexes, if they help, implement them (or one). If they don't, then don't.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 23, 2013 at 12:39 am
marc.snoeys (5/22/2013)
That's a non-argument because you can't insert two or more records with the VALUES-syntax as well 😉
Like this you mean?
CREATE TABLE #test (
ID INT
)
INSERT INTO #test (ID)
VALUES (1), (2),...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 23, 2013 at 12:05 am
Viewing 15 posts - 13,021 through 13,035 (of 49,552 total)