I also agree with the others, but to answer your question: No, it is not possible to block an IP after failed logins. It is actually not possible to use...

As I explained in my other posting (in response to the article itself), any lack of performance is not a fault of the relational model but of the implementation of...

I don't want to make this into any kind of flame war or anything, but I must address a couple of points here. I do not know what Frank Kalis...

quote:

---

Is there a way to determine the number of rows in a page?

---

DBCC SHOWCONTIG (tablename)...

quote:

---

quote:

---

Other strange things happening include SQL performance counters present on one day, missing...

The easy answer: As much as possible. SQL Server will by default dynamically adjust it's memory and use as much as it can. If you don't have any other applications...

SELECT COALESCE(NullColumn, 0) FROM ...

This will output the value in NullColumn if it is not null, otherwise 0.

--

Chris Hedgate @ Extralives (http://www.extralives.com/)

Contributor to Best of SQL Server Central 2002 (http://www.sqlservercentral.com/bestof/)

Articles:...

quote:

---

I hate to reinvent the wheel. If someone has this tool I would love a copy. If not I will...

Please see my latest article Dealing With Changing Data for examples on how to do this. Use the link for articles in my signature.

--

Chris Hedgate @ Extralives (http://www.extralives.com/)

Contributor to Best...

I think the best solution would be to save all datetimes in utc-time. Then you could convert to whichever time zone / format you want for presenting it. Unfortunately though...

!

--

Chris Hedgate @ Extralives (http://www.extralives.com/)

Contributor to Best of SQL Server Central 2002 (http://www.sqlservercentral.com/bestof/)

Articles: http://www.sqlservercentral.com/columnists/chedgate/

I am using an empty resultset if user does not exist instead of returning a 0 in user_exists.

SELECT 1 AS t1.user_exists

 , t1.user_loginattempts AS login_attempts

 ,...

I forgot to mention one thing. The Oracle function SYS_EXTRACT_UTC that you mention is exactly what we would need in SQL Server to solve this problem easily. And from what...

Dinesh, please note that GMT and UTC is not exactly the same thing. As I discussed in my article SQL and Java go on a Date (http://www.sqlservercentral.com/columnists/chedgate/sqlandjavagoonadate.asp), UTC adds a...

I would also like to hear about any results from testing this. The thread kind of lost focus, so I'll bring it back by simply asking how much memory can...