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...

Here is another MSDN tool that provides a visual guide to drilling down on the SQL Server technology stack.

Use these technical reference guides after you have made the conceptual architectural...

Old.. stable.. reliable.. and too expensive to replace.. that sounds like a description for most of us SQL Server developers and DBAs who have worked with versions 6.5 - 2008....

About four years ago, I was involved in a project to migrate several SQL Server 2000 databases to 2005. One of the 2000 servers hosted a database containing transactional records...

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

---

Hope not, but...