Click here to Skip to main content
15,509,907 members
Home / Discussions / Database
   

Database

 
QuestionCombine results from 2 foxpro DBF files using union Pin
jkirkerx27-Oct-14 13:30
professionaljkirkerx27-Oct-14 13:30 
AnswerMakes no sense how it works Pin
jkirkerx27-Oct-14 14:01
professionaljkirkerx27-Oct-14 14:01 
QuestionSelect count on 2 DBF files Pin
jkirkerx27-Oct-14 12:11
professionaljkirkerx27-Oct-14 12:11 
GeneralRe: Select count on 2 DBF files Pin
PIEBALDconsult27-Oct-14 12:25
professionalPIEBALDconsult27-Oct-14 12:25 
GeneralRe: Select count on 2 DBF files Pin
jkirkerx27-Oct-14 13:23
professionaljkirkerx27-Oct-14 13:23 
QuestionRewrit a Scalar function to a table valued function Pin
Ambertje21-Oct-14 1:00
Ambertje21-Oct-14 1:00 
AnswerRe: Rewrit a Scalar function to a table valued function Pin
Mycroft Holmes21-Oct-14 1:25
professionalMycroft Holmes21-Oct-14 1:25 
GeneralRe: Rewrit a Scalar function to a table valued function Pin
Ambertje21-Oct-14 2:40
Ambertje21-Oct-14 2:40 
I'm working with Microsoft SQL Server Management Studio, I've searched for the profiler but can't find it.

Do you mean an SQL Server Profiler?
Can you give me an example or a link to where I can find that please?


This is what I get when I Set Statistics IO and Time ON:
Table 'Worktable'. Scan count 252, logical reads 20839, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'AD'. Scan count 1, logical reads 109674, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'D_Article'. Scan count 1, logical reads 729, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'porcKD'. Scan count 1, logical reads 1473, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

 SQL Server Execution Times:
   CPU time = 91947 ms,  elapsed time = 119500 ms.



I wanted to create indexes on the View but a View doesn't allow to create indexes.
The view gets the data out of the bottom (STAGING) area in the form of text files.
The View is used to load the data through SSIS in TOP area (DWH)

No table in the Staging area contains indexes.
GeneralRe: Rewrit a Scalar function to a table valued function Pin
Richard Deeming21-Oct-14 3:00
mveRichard Deeming21-Oct-14 3:00 
GeneralRe: Rewrit a Scalar function to a table valued function Pin
Ambertje21-Oct-14 3:25
Ambertje21-Oct-14 3:25 
GeneralRe: Rewrit a Scalar function to a table valued function Pin
Mycroft Holmes21-Oct-14 13:52
professionalMycroft Holmes21-Oct-14 13:52 
SuggestionRe: Rewrit a Scalar function to a table valued function Pin
Richard Deeming21-Oct-14 2:55
mveRichard Deeming21-Oct-14 2:55 
AnswerRe: Rewrit a Scalar function to a table valued function Pin
Eddy Vluggen21-Oct-14 3:33
professionalEddy Vluggen21-Oct-14 3:33 
QuestionStored Procedure for Item Allotment Pin
avisharma@sharma19-Oct-14 21:01
avisharma@sharma19-Oct-14 21:01 
QuestionRe: Stored Procedure for Item Allotment Pin
Jörgen Andersson19-Oct-14 22:22
professionalJörgen Andersson19-Oct-14 22:22 
AnswerRe: Stored Procedure for Item Allotment Pin
avisharma@sharma20-Oct-14 0:04
avisharma@sharma20-Oct-14 0:04 
GeneralRe: Stored Procedure for Item Allotment Pin
Shweta N Mishra20-Oct-14 3:24
professionalShweta N Mishra20-Oct-14 3:24 
GeneralRe: Stored Procedure for Item Allotment Pin
avisharma@sharma27-Oct-14 3:42
avisharma@sharma27-Oct-14 3:42 
GeneralRe: Stored Procedure for Item Allotment Pin
Shweta N Mishra27-Oct-14 4:37
professionalShweta N Mishra27-Oct-14 4:37 
GeneralRe: Stored Procedure for Item Allotment Pin
Jörgen Andersson20-Oct-14 5:53
professionalJörgen Andersson20-Oct-14 5:53 
QuestionCheck if email for each specific recipient was sent or not sql server 2008 Pin
bjay tiamsic19-Oct-14 1:25
bjay tiamsic19-Oct-14 1:25 
AnswerRe: Check if email for each specific recipient was sent or not sql server 2008 Pin
Wendelius19-Oct-14 1:41
mveWendelius19-Oct-14 1:41 
GeneralRe: Check if email for each specific recipient was sent or not sql server 2008 Pin
bjay tiamsic19-Oct-14 18:58
bjay tiamsic19-Oct-14 18:58 
GeneralRe: Check if email for each specific recipient was sent or not sql server 2008 Pin
Wendelius19-Oct-14 19:20
mveWendelius19-Oct-14 19:20 
SuggestionRe: Check if email for each specific recipient was sent or not sql server 2008 Pin
Richard Deeming20-Oct-14 3:16
mveRichard Deeming20-Oct-14 3:16 

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.