Viewing 15 posts - 19,861 through 19,875 (of 22,213 total)
You can associate a table or an index with a filegroup. This allows you to control placement on various disks, setting groups to be read only, backing up by group....
July 29, 2008 at 8:07 am
The problem is, the error isn't some little connection error or a tsql error. The program isn't initializing. You've got something mucked up at a low level.
July 29, 2008 at 5:36 am
More often than not, locking is handled just fine by SQL Server. Don't start adding lock hints until you run into a problem, and possibly, not even then. Usually adjusting...
July 29, 2008 at 5:34 am
It'll take me a while to dig it out of the archives, but we found a situation a few years ago that showed it wasn't all that hard for a...
July 28, 2008 at 10:38 am
Oh man, I missed that article. Great job. Sweet solution. Here I was going to suggest possibly using XML depending on the size of the array. Never mind.
Do what...
July 28, 2008 at 7:24 am
Or, since it's not always possible to capture a transaction while it's open, use Profiler to set up a trace and capture the output from your procedures to a file....
July 28, 2008 at 7:13 am
I have not. I do know a consultant that's worked in that range. You should give Andy Novick a call. Here's his web site: http://www.novicksoftware.com/%5B/url%5D
July 28, 2008 at 7:10 am
There isn't a "right" number for a lot of these values. It really depends on the system you're on. Simply collecting one set of values is usually not enough. We...
July 28, 2008 at 7:05 am
I can't recommend enough that you develop in 2005. Work you do on a 2000 box might not work in 2005 and there are a ton of things you can...
July 28, 2008 at 7:00 am
Tons to learn then.
First, make sure you've got a good backup strategy in place. Before you worry about monitoring and all that stuff, protect your data.
Also, you should schedule a...
July 28, 2008 at 6:56 am
If you're trying to control locking through the procedure, it certainly could be the proc locking itself. Rather than try to put more and more locks on, I'd suggest putting...
July 28, 2008 at 6:52 am
There's also a section in Books Online on OUTPUT PARAMETERS specifically. It not only talks about creating them within procedures, but the syntax on how to use them to call...
July 28, 2008 at 6:44 am
If you absolutely MUST use dynamic SQL, make it parameterized instead of a concatenated string. You can then call sp_executesql and pass the appropriate paramters.
July 28, 2008 at 6:40 am
I do believe that we're making buggy whips and at some point a horseless carriage is going to drive by, but it's not in sight at the moment, despite the...
July 28, 2008 at 6:32 am
Viewing 15 posts - 19,861 through 19,875 (of 22,213 total)