Viewing 15 posts - 586 through 600 (of 49,552 total)
This feels like it is a presentation issue and should...
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
December 13, 2017 at 3:08 pm
It's the column 'modification_counter' in sys.dm_db_stats_properties.
You don't need to use a cursor for object ID and stats ids. You can use CROSS APPLY to pass them.
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
December 13, 2017 at 2:27 pm
Interview question?
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
December 13, 2017 at 5:04 am
The root reason is that fragmentation impact large range scans from disk. Emphasis *large* and *disk*. If the table is small, then fragmentation will have minimal effect and can probably...
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
December 13, 2017 at 3:59 am
Keep in mind that application name can be pretty easily spoofed. It's set by the connecting application.
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
December 12, 2017 at 11:58 pm
How big is the index? iirc, by default Ola's script ignores small indexes that don't need to be rebuild/reorganised.
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
December 12, 2017 at 11:57 pm
giri10488 - Tuesday, December 12, 2017 4:20 PMyou can also test it & will definately see that it will resolve space issue.
No,...
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
December 12, 2017 at 11:49 pm
Dividing TempDB won't do anything about space problems. If TempDB is 250GB, it's 250GB, doesn't matter if it's 1 file of 10.
If TempDB is getting full, your options...
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
December 12, 2017 at 4:06 pm
Get the queries optimised. The chance that you have a spinlock problem is small.
Most performance problems are bad queries, bad indexing. Address those. Don't go looking deep into...
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
December 12, 2017 at 3:42 pm
Spinlocks, for the most part, are not going to be an indication or guide for why a query is slow. They're something that you can and should ignore inmost cases. 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
We stand on the bridge and no one may pass
December 12, 2017 at 12:59 pm
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
December 1, 2017 at 9:39 am
I noticed theuse of a dozen or so left outer joins. After...
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 29, 2017 at 12:48 pm
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 29, 2017 at 12:42 pm
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 29, 2017 at 12:41 pm
Have at least 6 months income in the bank before you quit your job. More is better. It'll be slow to start, and you will have periods with little 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 26, 2017 at 11:06 am
Viewing 15 posts - 586 through 600 (of 49,552 total)