Viewing 15 posts - 1 through 15 (of 40 total)
0 means dynamic, it configures itself according to the number of CPU's and x86/x64 version.
In general you should leave this value for what it is since the default is usually...
July 23, 2007 at 12:35 pm
That is something you will have to take care of yourself.
Using that last offset of the primary key and the TOP statement can help you out.
July 23, 2007 at 12:29 pm
When you need to keep different environments synchronized it is harder with an identity since out of sync issues will occur. A simple rollback, script executed in a different order,...
July 23, 2007 at 12:29 pm
Have you checked the Full Text Search engine included in SQL Server?
July 12, 2007 at 12:22 pm
Clustering is not used for load balancing.
When dealing with quantities like this it comes very much to having the proper hardware (CPU, memory and storage). This in combination with the...
July 12, 2007 at 12:21 pm
Great.
But I'm missing something, why is the cursor needed here?
Wouldn't the following code do the same?
Declare @CNT int
select @CNT = count(*)
July 6, 2007 at 12:31 am
Have you installed it with a case sensitive collation?
July 5, 2007 at 1:51 pm
Locking is used to guarantee consistency.
If you would be able to 'steal' a lock in the middle of a transaction it would break down the whole point of locking.
July 5, 2007 at 1:50 pm
Nice one Colin 🙂
Make your supervisor invests in faster servers and a better storage subsystem, that would help too 🙂
July 5, 2007 at 1:47 pm
Which error are you getting?
Are you using Conn.Execute("exec msdb..sp_start_job @job_name='ABC'")?
Or something like that, it's been a while since I've used VBScript 🙂
July 5, 2007 at 1:41 pm
Can you run SQLIOSim on those disks?
This can help you proof that it is a hardware (or driver) problem.
July 5, 2007 at 1:39 pm
I have a couple of points to remember on my blog.
There is a great blog series on the Microsoft SQL Server Development Customer Advisory Team Blog.
July 5, 2007 at 1:29 pm
I agree that it is a bandage.
Using the IGNORE_DUP_KEY skips the records that would create duplicates with a warning "Duplicate key was ignored.". It should be carefully considered but if your...
July 5, 2007 at 1:24 pm
What happens if you run a DBCC CHECKDB with DATA_PURITY?
July 5, 2007 at 1:14 pm
Viewing 15 posts - 1 through 15 (of 40 total)