Viewing 15 posts - 3,391 through 3,405 (of 7,503 total)
I only noticed this on my laptop, which is becomming slow, so I'm not surprised this may occur because of timeouts.
The instances on my laptop (sql2000 / sql2005 / sql2008)...
October 21, 2009 at 12:37 am
did you receive messages about databases that couldn't be opened due to insufficient resources or disk space ?
I have this occasionally on my laptop, and then I don't trust what...
October 20, 2009 at 9:44 am
It is good to take tempdb in your control.
you should find traces of your operation in the default trace of your instance.
- can you provide @@version info of your instance...
October 20, 2009 at 8:00 am
BOL has all info I have 😉
http://msdn.microsoft.com/en-us/library/ms188755.aspx
Keep in mind a stop/restart of your sqlserver instance will reset these data !!
If you want this info long term, you'll have to...
October 20, 2009 at 7:48 am
Have fun !
I hope I'll get a new occasion next year.
October 20, 2009 at 7:42 am
-- list most used tables
-- SQLServermagazine instantDoc 53878
--
SELECT
t.name AS 'Table',
SUM(i.user_seeks + i.user_scans + i.user_lookups) AS 'Total_accesses',
SUM(i.user_seeks) AS 'Seeks',
SUM(i.user_scans) AS 'Scans',
SUM(i.user_lookups) AS 'Lookups'
, min(s.login_time) as StartUp_DateTime
, min(s.Years) as ServerUp_Years
,...
October 19, 2009 at 12:30 pm
-did you execute the sproc via SSMS or via another app ?
What were the connection isolation level settings?
October 19, 2009 at 12:26 pm
Strange indeed if that user is the actual db owner!
Did you doublecheck the default schema ?
I would try the primitive way and script the full database (with all users and...
October 19, 2009 at 12:02 pm
maybe this ref will shed a good light on the issue.......
October 18, 2009 at 12:46 pm
Oh yes... Distributed transactions ...
If the app is killed (client side), msdtc can get stuck and sqlserver will need a non-standard way to get rid of the pending lock(s).
the...
October 18, 2009 at 6:56 am
bitbucket showed you the way to extract parts from a date/datetime datatyped column.
In all other cases I advise to your convert to put date/datetime datatyped columns is a certain way.
Convert...
October 18, 2009 at 2:05 am
Apparently there is a little bug in this create statement !!
It works if you first specify the start date and then the expire date !
CREATE CERTIFICATE DavesCertificate
WITH SUBJECT =...
October 14, 2009 at 8:06 am
BOL sql2005 topic "sys.server_principals" states:
modify_date datetime Time at which the principal definition was last modified.
With all my sql2005(sp3) instances, it contains the actual modification date of the...
October 12, 2009 at 2:24 am
In that case, check your databases ! One of them (if not all) may contain a wam_bam schema name !
And the user may have that schema name as default schema,...
October 12, 2009 at 1:04 am
Viewing 15 posts - 3,391 through 3,405 (of 7,503 total)