Viewing 15 posts - 1,351 through 1,365 (of 11,676 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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 22, 2014 at 9:11 am
stevefromOZ (11/21/2014)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 21, 2014 at 1:23 am
Sean Lange (11/20/2014)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 20, 2014 at 4:58 am
Viewing 15 posts - 1,351 through 1,365 (of 11,676 total)