I experimented with query hints on tables because I had a large batch job that is only run when no-one else is on the box.

The original query showed up a...

You would be better off finding what it is that causes the locks and modifying the stored procedures accordingly.

In addition to the points raised by Chris Cubley I should like...

As far as optional arguments/parameters is concerned, if there are a large number of them then I switch to using ORs simply because writing a SQL stored procedure that produces...

I would suggest that this is a documentation issue and development practices issue.

Unfortunately, once an organisation grows beyond a certain point formal documentation and methodologies become a necessity rather than...

Sorry, the forum interpretted my HTML entities m etc

Yes you can spider dynamic pages. We use Thunderstone's Webinator as a search engine with a database driven content management system.

One way of blocking the harvesting of e-mail addresses...

You really get a feel for the performance downside of dynamic SQL if you develop web applications.

In most cases the difference in cost between dynamic and static SQL is very...

As I am running the personnal edition of SQL Server on my laptop I have a sneaking suspicion that the error is caused by a conflict between other software running...

In my environment network administration is a separate function to SQL Server administration so I tend to use NT security and let the network administrator worry about resetting passwords.

The network...

Chances are there is something that needs to do a exclusive lock on the tables referenced by vw_CallList3 and someone or something has accessed your SQL statement.

Make a list of...

One of the many CMS's is called OBTREE. There are no physical files at all.

Absolutely everything is stored within a database and served out to pages via...

Does anyone on this site work for a vendor?

If so, could you chip into this discussion?

Someone got caught on Amazon hyping their own book so the skewing issue is real.

I think that user reviews have to be

• Members only
• Prepared to say who they...

Steve,

How about posting a "to be reviewed" notice on a product then those of us who use the product can submit our experiences.

Keep it as a submissions only i.e. only...

As an aside, I worked through the MS XML SQL Server programming book and having got through lots of interesting and useful stuff on updategrams etc the book finally said...