Viewing 15 posts - 781 through 795 (of 3,011 total)
The Dixie Flatline (6/21/2011)
June 21, 2011 at 8:57 pm
The Dixie Flatline (6/21/2011)
I believe this fixes it though. Not too ugly and still...
June 21, 2011 at 2:53 pm
The Dixie Flatline (6/2/2011)
with cte (RowID,A,B,C,D,E) as
(
select 1,1,2,3,4,5 union all
select 2,3,1,5,3,2 union all
select 3,7,4,1,2,5
)
,cte2 as
(select *, case when...
June 21, 2011 at 2:29 pm
ALZDBA (6/20/2011)
Just read at Bob Beauchemin'd blog:http://www.sqlskills.com/blogs/bobb/post/Performance-features-in-SQL-Server-2008-RC0-Optimize-for-Adhoc-Workloads.aspx"stub for the non-parameterized version, plan for the parameterized version"
Could you check/confirm that ?
Are you sure that is the correct link? I didn't...
June 20, 2011 at 2:02 pm
matt stockham (6/20/2011)
Could the query be running twice? The first time creates the stub, the second turns it into a compiled plan with usecount of 1.
I thought of that,...
June 20, 2011 at 1:37 pm
I ran the following code when I turned on "optimize for ad hoc workloads", so all the the plans in memory are from after the option was set.
exec sp_configure 'optimize...
June 20, 2011 at 12:52 pm
chandan_jha18 (6/17/2011)
Michael Valentine Jones (6/17/2011)
Did you try adding indexes on the predicate columns?
Both the tables show seek operation on their indexes.Do you think anything would be missing? I thought seek...
June 18, 2011 at 11:16 am
Did you try adding indexes on the predicate columns?
June 17, 2011 at 12:49 pm
You could use SSIS to move the data and set a batch size to something reasonable, like 100,000 rows.
June 16, 2011 at 9:40 pm
opc.three (6/16/2011)
...
That said, Michael's script has "DATE_ID = Days since 1753-01-01". I am not modeling anything more than 111 years old...was it done this way in the function just for...
June 16, 2011 at 3:22 pm
Signs of trouble that resonate:
What can possibly go wrong?
How hard can it be?
Of course I know what I am doing.
There should be no impact to the business.
It works on my...
June 16, 2011 at 2:14 pm
Dan.Humphries (6/16/2011)
Of Course it is what it is has anything...
June 16, 2011 at 2:00 pm
majorbloodnock (6/16/2011)
Anyone like a game of bullshit bingo?
This helped me to "evolve cross-platform architectures".
Web Economy Bullshit Generator
June 16, 2011 at 10:55 am
vliet (6/16/2011)
I can multiply them too.
This phrase has become common along members of our DBA team after an infamous 'Dilbert', where a manager asks for some specific data. If the...
June 16, 2011 at 9:46 am
Viewing 15 posts - 781 through 795 (of 3,011 total)