SQL Server Performance

Search Results

Search Again
  1. hayko98

    linked server

    Thread by: hayko98, Apr 19, 2012, 1 replies, in forum: ALL SQL SERVER QUESTIONS
    I created linked server using following script On my dev server: EXEC sp_addlinkedserver @server='prd' ,@provider='SQLNCLI' ,@srvproduct=''...
  2. hayko98

    Execution Time

    Thread by: hayko98, Mar 15, 2012, 3 replies, in forum: ALL SQL SERVER QUESTIONS
    Hi All I run a query that runs 54 sec.If i run it again (without changing anything) it runs 94 sec.Then 54 sec,then 420 sec,then 52 sec......Any idea...
  3. hayko98

    how to change log file's settings

    Thread by: hayko98, Feb 8, 2012, 3 replies, in forum: ALL SQL SERVER QUESTIONS
    Hi all, I created datebase(SQl 2008) and placed my mdf file in F drive ,ldf file in G drive.I am trying to increse log files size.When i go to...
  4. hayko98

    export to CSV file without column headers

    Thread by: hayko98, Jan 30, 2012, 4 replies, in forum: ALL SQL SERVER QUESTIONS
    Hi all, I am trying to create a report and export to CSV file without column headers.When i run the query from SSMS and 'SAVE RESULTS AS..' CSV or...
  5. hayko98

    cursors vs cross apply

    Thread by: hayko98, Feb 10, 2011, 2 replies, in forum: SQL Server 2008 General Developer Questions
    Hi all, I use cursor to find the zone name for pickup addresses(which zone this Pickup address belogs to).I have map table(SA_union) which has...
Showing results 1 to 5 of 5
Search Again