Viewing 15 posts - 1,351 through 1,365 (of 11,678 total)
g.britton (11/21/2014)
It's not just about efficiency, though cursors are usually the least efficient way to solve a problem.
True, but not always true 😀
Before windowing functions came through in SQL...
November 22, 2014 at 9:11 am
stevefromOZ (11/21/2014)
November 22, 2014 at 9:03 am
It might help if you would explain what you are actually trying to do.
Some queries can be written to function without cursors, others can't (such as for example executing a...
November 21, 2014 at 7:37 am
jacksonandrew321 (11/21/2014)
so can't we use that SSIS funtions on that? If yes then its possible to use SSIS right from there.
I'll repeat it again:
if you want to use SSIS on...
November 21, 2014 at 5:41 am
jacksonandrew321 (11/21/2014)
Koen Verbeeck (11/21/2014)
On every machine where you want to run an SSIS package, you need to install the Integration Services components, using the SQL Server media.
can't we run that...
November 21, 2014 at 5:30 am
On every machine where you want to run an SSIS package, you need to install the Integration Services components, using the SQL Server media.
November 21, 2014 at 3:28 am
stevefromOZ (11/20/2014)
Should be able to use the DMV's if you're on 2008+http://msdn.microsoft.com/en-us/library/hh230820(v=sql.110).aspx
I'm not sure there is a DMV with processing information.
Bob Duffy has an excellent session on tuning SSAS processing...
November 21, 2014 at 3:24 am
Phil Parkin (11/20/2014)
Change the properties of your lookup component so that its lookup is not cached.It will hit performance hard, but it should do what you want.
And change the OLE...
November 21, 2014 at 1:30 am
It's possible that both queries have the exact some execution plan.
In theory query 2 could be faster because you join against a smaller table. However, since it is a resultset...
November 21, 2014 at 1:27 am
One of the first results on Google for "sql server join index":
(it is written for SQL Server 2000 though, but a lot will probably still be applicable.)
You should...
November 21, 2014 at 1:25 am
Nice question, not so great explanation.
Still wonder why number 1 is not a clustered index scan.
Does SQL Server always prefer a covering nonclustered index over a clustered index?
(still got it...
November 21, 2014 at 1:23 am
Sean Lange (11/20/2014)
November 20, 2014 at 7:35 am
Sean Lange (11/20/2014)
Koen Verbeeck (11/20/2014)
This means people have to vote for me (or other people, but preferable me):
http://www.mssqltips.com/MSSQLTipsAuthorVoting.asp
Note...
November 20, 2014 at 7:23 am
Toreador (11/20/2014)
GROUPING_ID was introduced in SQL2008. The others were all available in SQL2005.
And VARP is the only function with a name less than 5 characters! :w00t: 😎 :hehe:
November 20, 2014 at 5:19 am
HanShi (11/20/2014)
Stuart Davies (11/20/2014)
Koen Verbeeck (11/20/2014)
This means people have to vote for me (or other people, but preferable...
November 20, 2014 at 4:58 am
Viewing 15 posts - 1,351 through 1,365 (of 11,678 total)