Viewing 15 posts - 41,161 through 41,175 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 8, 2009 at 1:34 pm
Jeff Moden (2/8/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 8, 2009 at 8:51 am
Lowell (2/6/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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 (
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 7, 2009 at 10:35 am
Gift Peddie (2/7/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 7, 2009 at 2:16 am
Back the log up more often. Maybe hourly. The more often you back it up, the less likely it is to grow large.
You can shrink it, but unless you change...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 7, 2009 at 2:12 am
peace2007 (2/7/2009)
However, it doesn't let me change the properties, is there any other way to do that?
Alter database. Check BoL, it has an example on moving tempdb on the alter...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 7, 2009 at 2:10 am
Separate filegroups, or all in primary?
If you have lots of filegroups will small tables, I'd probably try merging them and dropping the empty filegroups, on dev (of course) and testing...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 7, 2009 at 2:03 am
Paresh Prajapati (2/5/2009)
I asked network peoples but the don't know how this is access by from this IP..
Ask them to find out. Network security is their business and an unknown...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 6, 2009 at 1:46 pm
Viewing 15 posts - 41,161 through 41,175 (of 49,552 total)