Viewing 15 posts - 2,371 through 2,385 (of 3,232 total)
Can you post the full table DDL including the indexes and the execution plans for both queries?
March 16, 2007 at 1:59 pm
Is this on a server class machine? Where is your T-Log physically located? How big is your T-log? TempDB? Make sure there is not any virus scanning software running that...
March 16, 2007 at 1:51 pm
'don't quite follow all the query rewrites ?? '
Colin, I played around with re-writing the IN clause to a JOIN out of habit. Although the improvement is only slight, I have...
March 12, 2007 at 9:53 am
I think you lost me here. It will be a big help (to you) to include an example including DDL and sample data and your desired result.
March 9, 2007 at 2:38 pm
I would say that your only two real options here would be to use Simple recovery mode or to truncate your log file in between each major data manipulation step. ...
March 9, 2007 at 2:36 pm
Here's a good thread to reference....
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=328228
March 9, 2007 at 1:49 pm
This is a pretty straight forward error message and it means exactly what it says. Something has changed your table schema while the cursor was open. If you can reproduce this,...
March 9, 2007 at 1:33 pm
PW's correct. It is difficult without knowing your data. Along with changing your UPDATE, you may also benefit from a covering index on TableB Root, Status. Here's an example that...
March 9, 2007 at 1:09 pm
On another note, you really do not need to be using dynamic SQL here. I stayed with it for my example, but if you are passing in the object name...
March 9, 2007 at 9:31 am
I think for what you want to do here, this is not really a question of handling the error. What you want to do here is to check for the existance...
March 9, 2007 at 9:30 am
If you can restore it using EM and your SP_WHO2 does not show connected users, your restore should work. Are you sure you are restoring to the correct DB? Are...
March 8, 2007 at 4:07 pm
Basically, just like you did in the SELECT clause.
declare @such nvarchar(52)
set @such = '%' + @Suche + '%'
SELECT
ResponsibleNI,
isnull (ResponsibleBZ1, ' ') as ResponsibleBZ1,
isnull (ResponsibleBZ2, '1') as...
March 8, 2007 at 3:52 pm
I'm not real sure what you are trying to do here, but your query will not return any rows if either ResponsibleBZ1 or ResponsibleBZ2 are NULL. A NULL value +...
March 8, 2007 at 3:19 pm
The table name is Employee. EmployeeID, FirstName, LastName, and HireDate are all column names. They've separated the EmployeeID column so that they could mark it as being the Primary Key.
March 8, 2007 at 3:15 pm
Converting it to an integer will not get you what you want. The result of COUNT() is an integer. Since integers are whole numbers, dividing integers by integers will generate a...
March 8, 2007 at 10:56 am
Viewing 15 posts - 2,371 through 2,385 (of 3,232 total)