Click here to Skip to main content
15,922,407 members
Home / Discussions / Database
   

Database

 
GeneralRe: Change cursor to common table Pin
Amr Mohammad17-Dec-14 3:32
Amr Mohammad17-Dec-14 3:32 
QuestionHow can you tell if a SQL Server instance max'ed out bottleneck is Memory? Pin
devvvy11-Dec-14 4:20
devvvy11-Dec-14 4:20 
AnswerRe: How can you tell if a SQL Server instance max'ed out bottleneck is Memory? Pin
Tim Carmichael11-Dec-14 4:23
Tim Carmichael11-Dec-14 4:23 
GeneralRe: How can you tell if a SQL Server instance max'ed out bottleneck is Memory? Pin
M Riaz Bashir11-Dec-14 15:07
M Riaz Bashir11-Dec-14 15:07 
QuestionMySQL Export Problem Pin
M Riaz Bashir10-Dec-14 22:46
M Riaz Bashir10-Dec-14 22:46 
AnswerRe: MySQL Export Problem Pin
Eddy Vluggen11-Dec-14 4:59
professionalEddy Vluggen11-Dec-14 4:59 
QuestionDatabase Mail Not sending Email Pin
Robymon8-Dec-14 20:56
Robymon8-Dec-14 20:56 
QuestionDo I have to have SQL Server Express installed? Pin
jkirkerx30-Nov-14 11:31
professionaljkirkerx30-Nov-14 11:31 
I wanted to add database services to my windows app, but didn't want to use SQL Server, Access or even a DBF file would of been fine.

So the code below works fine, creates a database file, but off the top of your head, will I need to have sql server installed on other client machines?


Dim m_connString As String = "Data Source=(LocalDB)\v11.0; Integrated Security=True;"
        Dim myConnection As SqlConnection = New SqlConnection(m_connString)

        Dim myQueryString As String = _
        "CREATE DATABASE STREAKWAVE ON PRIMARY " & _
        "( " & _
        "   NAME = STREAKWAVE, " & _
        "   FILENAME = '" & m_storagePath & "\STREAKWAVE.mdf', " & _
        "   SIZE = 10MB, " & _
        "   MAXSIZE = 500MB, " & _
        "   FILEGROWTH = 10% " &
        ") " & _
        " LOG ON " & _
        "( " & _
        "   NAME = STREAKWAVE_Log, " & _
        "   FILENAME = '" & m_storagePath & "\STREAKWAVE.ldf', " & _
        "   SIZE = 1MB, " & _
        "   MAXSIZE = 500MB, " & _
        "   FILEGROWTH = 10% " & _
        ") "

AnswerRe: Do I have to have SQL Server Express installed? Pin
Richard MacCutchan30-Nov-14 21:30
mveRichard MacCutchan30-Nov-14 21:30 
GeneralRe: Do I have to have SQL Server Express installed? Pin
jkirkerx2-Dec-14 10:21
professionaljkirkerx2-Dec-14 10:21 
AnswerRe: Do I have to have SQL Server Express installed? Pin
Eddy Vluggen2-Dec-14 7:27
professionalEddy Vluggen2-Dec-14 7:27 
GeneralRe: Do I have to have SQL Server Express installed? Pin
jkirkerx2-Dec-14 10:25
professionaljkirkerx2-Dec-14 10:25 
Questionsql server import export wizard stored procedure? Pin
iamvinod3426-Nov-14 18:57
iamvinod3426-Nov-14 18:57 
AnswerRe: sql server import export wizard stored procedure? Pin
Mycroft Holmes26-Nov-14 20:09
professionalMycroft Holmes26-Nov-14 20:09 
AnswerRe: sql server import export wizard stored procedure? Pin
jschell27-Nov-14 6:02
jschell27-Nov-14 6:02 
QuestionNeed to Truncate a table and populate the rest of the tables Pin
Hari-CodeBlogger25-Nov-14 0:30
Hari-CodeBlogger25-Nov-14 0:30 
QuestionRe: Need to Truncate a table and populate the rest of the tables Pin
Shweta N Mishra26-Nov-14 4:35
professionalShweta N Mishra26-Nov-14 4:35 
QuestionJoining three tables in sql server 2012 Pin
umair275624-Nov-14 4:06
professionalumair275624-Nov-14 4:06 
AnswerRe: Joining three tables in sql server 2012 Pin
Simon_Whale24-Nov-14 4:56
Simon_Whale24-Nov-14 4:56 
AnswerRe: Joining three tables in sql server 2012 Pin
Eddy Vluggen24-Nov-14 7:36
professionalEddy Vluggen24-Nov-14 7:36 
AnswerRe: Joining three tables in sql server 2012 Pin
Jörgen Andersson24-Nov-14 21:47
professionalJörgen Andersson24-Nov-14 21:47 
AnswerRe: Joining three tables in sql server 2012 Pin
syed shanu30-Nov-14 22:13
professionalsyed shanu30-Nov-14 22:13 
Questionclustering index Pin
Amr Mohammad23-Nov-14 9:04
Amr Mohammad23-Nov-14 9:04 
AnswerRe: clustering index Pin
PIEBALDconsult23-Nov-14 9:12
mvePIEBALDconsult23-Nov-14 9:12 
GeneralRe: clustering index Pin
Amr Mohammad23-Nov-14 9:31
Amr Mohammad23-Nov-14 9:31 

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.