Viewing 15 posts - 316 through 330 (of 557 total)
GilaMonster (10/30/2015)
November 1, 2015 at 3:51 am
ChrisM@Work (10/30/2015)
You have this index definition in your first post:CREATE NONCLUSTERED INDEX IX_Large_Table_ABDFHJ ON dbo.Large_Table
(A,B,D,F,H,J) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
Why?
2...
October 30, 2015 at 11:11 am
ChrisM@Work (10/30/2015)
Key lookups are always to the clustered index - but there's "Index intersect" which blurs the issue.
In the question there was an ordering (the word 'then'), so the...
October 30, 2015 at 8:28 am
The Question was:
Can SQL-server use an index and then use the covering index to collect the data?
(And therefore not using the 'main' table).
Answers:
GilaMonster (10/29/2015)
October 30, 2015 at 7:12 am
GilaMonster (10/29/2015)
That will either use the index on F and do key lookups to the cluster or will scan the covering index if...
October 29, 2015 at 8:30 am
Maybe a bit redundant now.
Only a single database is targeted.
Ben
-- ben brugman
-- 20151029
--
CREATE TABLE ##TableSizes (name sysname, rows varchar(16),
reserved varchar(16), data varchar(16), index_size varchar(16),unused varchar(16))
INSERT ##TableSizes
EXEC sp_MSforeachtable...
October 29, 2015 at 8:27 am
Everybody thanks for your contribution.
Especially; Kristen and William Mitchell.
Allthough there is a difference is style for all solutions, there is also a large overlap in the different solutions. Clairly there...
October 20, 2015 at 8:45 am
Sorry for this late response.
(Last few days I have had to take care of my elderly father who was hospitilized.).
Depending on my work and my father I stil want to...
October 13, 2015 at 9:33 am
Kristen-173977 (10/9/2015)
Sorry, because it, currently, relies on Metadata tables specific to our APPs it won't work standalone.I should try to find the time to make a generic version though ...
Maybe...
October 12, 2015 at 2:19 am
GilaMonster (10/9/2015)
SQLPrompt does all the column generation for inserts and selects. It's not free, but it's well worth the price in my opinion.
Thanks, I do use this, but this is...
October 9, 2015 at 4:36 am
Progress update,
Sorry that I can not post the actual code and or situation.
As allready described the code has to be altered before it can be executed.
There were some suggestions how...
October 6, 2015 at 2:32 am
ben.brugman (10/2/2015)
... not obtainable. ...... I do not want to change the code itself, ...
Jason A. Long (10/3/2015)
ben.brugman (10/2/2015)
October 4, 2015 at 6:32 am
Sorry, I think I was asking for something which is not obtainable.
And I wasn't clear enough in my question.
Because I want the code to cut and paste between the SSRS...
October 2, 2015 at 11:53 am
WayneS (10/1/2015)
The quickest, most sure-fire way to reduce the code would be to use CTRL+A followed by CTRL+X. :w00t::w00t:
Good anwser.
I would like to make a little change.
Maybe it is...
October 2, 2015 at 6:04 am
Hello Luis Cazaras and others:
This afternoon I got a request for a Pivot 'script', which would adjust to changes in a table. So I remembered the given solution on the...
October 1, 2015 at 7:57 am
Viewing 15 posts - 316 through 330 (of 557 total)