This is deferred resolution and it...

Stored procedures are just sets of code, like a batch you'd run from SSMS.

you add a header with parameters like this:

create procedure MyProc

@myvar varchar(20)

as

Then you add the code...

mandeep_nyc (8/27/2012)

---

if you run the script as it is, it will fail because a GO is requried.

Secondly, I just ran this in a new database, and when creating the proc's...

kent_secher (8/27/2012)

---

That was my...

Clients typically don't start a process on the server and hold locks. When an application SELECTs data, and the data is returned, there are no locks held while the user...

djackson 22568 (8/27/2012)

---

Companies used to have/show loyalty to employees. As a result, employees were loyal in return. For a very long time companies have thrown loyalty out the...

Antares686 (8/27/2012)

---

This is great if your source is 10 million lines of code, but they still have to trace out the changes that caused the failure via the coders who...

Thanks, but...

I believe David...

ddriver (8/27/2012)

---

I don't think that Quickbooks should be held up as an example of quality software or quality software processes. I am really not surprised that they took ten million...

As Gail noted, you haven't given any details.

Have you run a DBCC CHECKDB? (DO NOT run the repair with data loss option).

Are there errors in the error log or from...

How does the client grab a lock? If your application is built to hold locks on tables, even for seconds, you are killing concurrency.

If there was a warning or non-critical error, things might work.

SQL Server is rock solid on this stuff. I never worry about this losing data from the server. Now my...

There are timeouts for clients, and when a client has a query running, there is some communication back to the client. I'm not sure that the timeouts are, but if...

shikhar_0511 (8/25/2012)

---

Actually the data consist of tonnage from each and every origin to each and every destination .... For the return trip from Texas a tonnage value of 0 will...