It would be possible to do but you would need to use a cursor which hurts performance. Why don't you return multiple recordset for each color and if...
As others have noted clustering offers no advantage in performance but it does offer failover in case your SQL server goes down the other server in...
I was just reading this article today and I thought others may find it interesting. It shows what most of us have known which is Opteron scales very...
We are planning to rebuild our SQL Server with an upgraded version of OS and I was wondering which way is the perferable method of getting old...
If you are buying the Opteron, Microsoft has not released a full version of either OS or SQL Server 64 bit version. Of course you can still run the...
We are planning on doing SQL Server upgrade OS from Windows 2000 Server to Windows 2003 Server. We would also need to upgrade SQL Server SP from 2...
One option is to create a select statement with NOLOCK on it but this will result in reading dirty data so you can read rows thats in an uncommitted...
Also it looks like Intel is moving to x86-64 architecture to be compatible with Opteron in next version of Xeon. Its gonna be called Nocona...
I would advise against setting any timeout to 20 mins. You could have a rogue code that can set exclusive locks which is just gonna hold onto the...
Try capturing the insert in the profiler and you can check to see which part of trigger is taking long time to finish. Sounds like there is a lock...
Another option is to get rid of the trigger to speed up the insert process and create a seperate application or database job that runs every few...
To debug on a local machine it takes no configuration as SQL Server can do it out the box but to do a remote debug it takes installing remote debug...
I currently work as a developer here at our company and recently got the job of DBA added onto my role. We are currently running Dell Poweredge 6400...
You probably need a third party utility for this occasion. Performance monitor lacks really good features when you need to keep good logs of...
Does dbreindex increase the log files to huge size also. I notice the log dumps in the morning after the dbreindex job the log files are huge in...
I am trying to join two tables in a statement and let's say I have a table A and table B. Table B has one or more records for each record in table A...
So does this mean you shouldn't shrink the database at all unless you want fragged database file?
Windows 2000 Server SQL Server 2000 Enterprise SP2 running in 6.5 compatibility mode due to accounting package MAS 500 requiring it.
Also would reindexing be logged because it appears the log file was about 5 gigs in size when it normally is about 50 to 100 megs.
But we have a same job that does the reindexing also doing a db shrink job. Shouldn't that get rid of all the extra space created by reindexing?
Separate names with a comma.
