Hi there

As an example, ive seen it used to supplement a complex tax calculation, where its calculated once so subsequent queries just use the value rather than applying the function....

Ok

Im in the process of repopulating the catelog, basically, nothing wrong with the install. The interesting one here is that from my client pc's EE, i created the catelog...

Hi

I have been using sqlprobe (netiq bought it recently) for around 6 months now. Its a good product, ive had some issue with memory exception faults, clashing with IE...

Hi there, ok, I should have picked up on that one. I will have a another look at this at work, I can see how this may work, but...

thanks for the feedback, the code is from an app we purchased. i can get some idea from the types of locks taken out but would love to confirm...

Hi all

Ive done a bit on testing on my ss2k sp2 databases with updating stats, usage and reindexing, every time, a % of the tables produce an inaccurate count of...

Excellent, much appreciated, ill have a good read.

Very interesting, thanks for the help. Ill give it a go later today.

Cheers

Ck

Nice article steve. I had the same problem a while ago, I did basically the same thing with a command file for the command line ftp with a cmdshell...

Hi there

Very interesting and thanks for the post. Ill do some testing of my own later with the INTO clause and re-check some of our new stored procs with...

Brian

Perhaps we need a count of online people in the menu (under the Home | Articles) area for example, clickable to go to the chat room.

Just a thought.

Cheers

Ck

(not the Jeans...

hmm.. id be very supprised if sqlserver escalated the lock to such a level that deadlocking occured, and I wouldnt call it a deadlock as such, just a prolonged wait....

Fixed, #$%%@ developers havent been de-registering their com's correctly causing an OLD com to be retained, SQLServer was instanciating it. We have recompiled the com, cleaned the reg, re-started...

Hi

Shoot! I would recommend looking at either this site for a script, or http://www.swynk.com for a similar script. Id imagine someone would have this requirement and use...

Hi

Open EM, script db, select ll tables/views, select "script user and roles", this will script the role and all its privs so long as you included the tables/views/t-sql its trying...