Startup parameter
Mon, 22 Feb 2010 11:40:12 +0100
Dear ALL,
I have a MS SQL Server 2000 SP4 but it starts with -T9059 parameter, so it
should start using SP3 mode.
I'd like to know if I can turn back without -T9059 or databases and indexes
need some operations.
Regards
...
|
Installing SQL 2000 and SQL 2008 on the same server ?
Mon, 22 Feb 2010 02:37:01 -0800
Hello,
I have a small question, is it possible to install a SQL server 2000 and a
sql 2008 server on the same server with Windows 2008 server ?
For sql2005 ans 2008 it's ok
(http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/6cd82ab9-cc97-46b4-bd65-ce5ac23bd6e2/) but for sql 2000?
T ...
|
SQL server 2008 Traces
Mon, 22 Feb 2010 02:14:02 -0800
hi All,
I am not able to query trace files(.trc) with fn_trace_gettable.
Background is like
I have creates 10 trace files and I have been trying to query it with
fn_trace_gettable function however I am getting an error
" File 'F:\02192010_170130.trc' either does not exist or is not a
recognizable tra ...
|
Performance issue
Mon, 22 Feb 2010 17:09:13 +0800
Hi all,
In order to improve SP performance, i will add print statement with
timestamp up to millisecond
PRINT 'Store procedure part 1: ' + CONVERT(CHAR(23), GETDATE(), 121)
PRINT 'Store procedure part 2: ' + CONVERT(CHAR(23), GETDATE(), 121)
and then find out which SQL statement take more time to execute.
...
|
Index statistics not updated ?
Mon, 22 Feb 2010 10:05:49 +0100
Hello
When querying the table sys.dm_db_index_physical_stats for information about
index fragmentation, I get a row concerning the indexid 1 of msdb being
about 60% fragmented. Well, I run a job to rebuild the index ... and the
query always shows 60% of fragmentation on the same index of msdb.
I tried to do ...
|
How to send a query result via Database Mail ?
Mon, 22 Feb 2010 19:12:04 +1100
There is a request to run a specific query and sent to end user.
We are new to SQL Server 2005 and would like to seek your advice:
1) Is it a good idea to use SSIS package to run the script ?
2) Should we send the query result from 1) and sent to end user by
Database Mail ?
3) Is there any reference so tha ...
|
SQL Server DTS import speed
Mon, 22 Feb 2010 15:16:57 +0800
Hi all,
i am not sure my question belongs to this group ...
In SQL server, if import file through DTS, the speed is very very fast, 7000
records can be completed in 1 second. Is there any special option use by DTS
so that the speed is so fast?
Either the read file speed or the data insert into DB, the speed ...
|
|
|
Replication Issue
Sun, 21 Feb 2010 11:22:01 -0800
My distribution server failed. Because of that my publishing database log
file will not shrink because it is waiting to push out the transactions. I
re-set up the distributer, all linked servers and logins. I still get the
error below when I try to drop or do anything that matter to make
replicxation work.
...
|
Hash indexes
Sun, 21 Feb 2010 10:05:45 -0800
I found http://msdn.microsoft.com/en-us/library/ms189788.aspx in 2008 BOL,
which talks about CHECKSUM and creating hash indexes.
I remember hash indexes from college and the old Unify Excel database had
them too. However, the last I recall, b+-trees were shown to out perform
them.
So, I'm curious, why ar ...
|
SQL Server User Groups
Sun, 21 Feb 2010 09:28:56 -0800
I'm trying to find, or maybe start, a SQL Server user group in Sacramento,
CA. Web searches have been of minimal help, though I did find
http://sqlserver.meetup.com/cities/us/ca/sacramento/ and LinkedIn produced
an interesting list of SQL Server people in Sac.
Searching the Microsoft site produced very litt ...
|
