Viewing 15 posts - 91 through 105 (of 117 total)
To calculate the maximum attempts it would take to crack a password. You need to take the number of allowable character values and raise that value by the number of populated...
March 15, 2007 at 6:41 am
Nice article. We only use SA for database ownership and sometimes for SQL Job
ownership. It is never used for connecting to the server because no one knows...
March 14, 2007 at 7:16 am
I enjoyed the article. Can this application be built with Visual Basic Express Edition?
March 13, 2007 at 7:18 am
-- Maybe this SQL will Help
-- From http://www.sqlmag.com/Article/ArticleID/26950/sql_server_26950.html
SELECT perf1.object_name, perf1.counter_name, perf1.instance_name,
'value' = CASE perf1.cntr_type
...
January 8, 2007 at 12:43 pm
I found the short videos from http://www.jumpstarttv.com/ are helpful.
September 15, 2006 at 8:58 am
I have been experiencing this problem on a couple of servers that have SQL Server 2000 SP4 installed. There appears to be plenty of space on the drive and auto...
June 21, 2006 at 7:22 am
Here is another link that dicusses this option
http://www.sqlskills.com/blogs/kimberly/PermaLink.aspx?guid=8be9d388-b354-429f-8c98-e45989a4bebe
There is also a webcast for SQL Server 2005 that reference this option. It is suggested maybe only 1 file per 2 processors...
April 27, 2006 at 7:40 am
Thanks for the all the feedback and the spreadsheet. I thought I try to respond to some of the comments.
Litespeed free un-compress utility:
I did not test this tool, instead I...
March 29, 2006 at 7:23 am
Here are some links:
http:// antivirus.about.com/b/a/251096.htm?terms=mcafee+4715
http:// vil.nai.com/vil/content/v_138884.htm
Editor's Note: The URLs are malformed so it does not trip AV products
March 15, 2006 at 7:25 am
The problem I find with developers creating stored procedures is the need to have database owner authority. I promote the stored procedures to production but they have full control in...
February 3, 2006 at 11:36 am
I was wrong about having a 4 drive server. The C:/K: is actual a 2 drives Raid 1. The other drive E is made up of 4 drives raid 3. ...
November 30, 2005 at 8:37 am
You will aslo need to consider where to put your database and transaction log backups. They can consume a lot of space.
November 30, 2005 at 6:44 am
These servers are all setup for broadcasting. I checked Server Network Utility settings and they are not setup to be hidden.
These servers are setup with default instance using TCP/IP and...
November 10, 2005 at 7:57 am
3605 Sends trace output to error log.
For all trace values see http://www.extremeexperts.com/SQL/Articles/DBCCTraceFlags.aspx
The trace seems to be permanent until the instance is stopped/started.
To keep it permanently, these trace flags need...
March 30, 2005 at 6:42 am
I've used the COLUMNPROPERTY to Identify tables with Identity columns.
SELECT Distinct Table_Name,MAX(COLUMNPROPERTY (OBJECT_ID(Table_Name),Column_Name,'IsIdentity')) as Id
FROM INFORMATION_SCHEMA.COLUMNS (NOLOCK)
GROUP BY Table_Name
March 23, 2005 at 8:10 am
Viewing 15 posts - 91 through 105 (of 117 total)