Viewing 15 posts - 4,351 through 4,365 (of 49,552 total)
Yes it is.
It'll be a CHECK constraint.
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 5, 2015 at 9:29 am
Fragmentation in heaps is completely different to indexes. For indexes it's logical fragmentation. Heaps have no logical order, so they only have extent fragmentation.
To be honest, if you have a...
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 5, 2015 at 9:25 am
Grant Fritchey (11/5/2015)
I'd strongly suggest looking at Excel and, maybe even more importantly, PowerBI. the technology is wildly different from what we think.
PowerBI is very pretty, and it's pretty easy...
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 5, 2015 at 9:19 am
river1 (11/5/2015)
If I add an additional transaction log (on other disk) to the database that would devide the i/0 between logs . which would help, correct?
No, it wouldn't.
SQL does 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
November 5, 2015 at 9:18 am
Profiler takes latches to sync the display with the server activity. It'll have minimal impact on a server that's got a light workload. As the workload increases, so Profiler's impact...
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 4, 2015 at 5:24 pm
Jeff Moden (11/4/2015)
ramyours2003 (11/4/2015)
is running a profiler will make the tempdb grow?Depending on where you run it from and how you run it
Profiler can fill up the local...
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 4, 2015 at 4:35 pm
Yes, your use of profiler GUI was the culprit.
NEVER use the Profiler GUI against a production server. It will degrade performance, potentially severely, it can crash the server. Use a...
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 4, 2015 at 4:32 pm
yb751 (11/4/2015)
Also as Gail's answer eluded to, it only helps if those tables have an index. If you have any heaps you are out of luck.
No, index usage stats...
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 4, 2015 at 1:44 pm
That's not automatic stats update, that's a manual update job. If you're seeing that every 20 minutes, then you have a SQL Agent job that's scheduled to run every 20...
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 4, 2015 at 12:31 pm
Yes and no.
You can use the DMV sys.dm_db_index_usage_stats, however that only has data back to the last time SQL Server started
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 4, 2015 at 11:19 am
Consider querying the system tables - sys.partitions or sys.dm_db_partition_stats.
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 4, 2015 at 11:13 am
Always set max server memory. It's not the VMWare admin's job, it's the DBA's job, it's changed in SQL's server settings.
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 4, 2015 at 11:12 am
No. Not unless you selected the option to save to table and specified the TempDB database
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 4, 2015 at 10:41 am
You change it at the server level, availability groups are at the database level, they don't transfer server settings. Change it on all servers, it might not be set 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 4, 2015 at 10:34 am
Compatibility level affects how the parser, query optimiser and query processor treat some T-SQL constructs (ones that have changed across the versions). It doesn't change the database version, that's defined...
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 4, 2015 at 10:27 am
Viewing 15 posts - 4,351 through 4,365 (of 49,552 total)