Viewing 15 posts - 136 through 150 (of 824 total)
Are you talking about the "black box" trace?
The only other thing I can think of is that transaction logs in SQL Server are sometimes referred to as "circular". Of course...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
January 8, 2007 at 1:39 pm
Try this:
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
January 8, 2007 at 1:36 pm
I forgot to mention that if you are auditing logins (successfull) you might be able to put together a WAG. Since most logins tend to be tied to one database...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
January 8, 2007 at 1:23 pm
Unless you've been running a trace I think you're pretty much out of luck with the sql server 2000 instances.
With 2005 the situation is a little better since you...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
January 8, 2007 at 1:19 pm
We aren't using mirroring, but for our log shipping targets I scripted out the maintenance jobs and created them on the target server, but disabled them. In case we need...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
January 8, 2007 at 1:15 pm
Absolutely! However, in a DW situation it isn't likely that it is a user transaction causing this, it is more likely that this is being caused by either the ETL...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
January 8, 2007 at 1:13 pm
I'm afraid that this one is going to be ugly. There is no way to do this (that I know of) other than scripting out all your database objects in...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
January 5, 2007 at 1:31 pm
The problem is that application development and database design require two totally different skillsets and mindsets. I've never met anyone who could effectively do both. I've met a bunch of...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
January 5, 2007 at 9:04 am
99% agree with Joe here. I can always tell when a database has been coded by an application developer(s) they are universally terrible. Keep them separate and design the database...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
January 5, 2007 at 8:53 am
Call me a "purist" or whatever, I don't care. This article is well written and this kind of stuff is fun and interesting (in limited quantities), but it is also...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
December 14, 2006 at 3:13 pm
Not a stupid question at all... The answer however is debatable...
You don't.
In SQL 2k you could run
select serverproperty('LicenseType')
But...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
November 3, 2006 at 9:48 am
I have had servers with over 1200 concurrent connections that work fine with the default value for worker threads. Worker threads are a pooled resource and you might not even...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
November 3, 2006 at 9:20 am
That's just the amount of time represented in the graph. The value isn't directly editable, but if you right click on a counter and go to the General tab, if...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
November 2, 2006 at 3:56 pm
Using Unicode made no difference. I just created a new column (Col2 nvarchar(24)) and ran the same queries (only the where clause changed to Col2) and got exactly the same...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
November 2, 2006 at 11:58 am
I have pretty well settled on a standard (but evolving) list of questions that I have available. However, unless I'm really grilling a senior level candidate I won't ask them all. ...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
November 2, 2006 at 10:57 am
Viewing 15 posts - 136 through 150 (of 824 total)