Click here to Skip to main content
15,113,498 members
Home / Discussions / Database
   

Database

 
QuestionChange cursor to common table Pin
Amr Mohammad15-Dec-14 2:16
MemberAmr Mohammad15-Dec-14 2:16 
SuggestionRe: Change cursor to common table Pin
Richard Deeming15-Dec-14 3:56
mveRichard Deeming15-Dec-14 3:56 
GeneralRe: Change cursor to common table Pin
Amr Mohammad15-Dec-14 9:22
MemberAmr Mohammad15-Dec-14 9:22 
AnswerRe: Change cursor to common table Pin
Richard Deeming15-Dec-14 11:32
mveRichard Deeming15-Dec-14 11:32 
GeneralRe: Change cursor to common table Pin
Amr Mohammad16-Dec-14 22:40
MemberAmr Mohammad16-Dec-14 22:40 
GeneralRe: Change cursor to common table Pin
Richard Deeming17-Dec-14 3:05
mveRichard Deeming17-Dec-14 3:05 
GeneralRe: Change cursor to common table Pin
Amr Mohammad17-Dec-14 4:32
MemberAmr Mohammad17-Dec-14 4:32 
QuestionHow can you tell if a SQL Server instance max'ed out bottleneck is Memory? Pin
devvvy11-Dec-14 5:20
Memberdevvvy11-Dec-14 5:20 
hi - How can you tell if a SQL Server instance max'ed out bottleneck is Memory? It's on a 8GB box with two processors. Seems CPU ok. Memory max out the whole time while this big SELECT-INTO statement is running. Avg Disk Queue lenght ok - avg below 1.0 so doesn't appear disk/paging is causing problem.

However, fact from Task Manager memory keeps 7 GB out of 8GB over the whole time doesn't mean memory is the bottleneck? Or is it?

The same query runs on another SQL server with double the RAM finishes a few times quicker however.

Any advises? Thanks
dev

AnswerRe: How can you tell if a SQL Server instance max'ed out bottleneck is Memory? Pin
Tim Carmichael11-Dec-14 5:23
MemberTim Carmichael11-Dec-14 5:23 
GeneralRe: How can you tell if a SQL Server instance max'ed out bottleneck is Memory? Pin
M Riaz Bashir11-Dec-14 16:07
MemberM Riaz Bashir11-Dec-14 16:07 
QuestionMySQL Export Problem Pin
M Riaz Bashir10-Dec-14 23:46
MemberM Riaz Bashir10-Dec-14 23:46 
AnswerRe: MySQL Export Problem Pin
Eddy Vluggen11-Dec-14 5:59
professionalEddy Vluggen11-Dec-14 5:59 
QuestionDatabase Mail Not sending Email Pin
Robymon8-Dec-14 21:56
MemberRobymon8-Dec-14 21:56 
QuestionDo I have to have SQL Server Express installed? Pin
jkirkerx30-Nov-14 12:31
professionaljkirkerx30-Nov-14 12:31 
AnswerRe: Do I have to have SQL Server Express installed? Pin
Richard MacCutchan30-Nov-14 22:30
mveRichard MacCutchan30-Nov-14 22:30 
GeneralRe: Do I have to have SQL Server Express installed? Pin
jkirkerx2-Dec-14 11:21
professionaljkirkerx2-Dec-14 11:21 
AnswerRe: Do I have to have SQL Server Express installed? Pin
Eddy Vluggen2-Dec-14 8:27
professionalEddy Vluggen2-Dec-14 8:27 
GeneralRe: Do I have to have SQL Server Express installed? Pin
jkirkerx2-Dec-14 11:25
professionaljkirkerx2-Dec-14 11:25 
Questionsql server import export wizard stored procedure? Pin
iamvinod3426-Nov-14 19:57
Memberiamvinod3426-Nov-14 19:57 
AnswerRe: sql server import export wizard stored procedure? Pin
Mycroft Holmes26-Nov-14 21:09
professionalMycroft Holmes26-Nov-14 21:09 
AnswerRe: sql server import export wizard stored procedure? Pin
jschell27-Nov-14 7:02
Memberjschell27-Nov-14 7:02 
QuestionNeed to Truncate a table and populate the rest of the tables Pin
Hari-CodeBlogger25-Nov-14 1:30
MemberHari-CodeBlogger25-Nov-14 1:30 
QuestionRe: Need to Truncate a table and populate the rest of the tables Pin
Shweta N Mishra26-Nov-14 5:35
professionalShweta N Mishra26-Nov-14 5:35 
QuestionJoining three tables in sql server 2012 Pin
umair275624-Nov-14 5:06
professionalumair275624-Nov-14 5:06 
AnswerRe: Joining three tables in sql server 2012 Pin
Simon_Whale24-Nov-14 5:56
professionalSimon_Whale24-Nov-14 5:56 

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.