One reason why a 40% increase in data growth translates into only a 5% increase in IT budget is that our hardware and database server platforms are designed to handle...

One thing that will attract talent to a company is when they publish technology solution case studies in trade publications or on their website. There have been occasions where I...

Well, if he doesn't even know what the technology is called, then even Google and MSDN won't help him. I...

drew.georgopulos (3/18/2012)

---

During a discussion about virtualizing servers, I suggested we migrate just data that we knew for sure was in use. The idea instigated a riot among the developers...

Here you'll find all the SQL Server storage internals information you can handle and then...

I typically code stored procedures using an output parameter that is also a return code. When the procedure executes to completion, the @status variable will have a return value of...

There are tools downloadable from Microsoft to stress the I/O and consume memory in a general way.

Also, using SQL Profiler, you can capture T-SQL events on one server, and...

Here is another script to compliment the scripting of logins and permissions; it will tell you what domain accounts have sysadmin access.

Query accounts, domain groups, and members who have admin...

Here is one reference to login error 80040e4d:

http://support.microsoft.com/kb/222828

For...

Steve Jones - SSC Editor (3/13/2012)

---

...

Another one. If I have remote ATMs and I upload balances to it every night. Someone comes to withdraw $40 from it. Do I need...

It fails in what way; what is the error?

If multiple processes are simultaneuously selecting and deleting a large number of rows from the same table, there could be blocking...

Anam Verma (3/5/2012)

---

Please advice what can i use to trace cross database queries.

What i mean is, say a login XYZ can access multiple databases. If XYZ connects to database...

In the case of Google and other search engine companies, I don't think they're talking about transactional consistency but rather allowing for some marginal degree of inconsistency across distributed data...

ron.grace (3/8/2012)

---

I have a form that returns order details based on the input received in 4 parameters

using the following WHERE clause

WHERE HOrder.Acno = @Acno and

SUBSTRING(HDespatch.ArcOrdno,1,4) = @Unit and

SUBSTRING(HDespatch.ArcOrdno,5,8) >= @FromDate...