Search Results | SQL Server Performance Forums

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=''...

Execution Time

Post by: hayko98, Mar 15, 2012 in forum: ALL SQL SERVER QUESTIONS

Never Mind

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...

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...

export to CSV file without column headers

Post by: hayko98, Jan 31, 2012 in forum: ALL SQL SERVER QUESTIONS

Thank you guys all for for your responds. I am running SQL 2008 developers eddition. I used Export Data to create SSIS pakage.I saved (file system)...

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...

cursors vs cross apply

Post by: hayko98, Feb 11, 2011 in forum: SQL Server 2008 General Developer Questions

Thank You for your respond. This is what i come up with(Thanks to Erland Sommarskog).Now it runs in 4 sec!!!SET NOCOUNT on DECLARE @T AS TABLE(...

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...