|
When you have a query or stored procedure that needs performance tuning, what are some of the first things you try?
Started by Terrapin on
, 31 posts
by 26 people.
Answer Snippets (Read the full thread at stackoverflow):
The deleted records) Rebuild Indexes Rebuild Tables (bcp data out/in) Dump / Reload the database is going on with the query, make sure that the indexes are being used as efficiently as possible EXPLAIN to find out what is going on....
|
|
I have a query that has approx 20 columns and I would like to export this to an Excel file with the column headers. I thought this would be easy to figure out but no luck! I searched the web and found one suggestion that did not end up working so I am...
Started by Mark Kadlec on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
EXEC sp the currently configured....
Weblogs.sqlteam.com/brettk/archive/2005/04/13/4395.aspx
EDIT:
The example uses BCP, and to get it to work you may have headers) to better understand what BCP does:
-- To allow advanced options to be changed.
|
|
这个是我从Manual上copy下来的，希望对大家有用。
bcp
Description
Copies a database to or from an operating system file in a user-specified format.
Syntax
bcp [[database_name.]owner.][view_name | table_name [:partition_id]] {in | out} datafile[-c] [-E] [-n] [-X]
[-a display...
Answer Snippets (Read the full thread at chinaunix):
怎不弄个中文的？读起太慢了！ 很好的东西。 有中文的早就弄上去了。 用BCP可以字段级选择记录吗？ 在sybase网站上有PDF格式的中文文档 给一个下载地址啊！^_^谢谢了 下面引用由 klutz 在 2002/10/22 11:17am 发表的内容：
用BCP可以字段级选择记录吗？.
|
Ask your Facebook Friends
|
On Wed, 15 Oct 2008 09:23:02 -0700, pensio <pensio@community.nospam
I'm using bcp command to export a sql server table to an excel sheet. I've
created a bcp format file to use with the command. It looks like this :
9.0
5
1 SQLCHAR ...
Started by pensio on
, 5 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
For example:
bcp://msdn.microsoft.com/en-us/library/ms191516.aspx
bcp dataBaseX.dbo.FileToExport nul -T -N -f c:\bcp.fmt
3 run the command
....
Type by ' , Copying data from a query to the excel sheet could be a
solution also.
|
|
Interview questions for ASE DBAs
This page contains some suggestions for questions to ask when interviewing an applicant for a Sybase ASE DBA job. There are also some questions the candidate might want to ask before (s)he takes the job (see the end of...
Answer Snippets (Read the full thread at chinaunix):
是的对DBA‘S 读英文很重要，.
|
|
I have to run few SQL queries and put the results into a spreadsheet. Since I am on a Spring/Java environment, I was about to run the queries using JDBC, iterate through the ResultSet, and use Jakarta POI to create a simple XLS.
This looks like a very...
Started by binil on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
" Export Data From SQL Server 2005 to Microsoft Excel Datasheet " If you use something other than MS SQL Server 2005, you can still create a query within Excel to any ODBC data source, and write ....
Workbook and dump data into it directly.
|
|
On Mon, 19 Jan 2009 18:12:23 -0500, Rick <rick@invalid.net
We're stuck in the bad old days of SQL 2000 and I've been specifically
asked to use OSQL to write the output of a SQL statement to a text file.
It's a very simple statement --
SELECT...
Started by Rick on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
INTO, and then use bcp to bulk dump
the table??
Make a batch file with your OSQL line something like the one below
osql = 'A'
bcp YourDatabase.dbo....
Use SELECT ...
Before your sql statement?
maybe instead...
NOCOUNT ON;
...
|
|
I have a ridiculously long xml row, it has > 8 characters. The 'client' is also the 'server'. The OS is windows 2k8 x64. The database has plenty of memory as does the client.
The problem is that once i hit some magic number of characters - exactly ...
Started by dovholuk on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You have 2 separate issues I think:
SSMS behaviour xml comversion SSMS behaviour
Try bcp to dump.
|
|
I have a mobile application. My client has a large data set ~100.000 records. It's updated frequently. When we sync we need to copy from one database to another.
I have attached the second database to the main, and run an insert into table select * from...
Started by Pentium10 on
, 10 posts
by 10 people.
Answer Snippets (Read the full thread at stackoverflow):
Dump the database in an SQL.
In sqlite, these are usually pretty fast:
.dump ?TABLE? ...
To the command bcp )
you can also disable/remove the non-clustered indexes before inserting, and re-create them after.
|
|
On 18 Nov 2009 11:21:44 -0800, "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com
You'll have to define 'upgrade'.
If you're referring simply to the sqlupgrade step ... assuming all preupgrade issues have been addressed ... assuming no
show...
Started by Mark A. Parsons on
, 10 posts
by 5 people.
Answer Snippets (Read the full thread at omgili):
My the same query is changed to a "select into"
referencing the same table (everything remains the same query works
fine, there....
I later did a bcp out of the other two tables into one
table.
By running 3 select into queries.
|
