Viewing 15 posts - 41,176 through 41,190 (of 49,571 total)
sqlfriend (2/9/2009)
Hi, just got an update: It's 14 filegroups with one file each. They are all on the same SAN/LUN based on several physical drives.
If they are all on...
February 9, 2009 at 10:04 am
Parameter sniffing, or more accurately the lack of parameter sniffing. SQL doesn't know the values of the variables at compile time and hence guesses the rows affected. If it guesses...
February 9, 2009 at 10:00 am
Barkingdog (2/8/2009)
February 8, 2009 at 1:38 pm
Why use intersect? If you're looking for matches, join the tables
update D
set isspecial = 1
from D inner join M on D.c1 = M.c1 AND D.c2 = M.c2 AND D.c3...
February 8, 2009 at 1:37 pm
timothyawiseman (2/8/2009)
They are not redundant since they have different total indexed columns and completely different included columns.
They are redundant because the index key columns of one is a left-based subset...
February 8, 2009 at 1:34 pm
Jeff Moden (2/8/2009)
February 8, 2009 at 9:29 am
Is the load the same on the two servers (number of concurrent users, concurrent queries)? Is the data size the same on the two servers?
February 8, 2009 at 8:54 am
Check the SQL error log on the secondary, see if there's any error messages.
Check the primary server, make sure no other log backup job exists (where the logs aren't been...
February 8, 2009 at 8:51 am
Lowell (2/6/2009)
February 7, 2009 at 2:11 pm
Please can you post sample data and expected results here. I'm not fully understanding what you want, I think it's simple, but am not sure. We could be asking for...
February 7, 2009 at 2:01 pm
Gift Peddie (2/7/2009)
And in 2000 have had orphaned user while restoring and while creating new accounts because the account was created in the Master but not in the database
That's not...
February 7, 2009 at 10:46 am
You need to use the FROM clause of the update
UPDATE #Tags
SET [Count] = TotalCounts
FROM #Tags
INNER JOIN (
...
February 7, 2009 at 10:42 am
What do you mean by 'wrong row joined'?
Order by is evaluated way after the joins are done, it's the last clause that gets evaluated.
Can you post table structure, some sample...
February 7, 2009 at 10:35 am
Gift Peddie (2/7/2009)
February 7, 2009 at 10:32 am
Since you're using 2005, use traceflag 1222 for deadlock graphs, rather than 1204. It's a lot more detailed.
Tracefag 1206? why is that enabled and what does it do?
February 7, 2009 at 2:16 am
Viewing 15 posts - 41,176 through 41,190 (of 49,571 total)