I know it was best practise to call a stored procedure as
"exec dbo.sproc" instead of "exec sproc"
I guess it was in reference to compilations.
But when i monitored compilations/sec and recompilations/sec, I did not see
it happening.
Is there another reason for why I need to use the username.sproc name ?
ThanksHassan
http://sqlblog.com/blogs/linchi_she...erver-2000.aspx
http://sqlblog.com/blogs/linchi_she...lification.aspx
"Hassan" <hassan@.test.com> wrote in message
news:u%23MdDtjMIHA.1204@.TK2MSFTNGP03.phx.gbl...
>I know it was best practise to call a stored procedure as
> "exec dbo.sproc" instead of "exec sproc"
> I guess it was in reference to compilations.
> But when i monitored compilations/sec and recompilations/sec, I did not
> see it happening.
> Is there another reason for why I need to use the username.sproc name ?
> Thanks
>|||how can i profile for sprocs that are not using dbo. ?
Is there an appropriate filter to search for exec [no dbo].sproc ?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ujmbZxlMIHA.6108@.TK2MSFTNGP03.phx.gbl...
> Hassan
> http://sqlblog.com/blogs/linchi_she...erver-2000.aspx
> http://sqlblog.com/blogs/linchi_she...lification.aspx
>
> "Hassan" <hassan@.test.com> wrote in message
> news:u%23MdDtjMIHA.1204@.TK2MSFTNGP03.phx.gbl...
>|||Hassan
Try filter on TextData NOT LIKE 'dbo%'
"Hassan" <hassan@.test.com> wrote in message
news:%23dbpD8wMIHA.536@.TK2MSFTNGP06.phx.gbl...
> how can i profile for sprocs that are not using dbo. ?
> Is there an appropriate filter to search for exec [no dbo].sproc ?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ujmbZxlMIHA.6108@.TK2MSFTNGP03.phx.gbl...
>
Showing posts with label instead. Show all posts
Showing posts with label instead. Show all posts
Thursday, March 29, 2012
exec stored procedure without qualifying dbo
I know it was best practise to call a stored procedure as
"exec dbo.sproc" instead of "exec sproc"
I guess it was in reference to compilations.
But when i monitored compilations/sec and recompilations/sec, I did not see
it happening.
Is there another reason for why I need to use the username.sproc name ?
ThanksHassan
http://sqlblog.com/blogs/linchi_shea/archive/2007/07/05/performance-impact-of-procedure-calls-without-owner-qualification-sql-server-2000.aspx
http://sqlblog.com/blogs/linchi_shea/archive/2007/06/30/performance-impact-of-procedure-calls-without-owner-qualification.aspx
"Hassan" <hassan@.test.com> wrote in message
news:u%23MdDtjMIHA.1204@.TK2MSFTNGP03.phx.gbl...
>I know it was best practise to call a stored procedure as
> "exec dbo.sproc" instead of "exec sproc"
> I guess it was in reference to compilations.
> But when i monitored compilations/sec and recompilations/sec, I did not
> see it happening.
> Is there another reason for why I need to use the username.sproc name ?
> Thanks
>|||how can i profile for sprocs that are not using dbo. ?
Is there an appropriate filter to search for exec [no dbo].sproc ?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ujmbZxlMIHA.6108@.TK2MSFTNGP03.phx.gbl...
> Hassan
> http://sqlblog.com/blogs/linchi_shea/archive/2007/07/05/performance-impact-of-procedure-calls-without-owner-qualification-sql-server-2000.aspx
> http://sqlblog.com/blogs/linchi_shea/archive/2007/06/30/performance-impact-of-procedure-calls-without-owner-qualification.aspx
>
> "Hassan" <hassan@.test.com> wrote in message
> news:u%23MdDtjMIHA.1204@.TK2MSFTNGP03.phx.gbl...
>>I know it was best practise to call a stored procedure as
>> "exec dbo.sproc" instead of "exec sproc"
>> I guess it was in reference to compilations.
>> But when i monitored compilations/sec and recompilations/sec, I did not
>> see it happening.
>> Is there another reason for why I need to use the username.sproc name ?
>> Thanks
>|||Hassan
Try filter on TextData NOT LIKE 'dbo%'
"Hassan" <hassan@.test.com> wrote in message
news:%23dbpD8wMIHA.536@.TK2MSFTNGP06.phx.gbl...
> how can i profile for sprocs that are not using dbo. ?
> Is there an appropriate filter to search for exec [no dbo].sproc ?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ujmbZxlMIHA.6108@.TK2MSFTNGP03.phx.gbl...
>> Hassan
>> http://sqlblog.com/blogs/linchi_shea/archive/2007/07/05/performance-impact-of-procedure-calls-without-owner-qualification-sql-server-2000.aspx
>> http://sqlblog.com/blogs/linchi_shea/archive/2007/06/30/performance-impact-of-procedure-calls-without-owner-qualification.aspx
>>
>> "Hassan" <hassan@.test.com> wrote in message
>> news:u%23MdDtjMIHA.1204@.TK2MSFTNGP03.phx.gbl...
>>I know it was best practise to call a stored procedure as
>> "exec dbo.sproc" instead of "exec sproc"
>> I guess it was in reference to compilations.
>> But when i monitored compilations/sec and recompilations/sec, I did not
>> see it happening.
>> Is there another reason for why I need to use the username.sproc name ?
>> Thanks
>>
>
"exec dbo.sproc" instead of "exec sproc"
I guess it was in reference to compilations.
But when i monitored compilations/sec and recompilations/sec, I did not see
it happening.
Is there another reason for why I need to use the username.sproc name ?
ThanksHassan
http://sqlblog.com/blogs/linchi_shea/archive/2007/07/05/performance-impact-of-procedure-calls-without-owner-qualification-sql-server-2000.aspx
http://sqlblog.com/blogs/linchi_shea/archive/2007/06/30/performance-impact-of-procedure-calls-without-owner-qualification.aspx
"Hassan" <hassan@.test.com> wrote in message
news:u%23MdDtjMIHA.1204@.TK2MSFTNGP03.phx.gbl...
>I know it was best practise to call a stored procedure as
> "exec dbo.sproc" instead of "exec sproc"
> I guess it was in reference to compilations.
> But when i monitored compilations/sec and recompilations/sec, I did not
> see it happening.
> Is there another reason for why I need to use the username.sproc name ?
> Thanks
>|||how can i profile for sprocs that are not using dbo. ?
Is there an appropriate filter to search for exec [no dbo].sproc ?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ujmbZxlMIHA.6108@.TK2MSFTNGP03.phx.gbl...
> Hassan
> http://sqlblog.com/blogs/linchi_shea/archive/2007/07/05/performance-impact-of-procedure-calls-without-owner-qualification-sql-server-2000.aspx
> http://sqlblog.com/blogs/linchi_shea/archive/2007/06/30/performance-impact-of-procedure-calls-without-owner-qualification.aspx
>
> "Hassan" <hassan@.test.com> wrote in message
> news:u%23MdDtjMIHA.1204@.TK2MSFTNGP03.phx.gbl...
>>I know it was best practise to call a stored procedure as
>> "exec dbo.sproc" instead of "exec sproc"
>> I guess it was in reference to compilations.
>> But when i monitored compilations/sec and recompilations/sec, I did not
>> see it happening.
>> Is there another reason for why I need to use the username.sproc name ?
>> Thanks
>|||Hassan
Try filter on TextData NOT LIKE 'dbo%'
"Hassan" <hassan@.test.com> wrote in message
news:%23dbpD8wMIHA.536@.TK2MSFTNGP06.phx.gbl...
> how can i profile for sprocs that are not using dbo. ?
> Is there an appropriate filter to search for exec [no dbo].sproc ?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ujmbZxlMIHA.6108@.TK2MSFTNGP03.phx.gbl...
>> Hassan
>> http://sqlblog.com/blogs/linchi_shea/archive/2007/07/05/performance-impact-of-procedure-calls-without-owner-qualification-sql-server-2000.aspx
>> http://sqlblog.com/blogs/linchi_shea/archive/2007/06/30/performance-impact-of-procedure-calls-without-owner-qualification.aspx
>>
>> "Hassan" <hassan@.test.com> wrote in message
>> news:u%23MdDtjMIHA.1204@.TK2MSFTNGP03.phx.gbl...
>>I know it was best practise to call a stored procedure as
>> "exec dbo.sproc" instead of "exec sproc"
>> I guess it was in reference to compilations.
>> But when i monitored compilations/sec and recompilations/sec, I did not
>> see it happening.
>> Is there another reason for why I need to use the username.sproc name ?
>> Thanks
>>
>
exec stored procedure without qualifying dbo
I know it was best practise to call a stored procedure as
"exec dbo.sproc" instead of "exec sproc"
I guess it was in reference to compilations.
But when i monitored compilations/sec and recompilations/sec, I did not see
it happening.
Is there another reason for why I need to use the username.sproc name ?
Thanks
Hassan
http://sqlblog.com/blogs/linchi_shea/archive/2007/07/05/performance-impact-of-procedure-calls-without-owner-qualification-sql-server-2000.aspx
http://sqlblog.com/blogs/linchi_shea/archive/2007/06/30/performance-impact-of-procedure-calls-without-owner-qualification.aspx
"Hassan" <hassan@.test.com> wrote in message
news:u%23MdDtjMIHA.1204@.TK2MSFTNGP03.phx.gbl...
>I know it was best practise to call a stored procedure as
> "exec dbo.sproc" instead of "exec sproc"
> I guess it was in reference to compilations.
> But when i monitored compilations/sec and recompilations/sec, I did not
> see it happening.
> Is there another reason for why I need to use the username.sproc name ?
> Thanks
>
|||how can i profile for sprocs that are not using dbo. ?
Is there an appropriate filter to search for exec [no dbo].sproc ?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ujmbZxlMIHA.6108@.TK2MSFTNGP03.phx.gbl...
> Hassan
> http://sqlblog.com/blogs/linchi_shea/archive/2007/07/05/performance-impact-of-procedure-calls-without-owner-qualification-sql-server-2000.aspx
> http://sqlblog.com/blogs/linchi_shea/archive/2007/06/30/performance-impact-of-procedure-calls-without-owner-qualification.aspx
>
> "Hassan" <hassan@.test.com> wrote in message
> news:u%23MdDtjMIHA.1204@.TK2MSFTNGP03.phx.gbl...
>
|||Hassan
Try filter on TextData NOT LIKE 'dbo%'
"Hassan" <hassan@.test.com> wrote in message
news:%23dbpD8wMIHA.536@.TK2MSFTNGP06.phx.gbl...
> how can i profile for sprocs that are not using dbo. ?
> Is there an appropriate filter to search for exec [no dbo].sproc ?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ujmbZxlMIHA.6108@.TK2MSFTNGP03.phx.gbl...
>
"exec dbo.sproc" instead of "exec sproc"
I guess it was in reference to compilations.
But when i monitored compilations/sec and recompilations/sec, I did not see
it happening.
Is there another reason for why I need to use the username.sproc name ?
Thanks
Hassan
http://sqlblog.com/blogs/linchi_shea/archive/2007/07/05/performance-impact-of-procedure-calls-without-owner-qualification-sql-server-2000.aspx
http://sqlblog.com/blogs/linchi_shea/archive/2007/06/30/performance-impact-of-procedure-calls-without-owner-qualification.aspx
"Hassan" <hassan@.test.com> wrote in message
news:u%23MdDtjMIHA.1204@.TK2MSFTNGP03.phx.gbl...
>I know it was best practise to call a stored procedure as
> "exec dbo.sproc" instead of "exec sproc"
> I guess it was in reference to compilations.
> But when i monitored compilations/sec and recompilations/sec, I did not
> see it happening.
> Is there another reason for why I need to use the username.sproc name ?
> Thanks
>
|||how can i profile for sprocs that are not using dbo. ?
Is there an appropriate filter to search for exec [no dbo].sproc ?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ujmbZxlMIHA.6108@.TK2MSFTNGP03.phx.gbl...
> Hassan
> http://sqlblog.com/blogs/linchi_shea/archive/2007/07/05/performance-impact-of-procedure-calls-without-owner-qualification-sql-server-2000.aspx
> http://sqlblog.com/blogs/linchi_shea/archive/2007/06/30/performance-impact-of-procedure-calls-without-owner-qualification.aspx
>
> "Hassan" <hassan@.test.com> wrote in message
> news:u%23MdDtjMIHA.1204@.TK2MSFTNGP03.phx.gbl...
>
|||Hassan
Try filter on TextData NOT LIKE 'dbo%'
"Hassan" <hassan@.test.com> wrote in message
news:%23dbpD8wMIHA.536@.TK2MSFTNGP06.phx.gbl...
> how can i profile for sprocs that are not using dbo. ?
> Is there an appropriate filter to search for exec [no dbo].sproc ?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ujmbZxlMIHA.6108@.TK2MSFTNGP03.phx.gbl...
>
Wednesday, March 7, 2012
EXCEPTION_ACCESS_VIOLATION
Hi,
using the SQL Server enterprise manager I try to creat a 'INSTEAD
OF'-trigger on a view. When I try to apply changes I get the error
EXCEPTION_ACCESS_VIOLATION. I use SQL Server 2000. Does enyone know what this
error is about? I've found almost no info using google.
//MagnusThese are most often bus in SQL Server (possibly data corruption, but not likely in this scenario).
If you didn't find anything on KB and you are current on service pack, I suggest you open a case
with MS.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Magnus Zotterman" <MagnusZotterman@.discussions.microsoft.com> wrote in message
news:6D3B4C3A-DC99-40EB-BB60-30A1979573D0@.microsoft.com...
> Hi,
> using the SQL Server enterprise manager I try to creat a 'INSTEAD
> OF'-trigger on a view. When I try to apply changes I get the error
> EXCEPTION_ACCESS_VIOLATION. I use SQL Server 2000. Does enyone know what this
> error is about? I've found almost no info using google.
> //Magnus|||Hi,Tibor
I am sure you meant bug instead of bus :)
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23p7KSHFsEHA.3324@.TK2MSFTNGP15.phx.gbl...
> These are most often bus in SQL Server (possibly data corruption, but not
likely in this scenario).
> If you didn't find anything on KB and you are current on service pack, I
suggest you open a case
> with MS.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Magnus Zotterman" <MagnusZotterman@.discussions.microsoft.com> wrote in
message
> news:6D3B4C3A-DC99-40EB-BB60-30A1979573D0@.microsoft.com...
> > Hi,
> > using the SQL Server enterprise manager I try to creat a 'INSTEAD
> > OF'-trigger on a view. When I try to apply changes I get the error
> > EXCEPTION_ACCESS_VIOLATION. I use SQL Server 2000. Does enyone know what
this
> > error is about? I've found almost no info using google.
> >
> > //Magnus
>|||:-)
Thanks for catching that, Uri.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Uri Dimant" <urid@.iscar.co.il> wrote in message news:uwE$NLFsEHA.1816@.TK2MSFTNGP09.phx.gbl...
> Hi,Tibor
> I am sure you meant bug instead of bus :)
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23p7KSHFsEHA.3324@.TK2MSFTNGP15.phx.gbl...
>> These are most often bus in SQL Server (possibly data corruption, but not
> likely in this scenario).
>> If you didn't find anything on KB and you are current on service pack, I
> suggest you open a case
>> with MS.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Magnus Zotterman" <MagnusZotterman@.discussions.microsoft.com> wrote in
> message
>> news:6D3B4C3A-DC99-40EB-BB60-30A1979573D0@.microsoft.com...
>> > Hi,
>> > using the SQL Server enterprise manager I try to creat a 'INSTEAD
>> > OF'-trigger on a view. When I try to apply changes I get the error
>> > EXCEPTION_ACCESS_VIOLATION. I use SQL Server 2000. Does enyone know what
> this
>> > error is about? I've found almost no info using google.
>> >
>> > //Magnus
>>
>|||Create it with QA.
Also see if you can create it from another EM client ..
"Magnus Zotterman" <MagnusZotterman@.discussions.microsoft.com> wrote in
message news:6D3B4C3A-DC99-40EB-BB60-30A1979573D0@.microsoft.com...
> Hi,
> using the SQL Server enterprise manager I try to creat a 'INSTEAD
> OF'-trigger on a view. When I try to apply changes I get the error
> EXCEPTION_ACCESS_VIOLATION. I use SQL Server 2000. Does enyone know what
this
> error is about? I've found almost no info using google.
> //Magnus
using the SQL Server enterprise manager I try to creat a 'INSTEAD
OF'-trigger on a view. When I try to apply changes I get the error
EXCEPTION_ACCESS_VIOLATION. I use SQL Server 2000. Does enyone know what this
error is about? I've found almost no info using google.
//MagnusThese are most often bus in SQL Server (possibly data corruption, but not likely in this scenario).
If you didn't find anything on KB and you are current on service pack, I suggest you open a case
with MS.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Magnus Zotterman" <MagnusZotterman@.discussions.microsoft.com> wrote in message
news:6D3B4C3A-DC99-40EB-BB60-30A1979573D0@.microsoft.com...
> Hi,
> using the SQL Server enterprise manager I try to creat a 'INSTEAD
> OF'-trigger on a view. When I try to apply changes I get the error
> EXCEPTION_ACCESS_VIOLATION. I use SQL Server 2000. Does enyone know what this
> error is about? I've found almost no info using google.
> //Magnus|||Hi,Tibor
I am sure you meant bug instead of bus :)
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23p7KSHFsEHA.3324@.TK2MSFTNGP15.phx.gbl...
> These are most often bus in SQL Server (possibly data corruption, but not
likely in this scenario).
> If you didn't find anything on KB and you are current on service pack, I
suggest you open a case
> with MS.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Magnus Zotterman" <MagnusZotterman@.discussions.microsoft.com> wrote in
message
> news:6D3B4C3A-DC99-40EB-BB60-30A1979573D0@.microsoft.com...
> > Hi,
> > using the SQL Server enterprise manager I try to creat a 'INSTEAD
> > OF'-trigger on a view. When I try to apply changes I get the error
> > EXCEPTION_ACCESS_VIOLATION. I use SQL Server 2000. Does enyone know what
this
> > error is about? I've found almost no info using google.
> >
> > //Magnus
>|||:-)
Thanks for catching that, Uri.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Uri Dimant" <urid@.iscar.co.il> wrote in message news:uwE$NLFsEHA.1816@.TK2MSFTNGP09.phx.gbl...
> Hi,Tibor
> I am sure you meant bug instead of bus :)
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23p7KSHFsEHA.3324@.TK2MSFTNGP15.phx.gbl...
>> These are most often bus in SQL Server (possibly data corruption, but not
> likely in this scenario).
>> If you didn't find anything on KB and you are current on service pack, I
> suggest you open a case
>> with MS.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Magnus Zotterman" <MagnusZotterman@.discussions.microsoft.com> wrote in
> message
>> news:6D3B4C3A-DC99-40EB-BB60-30A1979573D0@.microsoft.com...
>> > Hi,
>> > using the SQL Server enterprise manager I try to creat a 'INSTEAD
>> > OF'-trigger on a view. When I try to apply changes I get the error
>> > EXCEPTION_ACCESS_VIOLATION. I use SQL Server 2000. Does enyone know what
> this
>> > error is about? I've found almost no info using google.
>> >
>> > //Magnus
>>
>|||Create it with QA.
Also see if you can create it from another EM client ..
"Magnus Zotterman" <MagnusZotterman@.discussions.microsoft.com> wrote in
message news:6D3B4C3A-DC99-40EB-BB60-30A1979573D0@.microsoft.com...
> Hi,
> using the SQL Server enterprise manager I try to creat a 'INSTEAD
> OF'-trigger on a view. When I try to apply changes I get the error
> EXCEPTION_ACCESS_VIOLATION. I use SQL Server 2000. Does enyone know what
this
> error is about? I've found almost no info using google.
> //Magnus
Wednesday, February 15, 2012
Excel headers - using SimplePageHeaders deviceinfo setting
I want to try out placing the report header in the Excel page header instead of the worksheet. I have seen forum references to updating the config files to switch on SimplePageHeaders deviceinfo setting, but I can find no reference to this in the documentation and it appears to be ignored when I try it out. Is this in RS 2005 only? (I'm using 2000 SP2).
Would this get round my current problem of having lots of additional columns/merged cells to accommodate all the header layout when exported to Excel? Ideally I want the data structure in Excel to be a straight forward matrix of the data values in the report table which isn't feasible when exported to Excel with our default headers which contains a lot of labels containing context information.
I am pretty sure this is new in 2005. and yes, it would help you get past your merged cell problem.Excel headers - using SimplePageHeaders deviceinfo setting
I want to try out placing the report header in the Excel page header instead of the worksheet. I have seen forum references to updating the config files to switch on SimplePageHeaders deviceinfo setting, but I can find no reference to this in the documentation and it appears to be ignored when I try it out. Is this in RS 2005 only? (I'm using 2000 SP2).
Would this get round my current problem of having lots of additional columns/merged cells to accommodate all the header layout when exported to Excel? Ideally I want the data structure in Excel to be a straight forward matrix of the data values in the report table which isn't feasible when exported to Excel with our default headers which contains a lot of labels containing context information.
I am pretty sure this is new in 2005. and yes, it would help you get past your merged cell problem.
Subscribe to:
Posts (Atom)