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 ...
|
Monitor locks and transaction
Sat, 20 Feb 2010 11:57:45 -0800 (PST)
Hi guys,
I'm using SQL profiler for monitor locks but when I try to identify
transaction text from the transaction id it does not return any row
(cache expired?).
Ho I can monitor and register which transaction cause a lock?
thanks very much
Andrew ...
|
set limit for one year prior
Sat, 20 Feb 2010 11:26:01 -0800
trying to write a query to select occupdate for one year prior to toustartdate
where occupdate < (toustartdate - 365)
where occupdate < (toustartdate - 1 year)
don't work
I'm sure it's a simple solution - can someone help me out.
...
|
