Click here to Skip to main content
15,867,756 members
Home / Discussions / Database
   

Database

 
GeneralRe: I Think I May Go Back To MS Access - Solution Found! Pin
Roger Wright2-Apr-10 19:24
professionalRoger Wright2-Apr-10 19:24 
GeneralRe: I Think I May Go Back To MS Access - Solution NOT Found! Pin
Luc Pattyn2-Apr-10 19:40
sitebuilderLuc Pattyn2-Apr-10 19:40 
GeneralRe: I Think I May Go Back To MS Access - Solution Almost Found! Pin
Roger Wright2-Apr-10 20:07
professionalRoger Wright2-Apr-10 20:07 
GeneralRe: I Think I May Go Back To MS Access - Solution Almost Found! Pin
Mycroft Holmes2-Apr-10 22:27
professionalMycroft Holmes2-Apr-10 22:27 
AnswerRe: I Think I May Go Back To MS Access Pin
PIEBALDconsult4-Apr-10 16:21
mvePIEBALDconsult4-Apr-10 16:21 
QuestionUse of Temperory Table in SQL Server 2005 Pin
Manish_Kumar_Nayak1-Apr-10 3:15
Manish_Kumar_Nayak1-Apr-10 3:15 
AnswerRe: Use of Temperory Table in SQL Server 2005 Pin
dan!sh 1-Apr-10 3:35
professional dan!sh 1-Apr-10 3:35 
QuestionSlow Performance of using EXECUTE sp_executesql Pin
HatakeKaKaShi31-Mar-10 20:41
HatakeKaKaShi31-Mar-10 20:41 
HI Guys need ur advise here

I am facing this issue that when i use the sp_executesql to execute my statement, the query time is way longer then normal.

Previously i am using this methed in stored procedure

simpely coding the statement

SELECT * FROM Bla Bla

but when i change to using

DECLARE @SQL AS NVARCHAR(MAX)
SET @SQL = 'SELECT * FROM bla bla Table'

EXECUTE sp_executesql @SQL

the query time slow down greatly
i change to using sp_executesql because i need to create the STATEMENT base on some condition checking
will be gald if u guys have any advise

Thanks a million

KaKaShi HaTaKe
AnswerRe: Slow Performance of using EXECUTE sp_executesql Pin
dan!sh 31-Mar-10 21:39
professional dan!sh 31-Mar-10 21:39 
AnswerRe: Slow Performance of using EXECUTE sp_executesql Pin
Mycroft Holmes1-Apr-10 0:20
professionalMycroft Holmes1-Apr-10 0:20 
GeneralRe: Slow Performance of using EXECUTE sp_executesql Pin
dan!sh 1-Apr-10 3:32
professional dan!sh 1-Apr-10 3:32 
QuestionLog in problem in SQL Server Management Studio 2008 Pin
John.L.Ponratnam31-Mar-10 19:17
John.L.Ponratnam31-Mar-10 19:17 
AnswerRe: Log in problem in SQL Server Management Studio 2008 Pin
R. Giskard Reventlov31-Mar-10 23:53
R. Giskard Reventlov31-Mar-10 23:53 
QuestionReading Basic PDS ISAM Files Pin
rmiller1031-Mar-10 8:44
rmiller1031-Mar-10 8:44 
AnswerRe: Reading Basic PDS ISAM Files [modified] Pin
PIEBALDconsult31-Mar-10 15:22
mvePIEBALDconsult31-Mar-10 15:22 
GeneralRe: Reading Basic PDS ISAM Files Pin
rmiller101-Apr-10 4:50
rmiller101-Apr-10 4:50 
GeneralRe: Reading Basic PDS ISAM Files Pin
PIEBALDconsult1-Apr-10 9:35
mvePIEBALDconsult1-Apr-10 9:35 
GeneralRe: Reading Basic PDS ISAM Files Pin
rmiller101-Apr-10 9:42
rmiller101-Apr-10 9:42 
GeneralRe: Reading Basic PDS ISAM Files [modified] Pin
PIEBALDconsult1-Apr-10 13:50
mvePIEBALDconsult1-Apr-10 13:50 
GeneralRe: Reading Basic PDS ISAM Files Pin
PIEBALDconsult1-Apr-10 14:31
mvePIEBALDconsult1-Apr-10 14:31 
GeneralRe: Reading Basic PDS ISAM Files Pin
rmiller107-Apr-10 9:48
rmiller107-Apr-10 9:48 
AnswerRe: Reading Basic PDS ISAM Files Pin
Luc Pattyn1-Apr-10 11:10
sitebuilderLuc Pattyn1-Apr-10 11:10 
GeneralRe: Reading Basic PDS ISAM Files Pin
PIEBALDconsult1-Apr-10 13:42
mvePIEBALDconsult1-Apr-10 13:42 
GeneralRe: Reading Basic PDS ISAM Files Pin
Luc Pattyn1-Apr-10 13:57
sitebuilderLuc Pattyn1-Apr-10 13:57 
AnswerRe: Reading Basic PDS ISAM Files [modified] Pin
PIEBALDconsult4-Apr-10 14:45
mvePIEBALDconsult4-Apr-10 14:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.