Viewing 15 posts - 10,936 through 10,950 (of 49,552 total)
Sessions that are sleeping are not doing anything, therefore they cannot be currently using CPU. A session that is currently using CPU is in the RUNNING state.
SOS_Scheduler_Yield is not an...
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
November 14, 2013 at 9:47 am
Define the column as not nullable and specify a default or use ISNULL(<column name>,0) when querying.
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
November 14, 2013 at 9:45 am
Stale stats or bad plan in cache to be honest.
The optimiser has no knowledge of fragmentation, so that won't change plans, usually when rebuild fixes query problems it's actually the...
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
November 14, 2013 at 9:44 am
No. Updating stats on the table updates all the stats on that table, index and column.
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
November 14, 2013 at 8:31 am
bala2 (11/14/2013)
We have more than 50 tables on that database.Is there any other way to do that or
TO change the collation all at a time.
If you want to 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
November 14, 2013 at 7:34 am
Ed Wagner (11/14/2013)
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
November 14, 2013 at 7:33 am
Are you sure that updating stats with fullscan doesn't help? Changes in estimated rows before/after is usually indicative of statistics-related problem (or bad parameter sniffing).
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
November 14, 2013 at 7:30 am
It doesn't make much sense usually. There are edge cases where the narrow nonclustered index can be useful because it's narrower and hence faster to use, but that requires specific...
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
November 14, 2013 at 7:28 am
Bhuvnesh (11/14/2013)
mpradeep23 (11/13/2013)
how do i join tables with out joins
You can .... for that you have to do table level changes like merging two tables (which contains parent-child...
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
November 14, 2013 at 5:42 am
All the alter database does is change the default collation that new objects will use. If you want to change existing objects, you need to run an ALTER TABLE 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
November 14, 2013 at 5:41 am
Not enough information.
Please post table definitions, index definitions and actual execution plan (as a .sqlplan file)
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
November 14, 2013 at 5:39 am
Remove the hint unless there is no other way to get the optimiser to choose the index that you know to be best, you know why the index you're hinting...
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
November 14, 2013 at 5:39 am
I still recommend considering a check constraint instead of the trigger.
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
November 14, 2013 at 3:13 am
That said, a check constraint would probably be a better choice than a trigger here.
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
November 14, 2013 at 2:05 am
Your trigger is checking the entire table, not the rows just inserted. So if there's any blank values anywhere in the table, the trigger will fail. You probably want to...
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
November 14, 2013 at 1:53 am
Viewing 15 posts - 10,936 through 10,950 (of 49,552 total)